Generating ASH Reports

Through SQL

SQL> define dbid        = '';

SQL> define inst_num    = '';

SQL> define report_type = 'html';

SQL> define begin_time  = '09:00';

SQL> define duration    = 480;

SQL> define report_name = '/tmp/sql_ashrpt.txt';

SQL> define slot_width  = '';

SQL> define target_session_id   = '';

SQL> define target_sql_id       = 'abcdefghij123';

SQL> define target_wait_class   = '';

SQL> define target_service_hash = '';

SQL> define target_module_name  = '';

SQL> define target_action_name  = '';

SQL> define target_client_id    = '';

SQL> @?/rdbms/admin/ashrpti