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
SQL> oradebug setmypid;
Statement processed.
SQL> *oradebug dump systemstate 1;*
Statement processed.
SQL> oradebug tracefile_name

Sidney Chen


Other related posts: