You are here10g
Investigate ROW CACHE LOCK when we found High "row cache lock' wait
Oracle DUPLICATE Without Connection to Target Database (11gR2)
If you have further doubts or want to ask the gurus, visit the Forum
I wrote about moving datafile in ASM
Moving database file from one ASM diskgroup to another
MOVING DATAFILE IN ASM BY ASMCMD(cp)
On Solaris, IP network multipathing (IPMP) provides physical interface failure detection and transparent network access failover for a system with multiple interfaces on the same IP link.
What is "INITRANS"?
Specify the initial number of concurrent transaction entries allocated within each data block allocated to the database object. This value can range from 1 to 255 and defaults to 1, with the following exceptions: (on10g MAX_TRANS 's ignored )
Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!
I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %
$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 12722 96.4 0.2 19560 4600 pts/5 R 15:36 0:06 sqlplus
So, found out on metalink... (338461.1)
SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time (Linux x86)
Used "strace" :
$ strace sqlplus -V 2>&1 |less