IN ORACLE MILIEU …

Beyond Knowledge

Tag Archives: journal table

An insight into Oracle Index rebuild

2 Comments Posted by on April 12, 2011

You must have gone through my previous article on Oracle Index rebuild – 10g Vs 11g – http://avdeo.com/2011/03/17/oracle-index-rebuild-online-10g-vs-11g/ Well, there is another nice article written by a friend of mine Sumit Bhatia. He has talked about the actions and events happening while rebuilding an index online in oracle database 11g. Different wait events that we [...]

Oracle Database 11g , , , ,

Oracle Index rebuild online – 10g Vs 11g

5 Comments Posted by on March 17, 2011

An index is basically used for faster access to tables. Over a period of time the index gets fragmented because of several DMLs running on table. When the index gets fragmented, data inside the index is scattered, rows / block reduces, index consumes more space and scanning of index takes more time and more blocks [...]

Oracle Database 10g, Oracle Database 11g , ,

Follow

Get every new post delivered to your Inbox.

Join 156 other followers