plan to make a script with time range as input values
1 | 19:22:41 (1)system@xxxxx> select * from table (dbms_workload_repository.ash_global_report_html( 4281370344,1,timestamp'2016-05-05 13:50:00',timestamp'2016-05-05 14:05:00') ); |
open in browser:
add for mac os x
1 | host open %SQLPATH%\tmp\output_&_connect_identifier..html |
add for linux:
1 | host firefox %SQLPATH%\tmp\output_&_connect_identifier..html --linux |