Running OTM Scripts From Oracle SR's

Running OTM Scripts From Oracle SR's

If you want to run scripts provided by Oracle like otm_analyzer.sql, place this script first in $OTM_HOME/glog/oracle/script8.

From SQL Plus login to GLOGOWNER Schema.
At sqlplus prompt run @otm_analyzer.sql

Above script will create output in the same folder.

Note:
The OTM Analyzer is used for Analysis and Performance Monitoring is a self-service health-check script that reviews Product related data, analyzes current configurations and settings for the environment, provides solutions for known issues, feedback and recommendations on best practices.

Analyzers are designed by Support to proactively assist you to better diagnose and maintain your Oracle Application environments. Analyzers may also be used as data collection tools by Support Engineers.