Henry Xie 's blog
Sunday, June 23, 2013
How To Identify Related DeadLock Sqls in LMD Trace file
›
After oracle db 11gR2, the dead lock sql information will be collected in LMD trace file for RAC You will see such infor in alert logs 20...
1 comment:
Wednesday, June 19, 2013
Oracle WebCenter Content Batch Monitor Sql
›
If you happen to use Oracle WebCenter Content and use it's replication technology , one of key monitors will be on indexer/archiver The...
Tuesday, June 18, 2013
How To Check RAC Interconnect is uing UDP or RDS
›
A simple to know is to use skgxpinfo under CRS Home CRS % skgxpinfo -v Oracle RDS/IP (generic) CRS % skgxpinfo -v Oracle UDP/IP (gene...
Monday, June 17, 2013
A Sql to find Long Idle Sessions on DB
›
Just share a sql below is about to find jdbc connections with idle for 8 days(28800/3600) select username,sid,serial#, (sysdate - prev_ex...
Thursday, June 13, 2013
Listener Can't start Due to CRS Issue
›
Sometimes we can't start listeners, see this error in logs: NL-08014: Failed to initialize Diagnosability framework, falling back to o...
‹
›
Home
View web version