| Metric Alias |
Query |
| availability |
SELECT value FROM V$SYSSTAT WHERE name = 'physical reads' |
| PhysicalReads |
SELECT value FROM V$SYSSTAT WHERE name = 'physical reads' |
| PhysicalReads |
SELECT value FROM V$SYSSTAT WHERE name = 'physical reads' |
| LogicalReads |
SELECT value FROM V$SYSSTAT WHERE name = 'session logical reads' |
| LogicalReads |
SELECT value FROM V$SYSSTAT WHERE name = 'session logical reads' |
| PhysicalWrites |
SELECT value FROM V$SYSSTAT WHERE name = 'physical writes' |
| PhysicalWrites |
SELECT value FROM V$SYSSTAT WHERE name = 'physical writes' |
| UserCalls |
SELECT value FROM V$SYSSTAT WHERE name = 'user calls' |
| UserCalls |
SELECT value FROM V$SYSSTAT WHERE name = 'user calls' |
| UserCommits |
SELECT value FROM V$SYSSTAT WHERE name = 'user commits' |
| UserCommits |
SELECT value FROM V$SYSSTAT WHERE name = 'user commits' |
| UserRollbacks |
SELECT value FROM V$SYSSTAT WHERE name = 'user rollbacks' |
| UserRollbacks |
SELECT value FROM V$SYSSTAT WHERE name = 'user rollbacks' |
| LogonsCumulative |
SELECT value FROM V$SYSSTAT WHERE name = 'logons cumulative' |
| LogonsCumulative |
SELECT value FROM V$SYSSTAT WHERE name = 'logons cumulative' |
| LogonsCurrent |
SELECT value FROM V$SYSSTAT WHERE name = 'logons current' |
| BytesSent |
SELECT value FROM V$SYSSTAT WHERE name = 'bytes sent via SQL*Net to client' |
| BytesSent |
SELECT value FROM V$SYSSTAT WHERE name = 'bytes sent via SQL*Net to client' |
| BytesReceived |
SELECT value FROM V$SYSSTAT WHERE name = 'bytes received via SQL*Net from client' |
| BytesReceived |
SELECT value FROM V$SYSSTAT WHERE name = 'bytes received via SQL*Net from client' |
| ClientRoundtrips |
SELECT value FROM V$SYSSTAT WHERE name = 'SQL*Net roundtrips to/from client' |
| ClientRoundtrips |
SELECT value FROM V$SYSSTAT WHERE name = 'SQL*Net roundtrips to/from client' |
| OpenedCursorsCumulative |
SELECT value FROM V$SYSSTAT WHERE name = 'opened cursors cumulative' |
| OpenedCursorsCumulative |
SELECT value FROM V$SYSSTAT WHERE name = 'opened cursors cumulative' |
| OpenedCursorsCurrent |
SELECT value FROM V$SYSSTAT WHERE name = 'opened cursors current' |
| CPUUsage |
SELECT value FROM V$SYSSTAT WHERE name = 'CPU used when call started' |
| CPUUsage |
SELECT value FROM V$SYSSTAT WHERE name = 'CPU used when call started' |
| CPUUsageRecursive |
SELECT value FROM V$SYSSTAT WHERE name = 'recursive cpu usage' |
| CPUUsageRecursive |
SELECT value FROM V$SYSSTAT WHERE name = 'recursive cpu usage' |
| CPUUsageParse |
SELECT value FROM V$SYSSTAT WHERE name = 'parse time cpu' |
| CPUUsageParse |
SELECT value FROM V$SYSSTAT WHERE name = 'parse time cpu' |
| CacheHitRatio |
SELECT (t1.value+t2.value-t3.value) / (t4.value + t5.value) FROM V$SYSSTAT t1, V$SYSSTAT t2, V$SYSSTAT t3, V$SYSSTAT t4, V$SYSSTAT t5 WHERE t1.name = 'consistent gets' AND t2.name = 'db block gets' AND t3.name = 'physical reads' AND t4.name = 'consistent gets' AND t5.name = 'db block gets' |
| UpTime |
SELECT CAST(((sysdate - startup_time) * 3600 * 24 * 1000) AS INTEGER) from V$INSTANCE WHERE UPPER(INSTANCE_NAME) = UPPER('%instance%') |
| BlockChanges |
SELECT value FROM V$SYSSTAT WHERE name = 'db block changes' |
| BlockChanges |
SELECT value FROM V$SYSSTAT WHERE name = 'db block changes' |
| RedoSize |
SELECT value FROM V$SYSSTAT WHERE name = 'redo size' |
| RedoSize |
SELECT value FROM V$SYSSTAT WHERE name = 'redo size' |
| RedoLogSize |
SELECT SUM(bytes) from V$LOG |
| SessionPGAMemory |
SELECT value FROM V$SYSSTAT WHERE name = 'session pga memory' |
| SessionUGAMemory |
SELECT value FROM V$SYSSTAT WHERE name = 'session uga memory' |
| ParseCount |
SELECT value FROM V$SYSSTAT WHERE name = 'parse count (total)' |
| ParseCount |
SELECT value FROM V$SYSSTAT WHERE name = 'parse count (total)' |
| HardParseCount |
SELECT value FROM V$SYSSTAT WHERE name = 'parse count (hard)' |
| HardParseCount |
SELECT value FROM V$SYSSTAT WHERE name = 'parse count (hard)' |
| SortsDisk |
SELECT value FROM V$SYSSTAT WHERE name = 'sorts (disk)' |
| SortsDisk |
SELECT value FROM V$SYSSTAT WHERE name = 'sorts (disk)' |
| SortsMemory |
SELECT value FROM V$SYSSTAT WHERE name = 'sorts (memory)' |
| SortsMemory |
SELECT value FROM V$SYSSTAT WHERE name = 'sorts (memory)' |
| SortsRows |
SELECT value FROM V$SYSSTAT WHERE name = 'sorts (rows)' |
| SortsRows |
SELECT value FROM V$SYSSTAT WHERE name = 'sorts (rows)' |
| TableScansLong |
SELECT value FROM V$SYSSTAT WHERE name = 'table scans (long tables)' |
| TableScansLong |
SELECT value FROM V$SYSSTAT WHERE name = 'table scans (long tables)' |
| TableScansShort |
SELECT value FROM V$SYSSTAT WHERE name = 'table scans (short tables)' |
| TableScansShort |
SELECT value FROM V$SYSSTAT WHERE name = 'table scans (short tables)' |
| ExecuteCount |
SELECT value FROM V$SYSSTAT WHERE name = 'execute count' |
| ExecuteCount |
SELECT value FROM V$SYSSTAT WHERE name = 'execute count' |
| InstanceUsedSpace |
SELECT SUM(bytes) FROM SYS.DBA_DATA_FILES |
| InstanceFreeSpace |
SELECT SUM(bytes) FROM SYS.DBA_FREE_SPACE |
Oracle 9i Queries
Thanks For Help