Re: SQL Statements

From: Vrajesh Patel <vrajesh_p_at_hotmail.com>
Date: Thu, 22 Jul 1999 16:29:17 GMT
Message-ID: <xFHl3.194$pF6.39493@PM01NEWS>

Do you have Oracle Enterprise Manager with you? It will provide you all the details regarding instance, active users and lock status.

Thanks,

Vrajesh Patel

Puneet Khanna <khannapk_at_hotmail.com> wrote in message news:7n7dvq$7gc$1_at_nntp3.uunet.ca...
> 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 Thu Jul 22 1999 - 11:29:17 CDT