Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Get some basic info, but without statpack

Re: Get some basic info, but without statpack

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 01 Sep 2006 10:42:11 -0700
Message-ID: <1157132529.302361@bubbleator.drizzle.com>


Sylvestre 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

Oracle verion number (to four decimal places)?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Sep 01 2006 - 12:42:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US