En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de cookies. Ces derniers assurent le bon fonctionnement de nos services. En savoir plus.
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
set serveroutput on size unlimited
spool awr_8408_8478.txt
declare
dbid number := 644588240; -- a remplacer par ton dbid
instance_id number := 1;
l_premier number := 8408;
l_dernier number := 8478;
end_id number;
begin
for start_id in l_premier..l_dernier loop
end_id := start_id + 1;
for awrreport in ( select output from table(dbms_workload_repository.awr_report_html(dbid,instance_id,start_id,end_id)) )
loop
dbms_output.put_line(awrreport.output);
end loop;
end loop;
end;
/
spool off