IN ORACLE MILIEU …

Beyond Knowledge

Daily Archives: March 17, 2011

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