50 lines
1.7 KiB
SQL
50 lines
1.7 KiB
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
COL w_metric_value HEAD METRIC_VALUE FOR 9,999,999,999,999.99
|
|
|
|
prompt What's going on right now?!
|
|
prompt Showing System metrics from V$SYSMETRIC...
|
|
|
|
SELECT
|
|
metric_name
|
|
, ROUND(value,2) w_metric_value
|
|
, metric_unit
|
|
FROM
|
|
v$sysmetric
|
|
WHERE
|
|
metric_name IN (
|
|
'Average Active Sessions'
|
|
, 'Average Synchronous Single-Block Read Latency'
|
|
, 'CPU Usage Per Sec'
|
|
, 'Background CPU Usage Per Sec'
|
|
, 'DB Block Changes Per Txn'
|
|
, 'Executions Per Sec'
|
|
, 'Host CPU Usage Per Sec'
|
|
, 'I/O Megabytes per Second'
|
|
, 'I/O Requests per Second'
|
|
, 'Logical Reads Per Txn'
|
|
, 'Logons Per Sec'
|
|
, 'Network Traffic Volume Per Sec'
|
|
, 'Physical Reads Per Sec'
|
|
, 'Physical Reads Per Txn'
|
|
, 'Physical Writes Per Sec'
|
|
, 'Redo Generated Per Sec'
|
|
, 'Redo Generated Per Txn'
|
|
, 'Response Time Per Txn'
|
|
, 'SQL Service Response Time'
|
|
, 'Total Parse Count Per Txn'
|
|
, 'User Calls Per Sec'
|
|
, 'User Transaction Per Sec'
|
|
)
|
|
AND group_id = 2 -- get last 60 sec metrics
|
|
ORDER BY
|
|
metric_name
|
|
/
|
|
|
|
PROMPT
|
|
|
|
@ash/w &1
|
|
|
|
|