Re: Save query and statistics automatic

On Feb 11, 5:16 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
> On Feb 10, 10:59 pm, bdurrettc..._at_yahoo.com wrote:
>
>
>
> > On Feb 10, 9:26 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
>
> > > Hi All,
> > > Is it possible to store, query with username, who is executing it,
> > > with osuser, with time taken by that query plus number rows processes.
> > > Actually I want to store each query with right literals not bind
> > > variable, which are store in v$sqlarea(including query executes twice
> > > with two different stats), which is executed by user between 8 PM to 9
> > > PM in a table. Is it possible to store it with details.
> > > Please help.
>
> > You could turn on 10046 level 12 tracing on all of the sessions that
> > you need to monitor and then dig through the trace files afterward.
> > That will store the values of your bind variables.
>
> > - Bobby
>
> Thank you for your reply Bobby.
> But I want to store these queries in table with values I mentioned
> above. Is it possible.

I don't understand why the suggestion wouldn't work. You just have to parse the raw trace file for what you want, and then insert the data in which you are interested into your table.

Regards,

Steve Received on Mon Feb 12 2007 - 19:12:22 CST