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.- Hide quoted text -
>
> - Show quoted text -
What version of Oracle?
Received on Sun Feb 11 2007 - 06:47:55 CST
