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.
Received on Sat Feb 10 2007 - 11:59:31 CST
