Re: SQL Statements

From: BRENT DOUGLAS <BRENT.DOUGLAS_at_DAYTONOH.NCR.COM>
Date: Fri, 23 Jul 1999 08:44:32 -0400
Message-ID: <37985652@rpc1284.daytonoh.ncr.com>

Hi Puneet,

check this page for sample queries, it will get you started....

http://www.menlosoftware.com/

brent

• HERE is a sample for current processes

column pid heading "PID" format 9999999 column spid heading "SPID" format 999999 column username heading "UserName" format a10 column "Oracle User" heading "OracleUser" format a15 column Terminal heading "Terminal" format a15 column latchwait heading "LatchWt" format 9999999

column lockwait heading "LockWt" format 9999999
column command heading "Command" format a15
column program heading "Program" format a15

select p.pid,

p.spid,
p.username,
s.username "Oracle User",

decode(s.terminal, NULL, p.terminal, s.terminal) Terminal, decode(s.program, NULL, p.program, s.program) Program, p.latchwait,
s.lockwait
from audit_actions a, v$process p, v$session s where s.paddr = p.addr
and a.action(+) = s.command
order by terminal,pid;

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.
Received on Fri Jul 23 1999 - 07:44:32 CDT