Re: Get some basic info, but without statpack

On Fri, 1 Sep 2006 08:24:12 +0200, "Sylvestre" <Sylvestre_at_world.com> wrote:

>Hello
>
>I want to audit session on 9i database, the info I
>need :
>- duration of session
>- cpu cons
>- Physical I/O
>- SQL of the request
>
>Is there a way to get simply these info, I don't
>want to use statpack reports.
>
>Thank you
>

without storing the actual sql statements: enable audit_trail for your database and use AUDIT SESSION
Statspack doesn't track sql on session level. You need something like statspack to store sql on session level. However: this would burden your database heavily (as it needs to read the shared pool) and it will provide so much data, that it won't contain *information*

--
Sybrand Bakker, Senior Oracle DBA