c_ind_rebuild.sql

	This script will rebuild indexes of your choice

c_tab_val.sql

	validate structure cascade for tables

s_db_seg_where.sql

	THIS Script reports table or index extent maping by datafile.

s_db_segs_all.sql

	This script gives general idea of segments and extents
	in a database for all the tablespaces

s_db_segs_blowout.sql

	THIS Script reports segments that will "blowout"
	on the next extent.

s_ind_col.sql

	Reports indexes, indexed columns for a table

s_ind_frag_sta.sql

	Creates and Reports index fragmentation statistics

s_tab_load.sql

	Reports tables that need to be cached
	allows to cache tables with high LOAD value
	----------------------------------------------
	These loads can also indicate that tables
	need to be indexed.
	---------------------------
	USES v$db_object_cache VIEW