If you wish to do this then I think you will have to roll your own.
I have played with writing a resource profiler using utl_file and trace
files. I suspect that for me it would probably take a good 6 months of work
to get right. (this probably means it is a 3-6 week job for a competent
coder).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Jaffery" <maulana1_at_hotmail.com> wrote in message
news:3ff5ba5f.0403012114.2d142dbd_at_posting.google.com...
> 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 Tue Mar 02 2004 - 02:51:09 CST
