running oraclestats in ODP Express Monitor
I am looking for a way to run oraclestats in ODP Express Monitor. Because of access limitations in production, I cannot run the commands in SQL*Plus.
Here are the commands in note 784691.1 -
set serveroutput on
exec dbms_aw.execute('cda ODPDIR');
exec dbms_aw.execute('aw attach odpcode ro');
exec dbms_aw.execute('aw attach msd.msdxxxx ro');
exec dbms_aw.execute('call oraclestats');
exec dbms_aw.execute('aw detach odpcode');
exec dbms_aw.execute('aw detach msd.msdxxxx');
where xxxx is the demand plan id.
The output file will be generated in the ODPDIR directory alias. The files will have a name with the following format: oraclestats_ddMMMyy_hh_mm_ss.log