Re: SQL Statements

>
>1. Checking how long database instance is up.
>2. How many active users are in the system.
>3. Are there any locking problems.

I can only answer the first two off the top of my head.

1. Query the v$instance view. In Oracle 7, there are two rows that will tell you how long the instance has been running. In Oracle 8, there is a column in that view called 'startup_time'.
2. Query the v$sysstat. Statistic number 6 ( I think it's 6) tells you the cumulative logons (since the instance was started). There is also a 'current logons' value. That's the one you want.

Hope that helps,
Brian Peasland
peasland_at_msn.com Received on Thu Jul 22 1999 - 21:48:58 CDT