8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: segment_stats.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : http://www.oracle-base.com/dba/monitoring/segment_stats.sql -- Author : DR Timothy S Hall -- Description : Displays statistics for segments in th specified schema. -- Requirements : Access to the V$ views. -- Call Syntax : @segment_stats -- Last Modified: 20/10/2006 -- ----------------------------------------------------------------------------------- SELECT statistic#, name FROM v$segstat_name ORDER BY statistic#; ACCEPT l_schema char PROMPT 'Enter Schema: ' ACCEPT l_stat NUMBER PROMPT 'Enter Statistic#: ' SET VERIFY OFF SELECT object_name, object_type, value FROM v$segment_statistics WHERE owner = UPPER('&l_schema') AND statistic# = &l_stat ORDER BY value;