Oracle System Statistics Viewer
Displays Oracle system statistics from V$SYSSTAT, with optional filtering by statistic name. Useful for performance monitoring, workload analysis, and diagnosing system-level activity.
oraclesqlperformance-tuningv1.0.0
0 stars0 downloads13 views0 comments
By OracleDba • Created
Code
(18 lines)123456789101112131415161718
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/system_stats.sql
-- Author : Tim Hall
-- Description : Displays system statistics.
-- Requirements : Access to the V$ views.
-- Call Syntax : @system_stats (statistic-name or all)
-- Last Modified: 03-NOV-2004
-- -----------------------------------------------------------------------------------
SET VERIFY OFF
COLUMN name FORMAT A50
COLUMN value FORMAT 99999999999999999999
SELECT sn.name, ss.value
FROM v$sysstat ss,
v$statname sn
WHERE ss.statistic# = sn.statistic#
AND sn.name LIKE '%' || DECODE(LOWER('&1'), 'all', '', LOWER('&1')) || '%';