aw.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