Re: Session Statistics

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 1 Jul 1999 20:45:57 +0200
Message-ID: <930854703.17993.0.pluto.d4ee154e@news.demon.nl>

Hi Brian,

Have your ever used utlbstat and utlestat. Utlestat will provide you with those statistics and more.
The files are in $ORACLE_HOME/rdbms/admin (Unix) or %ORACLE_HOME%/rdbms<xx>/admin (NT)
and need to be run using svrmgrl/svrmgr<xx>

Hth,

Sybrand Bakker, Oracle DBA

Brian Peasland <peasland_at_email.msn.com> wrote in message news:O$qsAl2w#GA.327_at_cpmsnbbsa05...
> Can anyone tell me how to get statistics such as the number of
transactions
> or number of sessions that the Oracle RDBMS has processed since it was
> started? I need to try and automate some sort of statistics gathering
> process. Is there a v$ table I can query that will give me this
information?
> How about a sequence that I can check the CURVAL for?
>
> Thanks in advance!
> Brian Peasland
> peasland_at_msn.com
>
>
Received on Thu Jul 01 1999 - 13:45:57 CDT