RE: Latch Free / Shared Pool on Fetch

From: Raj Jamadagni <rjamya_at_yahoo.com>
Date: Thu, 1 Jul 2004 04:11:26 -0700 (PDT)
Message-ID: <20040701111127.46691.qmail@web50002.mail.yahoo.com>

• John Kanagaraj <john.kanagaraj_at_hds.com> wrote: [snipped]
  > One of my frustrations with the 10046 trace is that it does not
  > snapshot/record data from v$sesstat, which I believe could yield some clues
  > or at least explain where c=<> was possibly consumed. Not bashing the 10046
  > trace, just pointing out a helpful but missing item....
  [snipped]

I tihnk in about 2001 or 2002 I logged an enhancement request to provide additional level for 10046 to include v$mystat (or sesstat) at the beginning and end of the trace, but "since the ability to dump process state exists and the data is already included in process state dump, your enhancement request is not feasible" was the reply from Oracle.

So, I created a generic procedure that can bve used to start and stop trace. At the start it dumps v$mystat to the tracefile and once again at the end using dbms_system.ksdwrt. Only thing I don't know how to fix is if someone added a tracefile_identifier later, things got out of hand.

Best regards
Raj

---

Best Regards
Raj

---

select mandatory_disclaimer from company_requirements;                 

---

Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 01 2004 - 06:08:06 CDT