Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Save query and statistics automatic
Steve Robin 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.
>
statspack will give you a lot of information. Are you running it
regularly. Again as others have pointed out why are you doing this?
there might be better answers based on your actual problem.
Received on Sun Feb 11 2007 - 19:05:51 CST
![]() |
![]() |