You can look at v$sysstat, v$sesstat and v$filestat to get a lot of that
information. Also, look in the manuals for using utlbstat.sql and
utlestat.sql.
Kenny Gump
OCP 7.3 DBA
Brian Peasland wrote in message ...
>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 - 05:25:00 CDT
