- select dbid, to_char( begin_time ,'YYYY/MM/DD HH24:MI'),
- from dba_hist_sysmetric_summary
- where metric_name= 'Physical Read Total Bytes Per Sec' /* and DBID=[dbid if share repository] */
- order by begin_time;
The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
By Guest on 15th March 2019 10:25:06 AM | Syntax: TEXT | Views: 4
New paste | Download | Show/Hide line no. | Copy text to clipboard