Tag: automate

Script to automate generation AWR for a day

-- The following anonymous PL/SQL code can be used to generate a script which can be run to generate AWR report for one day. Currently the script runs to create report for yesterday's report. It creates a report between each snap. set serveroutput on set feedback off spool rpt.sql set termout off set linesize 200 … Continue reading Script to automate generation AWR for a day