@@header

UNDEFINE INSTANCE_LIST

UNDEFINE FROM_TIMESTAMP

UNDEFINE TO_TIMESTAMP

PROMPT

PROMPT ***********************************************************************

PROMPT * A S H R E P O R T (HTML)

PROMPT *

PROMPT * I F L E F T B L A N K T H E N G E T L A S T 15 M I N

PROMPT *

PROMPT * Input Parameters

PROMPT * - Instance ID = ( % for ALL or comma separated list of instance numbers)

PROMPT * - From Timestamp = ( YYYY-MM-DD HH24:MI:SS format)

PROMPT * - To Timestamp = ( YYYY-MM-DD HH24:MI:SS format)

PROMPT ***********************************************************************

DEFINE INSTANCE_LIST="&&1"

DEFINE FROM_TIMESTAMP="&&2"

DEFINE TO_TIMESTAMP="&&3"

COLUMN _INSTANCE_LIST NEW_VALUE INSTANCE_LIST NOPRINT

COLUMN _FROM_TIME NEW_VALUE FROM_TIMESTAMP NOPRINT

COLUMN _TO_TIME NEW_VALUE TO_TIMESTAMP NOPRINT

set term off

SELECT DECODE('&&INSTANCE_LIST','','%','&&INSTANCE_LIST') "_INSTANCE_LIST"

, DECODE('&&FROM_TIMESTAMP','',to_char(sysdate - ('15'/(24*60)),'YYYY-MM-DD HH24:MI:SS'),'&&FROM_TIMESTAMP') "_FROM_TIME"

, DECODE('&&TO_TIMESTAMP','',to_char(sysdate ,'YYYY-MM-DD HH24:MI:SS'),'&&TO_TIMESTAMP') "_TO_TIME"

FROM DUAL;

set term on

PROMPT

PROMPT ***********************************************************************

PROMPT * A S H R E P O R T (HTML)

PROMPT *

PROMPT * Input Parameters

PROMPT * - Instance List = '&&INSTANCE_LIST' ( % for ALL or comma separated list of instance numbers)

PROMPT * - From Timestamp = '&&FROM_TIMESTAMP' ( YYYY-MM-DD HH24:MI:SS format)

PROMPT * - To Timestamp = '&&TO_TIMESTAMP' ( YYYY-MM-DD HH24:MI:SS format)

PROMPT ***********************************************************************

set pages 0

spool ash_report.html

SELECT * from table(dbms_workload_repository.ash_global_report_html

( l_dbid => (select dbid from v$database)

, l_inst_num => DECODE(upper('&INSTANCE_LIST'),'%',NULL,'&INSTANCE_LIST')

, l_btime => TO_DATE('&&FROM_TIMESTAMP','YYYY-MM-DD HH24:MI:SS')

, l_etime => TO_DATE('&&TO_TIMESTAMP','YYYY-MM-DD HH24:MI:SS')

, l_sid => NULL

, l_sql_id => NULL

, l_wait_class => NULL

, l_service_hash => NULL

, l_module => NULL

, l_action => NULL

, l_client_id => NULL

)

);

spool off

prompt

PROMPT report generated as ash_report.html file.

set pages 5000

host ash_report.html

@@footer