Value Chain Planning - EBS (MOSC)

MOSC Banner

running oraclestats in ODP Express Monitor

edited Jun 30, 2009 10:35AM in Value Chain Planning - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center