Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$sql how to distinguish between internal dictionary selects and user selects
<dbaplusplus_at_hotmail.com> wrote in message
news:1160953186.140479.157420_at_i42g2000cwa.googlegroups.com...
>I am on HP UNIX 11i using Oracle 9.2.0.5
>
> I am trying to wtite a program which will show me all the
> user/application selects. I do not want to print internal Oracle select
> satataemnts such as
> select text from view$ where rowid=:1
>
> I only want to print select statements exeuted by users or my
> application but not by Oracle.
>
> Is there a way to do it. Oracle documentation on columns of v$sql is
> cryptic.
>
The recursive and background SQL is largely parsed by SYS, so this might be a suitable starting predicate
Parsing_user_id != 0
-- Regards Jonathan Lewis http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.htmlReceived on Tue Oct 17 2006 - 03:04:23 CDT