c_kill.sql

	KILLS user session (prompts for SID and SERIAL#)

c_ses.sql

	Reports all sessions [ PID PROCESS IDLE MACHINE OSUSER ]
     allows tracing optionally calling
		SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION

c_user_alter_quota.sql

	This script will:
		1. REVOKE UNLIMITED TABLESPACE FROM
		   all NON DBA users (DESIGNER and
		   SYS likes are excluded).
		2. Limit their quotas based on the
		   current usage.

c_user_cr8.sql

	Creates database user for a Data Warehouse project
	can be used in batch mode:
		start c_user_cr8.sql 	username /
					password /
					tablespace /
					temp_tablespace /
					quota_in_MB

c_user_dba.sql

	Reports SYSDBA and SYSOPER users
	NOTE: when you grant SYSDBA of SYSOPER to a user
	      ORACLE will update the password file
	      ------------------------------------------
	      ORAPWD - creates password file

c_user_obj_today.sql

	List objects by user created today

c_user_obj_today_drop.sql

	DROPS objects by user prompts for LIKE clause
	use this for cleanups :-)
	spools into a DDL file with DROP stmts ...
	will not run the DDL file

c_user_rbs.sql

	Shows active (in progress) transactions

c_user_rebuild.sql

	Drops [CASCADE] and recreates a USER with original password
	granting ONLY CONNECT and RESOURCE roles

c_user_ses_2.sql

	Displays all sessions DECODE command types
	(based on one of scripts from the oracle newsgroups)

c_user_trace_all.sql

	Enables SQL TRACING for all sessions for a given USERNAME
	TIMED_STATISTICS should be set to TRUE

c_user_trace_me.sql

	Turns SQL_TRACE ON for your session, displays TRACE filename of your session

s_db_sorts.sql

	Reports ALL sorts in the database
	Works with 8i TEMP tablespaces

s_locked_obj.sql

	            *** QUICK ***
	Reports the following:
	-  object locks from V$LOCKED_OBJECT
	   using PL/SQL loops since join of DBA_OBJECTS
	   and V$LOCKED_OBJECT is extremly slow
	- blocked objects from V$LOCK and SYS.OBJ$
	- blocked sessions from V$LOCK

s_ses_dist_trx.sql

	This script reports FAILED DISTRIBUTED TRANSACTIONS
	Refer to Note:1012842.102 on how to remove or purge
	these TRNX.  Uses view DBA_2PC_PENDING
    

s_sga_pga_used.sql

	Reports SID`s PGA usage
	some platforms have a limitation on maximum
	PGA you can have (32bit AIX - 256m)
	If SID`s PGA usage goes above this maximum
	session can get disconnected with the following error:
	  "ORA-3113: end-of-file on communication channel"

s_user_long_ops.sql

	Reports long running processes

s_user_redos.sql

	Reports sessions with highest redo sizes
     takes total redo size as denominator

s_user_ses_cnt.sql

	Displays count of all sessions
	groups by STATUS, MACHINE, MODULE / ACTION
    

s_user_ses_trace.sql

	Reports Various Session Information
	usefull for runaway process tracing.

s_user_sql.sql

	This script reports SQL TEXT from v$sqltext
    

s_waiters.sql

	This script reports sessions that are currently waiting
	output DECODED locking information from v$lock and v$sessions
    

s_waitt.sql

	This script reports details from v$session_wait
	where wait_time = 0
	and seconds_in_wait > &min_in_wait