Hi guys,
It's Oracle 12c R2 for Linux x86.
I am producing ASH reports and the reports always display "No data exists for this section of the report" in all its sections, no matter what date or time or duration I set for it.
Thanks in advance!
define dbid = '';
define inst_num = '';
define report_type = 'html';
define begin time
define begin_time ='01/29/20 08:00:00'
define duration = 30; -- in minutes
define report_name = '/media/sf_extdisk/ash_report.html';
define slot_width = '';
define target_session_id = '';
define target_sql_id = '';
define target_wait_class = '';
define target_service_hash = '';
define target_module_name = '';
define target_action_name = '';
define target_client_id = '';
define target_plsql_entry = '';
define target_container = '';
@ $ORACLE_HOME/rdbms/admin/ashrpti.sql