Re: Find all SQLs run from one session

From: winkie wan <winke_at_163.com>
Date: Tue, 23 Aug 2005 13:23:53 +0800
Message-ID: <deebtb$hfr$1@news.yaako.com>

Would you like to use sql_trace + tkprof?

The utility "tkprof" has a parameter named record. refer to:
tkprof
Usage: tkprof tracefile outputfile [explain= ] [table= ]

[print= ] [insert= ] [sys= ] [sort= ] table=schema.tablename Use 'schema.tablename' with 'explain=' option. explain=user/password Connect to ORACLE and issue EXPLAIN PLAIN. print=integer List only the first 'integer' SQL statements. aggregate=yes|no
insert=filename List SQL statements and data inside INSERT statements. sys=no TKPROF does not list SQL statements run as user SYS. *record=filename Record non-recursive statements found in the trace file.*

"Randi W" <randiwolner_at_hotmail.com> wrote in message news:debvnu$ibt$1_at_services.kq.no...
> Is it possible by querying system tables to find all sql-statements that
> have been run from one session?
> What tables/views should I look into to find this?
>
> Thanks for your help,
> Randi W
>
>
Received on Tue Aug 23 2005 - 00:23:53 CDT