Re: See underlying recursive SYS statements in SGA ??

If my memory serves me correctly, the information I've seen in X$TRACE is the stuff that appears on the PARSE, EXEC, FETCH, and WAIT lines. Specifically, I believe you'll not find your SQL text (from the PARSING IN CURSOR sections) in X$TRACE.

Cary Millsap

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0409090614.7286a009_at_posting.google.com...
> spendius_at_muchomail.com (Spendius) wrote in message
> news:<aba30b75.0409070615.68565550_at_posting.google.com>...
>> I'm rephrasing my last question: do you think it's possible
>> to view what are the SELECTs implicitly performed by Oracle
>> itself (on all SYS.*$ stuffs etc.) for a session otherwise
>> than through a trace/tkprof of this session ?
>>
>> Thanks.
>> Spendius
>
> Hi, Spendius,
>
> I don't think this is possible. v$sql shows recursive SQLs. But the
> challenge here is to find those recursive SQLs created or executed on
> behalf of your user session. Unfortunately, parsing_user_id and
> parsing_schema_id for those SQLs are 0 (SYS). First and last load time
> columns can't be used to make this association either.
>
> Cary Millsap says x$trace provides "a means to access extended SQL
> trace data through SQL". I don't see anything in there that looks like
> SQL trace output. He didn't give examples because this is undocumented
> and unreliable. See his "Optimizing Oracle Performance" p.55.
>
> Yong Huang
Received on Mon Sep 13 2004 - 10:11:27 CDT