IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: March 2011

Exchange Partition in Oracle

5 Comments Posted by on March 30, 2011

Some times we faced a need to convert our existing table from non-partition table to a partition table or vice-versa. Or moving a partition of one partition table to another partition. Or make one of the table as a partition of some partition table. Or make a partition of one of the partition table as [...]

Oracle Database 10g, Oracle Database 9i , ,

Virual Index and Invisible Index

Leave a Comment Posted by on March 23, 2011

Oracle has come up with a feature called virtual index in oracle 9i. This feature allow us to test an index on a table without actually adding an index on the table. The table will be visible only in our session and will be used by our queries only (if optimizer decide it to use). [...]

Oracle Database 10g, Oracle Database 11g, Oracle Database 9i ,

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 , ,

WARNING: inbound connection timed out (ORA-3136)

Leave a Comment Posted by on March 17, 2011

Many times I faced this issue “WARNING: inbound connection timed out (ORA-3136)” in alert log and if you are using data guard, then you can see that dgmgrl status will show failed because standby is not able to sync up with primary. The “WARNING: inbound connection timed out (ORA-3136)” in the alert log indicates that [...]

ORA Errors, Oracle Database 10g , , ,

Follow

Get every new post delivered to your Inbox.

Join 156 other followers