Re: drop user user_name cascade - question

From: srivenu <srivenu_at_hotmail.com>
Date: 13 Oct 2002 22:15:18 -0700
Message-ID: <1a68177.0210132115.5565b05f@posting.google.com>

Can you run this query periodically after giving the DROP USER statement and send the output.

col name form a35
col value form a20
set head off
set feedback off
select ' '||upper(name)name,value from v$parameter
where name = 'timed_statistics'
/

set feedback on
set head on
col event form a13 trunc head "Event| Waiting For" col p2 form 99999 trunc
col wait_time form 999 trunc head "Last|Wait|Time" col program form a13 trunc
col command form a7 trunc head "Command" col username form a8 trunc
col state form a10
col sid form 999 trunc
col last_call_et form 9999999 trunc head "Last Call|In Secs" select a.sid,username,b.program program,

	 decode(command,0,'None',2,'Insert',3,'Select',
		 6,'Update',7,'Delete',10,'Drop Index',12,'Drop Table',
		 45,'Rollback',47,'PL/SQL',command) command,
	 last_call_et,
	 event,p1,p2,state,wait_time

from v$session_wait a,V$session b
where b.sid=a.sid
order by 1
/

regards
Srivenu Received on Mon Oct 14 2002 - 00:15:18 CDT