DBAToolZ - Scripts (Statistics) DBAToolZ Home
 (Last updated 09/28/2006)
Home     Download     Forums     SQL Scripts     Book Review     Links     Feedback


Script Name Description

s_ses_top.sql

    This script lists top 10 sessions based
    on the following values from v$sesstat:
            - consistent gets
            - db block gets
            - physical reads
            - db block changes

s_db_sort_ratio.sql

	Reports sort ratios

s_db_sorters.sql

	Reports sessions that with active sorts

s_db_sorts.sql

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

s_dbf_io.sql

	This script will show IO by mount point

s_sga_dict_cache.sql

	Reports DATA_DICTIONARY_CACHE MISSES TO GETS RATIO
	==================================================
	sum(get_miss)
	------------- < 15%
	sum(get_reqs)

s_sga_high_sql.sql

	Reports expensive SQL from V$SQLAREA, V$SQLTEXT view
	Joins to V$SQLTEXT using ADDRESS column
	Prompts	for number of DISK_READS and
	PARSING_USER

s_sga_high_sql2.sql

	(uses PL/SQL block)
	Reports expensive SQL from V$SQLAREA, V$SQLTEXT view
	Joins to V$SQLTEXT using ADDRESS column
	Prompts	for number of DISK_READS and
	PARSING_USER

s_sga_lib_cache.sql

	Reports LIBRARY_CACHE RELOADRATIO and GETHITRATIO.
			1. RELOADRATION	= shoul	be low < 1

				      sum(reloads)
			reloadratio = ------------  should be <	1
				      sum(pins)

			2. GETHITRATIO = should	be high	(>90%)

s_tab_scan_sta.sql

	Reports SYSTEM wide table scan stats

s_user_killed.sql

	This script reports KILLED sessions from v$sessions
	Outputs PID and MACHINE name so you can ID OS PROCESS
	that needs to be cleaned out to clear KILLED status
    

s_waitt.sql

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

DBAToolZ Home | Contact Us
Copyright© 2001 DBAToolZ.com All Rights Reserved.