c_dbf_trim.sql

	trims the last FREE CHUNK from a datafile
	by resizing it ...  Coalesces tablespace prior resize.

c_dbf_trim_all.sql

	trims the last FREE CHUNK from ALL datafiles
	by resizing it ...  Coalesces ALL tablespace prior resize.

c_find_corr_obj.sql

	Finds corrupted object in the datafile
	USE when get ORA-1578 error
	since it needs block_id and file_id parameters

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_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_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)

s_all_ratios.sql

	THIS Script reports various performance ratios