Re: SQL TRACING FOR A PARTICULAR SESSION.

Hi,

But you did not mention that how should the text from these sql text files store into my table.
These sql trace files create when user logon.

I know TKPROF is the utility via which we can read these sql trace files.
But how should we read these text files dynamically(run time) and then stores the text of these sql trace files into an Oracle table(id,username, text) using logon/logof triggers etc.

Any useful suggestion will be appreciated.

Regards

Jaffery

Pete Finnigan <plsql_at_petefinnigan.com> wrote in message news:<miQZAkAYO8QARxVS_at_peterfinnigan.demon.co.uk>...
> Hi,
>
> Have a look at my site where i have a paper detailing many ways to set
> trace on in oracle for the current session, for another session or for
> the whole instance.
>
> The URL is http://www.petefinnigan.com/ramblings/how_to_set_trace.htm
>
> hth
>
> kind regards
>
> Pete
Received on Mon Mar 01 2004 - 23:14:43 CST