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.
Received on Sun Feb 11 2007 - 04:16:45 CST
