Re: WAITING latch: row cache objects

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 12 Oct 2011 22:36:15 +0800
Message-ID: <CAM_ddu_k-tyqToyprPC5WYrMPEvVvUm9_R0mjYc0hnhOLySW9Q_at_mail.gmail.com>

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

Received on Wed Oct 12 2011 - 09:36:15 CDT