Re: WAITING latch: row cache objects

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: