-- 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
Tag: report
How to get cursor attributes?
How to generate AWR report?
There are few scripts that can be used to generate AWR HTML or text reports. @?/rdbms/admin/awrrpt.sql - It is an interactive script that can be used to generate HTML or text reports. The script prompts for type of report requested and prompts for number of days of snapshots to choose from so based on that … Continue reading How to generate AWR report?
alexlima.com 