Oracle Point, Oracle Life.

This posting is summary of a metalink posting about OEM. That’s only note for my own memory.

1. Note: 229624.1

• Title: How to log and trace the EM 10g management agent
• Directory of Trace file and log: $ORACLE_HOME/agent/sysman/log
• Key Parameter Files: emd.properties and emagentlogging.properties
• The emd.properties file maintains parameters for setting the size and rotation limits of the emagent.log and emagent.trace files.
• The emagentlogging.properties file controls the logging and tracing parameters for the Agent’s Java fetchlets.

Popularity: 3% [?]

I just quickly tested two scripts about oracle database disk I/O tuning and found helpful. Those two scripts can be found at here.

To use those tow scripts well, I’m suggesting you to:

• run them at time of lightload to get the baseline of disk I/O
• run them at peaktime with heavyload to get the threshold of disk I/O
• periodically run them to get time-of-point measures

Note: I’ve test them on Oracle 10g only. And, I noticed that those two scripts may not good to run against oracle 9i because the following statistics are not collected or populated to view v$sysstat.

• physical read total IO requests
• physical write total IO requests
• physical read total multi block requests
• physical write total multi block requests
• physical read total bytes
• physical write total bytes

Also, you may need to log on as user with role sysdba because the sys-owned views need to be queried in running of those scripts.

Popularity: 3% [?]