Re: Get some basic info, but without statpack

From: Sylvestre <Sylvestre_at_world.com>
Date: Wed, 6 Sep 2006 08:09:05 +0200
Message-ID: <44fe6603$0$28132$636a55ce@news.free.fr>

Thank you all, a trigger wich store info in new table in perfstat schema seem to be good. We are in 9.2.0.6 and it's a datawarehouse with very few transaction, only some big select request..

Thank yu

"Sylvestre" <Sylvestre_at_world.com> a écrit dans le message de news:
44f7d21c$0$15659$626a54ce_at_news.free.fr...
> 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
>
Received on Wed Sep 06 2006 - 01:09:05 CDT