Re: SQL Statements

When the database was started:

select startup_time from v$instance;

how many users(active sessions):

select count(status) from v$session where status='ACTIVE";

don't know what you mean by locking problems?

Puneet Khanna wrote:

> I want to know SQL statements for -
>
> 1. Checking how long database instance is up.
> 2. How many active users are in the system.
> 3. Are there any locking problems.
>
> Thanks in advance,
> Puneet
Received on Fri Jul 23 1999 - 14:04:01 CDT