Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail From: yong321@yahoo.com (Yong Huang) Newsgroups: comp.databases.oracle.server Subject: Re: See underlying recursive SYS statements in SGA ?? Date: 9 Sep 2004 07:14:12 -0700 Organization: http://groups.google.com Lines: 23 Message-ID: References: NNTP-Posting-Host: 129.230.241.5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1094739252 21067 127.0.0.1 (9 Sep 2004 14:14:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 9 Sep 2004 14:14:12 +0000 (UTC) Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224577 spendius@muchomail.com (Spendius) wrote in message news:... > 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