Re: WAITING latch: row cache objects

  • From: Sidney Chen <huanshengchen@xxxxxxxxx>
  • To: grzegorzof@xxxxxxxxxx
  • Date: Wed, 12 Oct 2011 22:36:15 +0800

correct the typo on the systemdump command.
yup, latchprofx.sql is another choice to figure out the holder, and maybe
it's the faster way, leave you enough time trace the holder.


SQL> conn / as sysdba
Connected.
SQL> oradebug setmypid;
Statement processed.
SQL> *oradebug dump systemstate 1;*
Statement processed.
SQL> oradebug tracefile_name
/u01/app/oracle/admin/sid10g/udump/sid10g_ora_4537.trc


-- 
Regards
Sidney Chen


--
http://www.freelists.org/webpage/oracle-l


Other related posts: