spool hist_sess.html set markup html on alter session set nls_timestamp_format=’YYYY-MM-DD HH24:MI’; select * from DBA_HIST_ACTIVE_SESS_HISTORY where sample_time between ‘2020-03-09 18:00’ and ‘2020-03-12 17:01’; set markup html off spool off
Josselin Joly
AWR génération d'un rapport automatique pour chaque snap
spool hist_sess.html
set markup html on
alter session set nls_timestamp_format=’YYYY-MM-DD HH24:MI’;
select * from DBA_HIST_ACTIVE_SESS_HISTORY where sample_time between ‘2020-03-09 18:00’ and ‘2020-03-12 17:01’;
set markup html off
spool off
Josselin Joly