AppManager for Oracle UNIX/Linux provides numerous Knowledge Scripts designed to give you a comprehensive view of how Oracle RDBMS performs on your UNIX and Linux servers. The Knowledge Scripts in the OracleUNIX category monitor data useful for managing your environment, including the following:
Oracle RDBMS alert log for specific entries related to database operations and error conditions.
Total number of physical read/write operations per second and the total memory usage for Oracle RDBMS background processes.
I/O activity at the block-level.
Hit ratios for the buffer cache, library cache, and the data dictionary.
Number of database calls from all applications and processes accessing a database instance.
Ratio of continued rows fetched to all rows fetched.
Database availability.
Disk space available for the archive log file, the background process log file, and user log files.
Rollback segment contention for a database.
Percentage of rows retrieved using full table scans.
Most-executed SQL queries on a database.
SQL queries consuming the most resources on a database.
Number of redo logs that have not been archived.
Waits on free lists and buffers.
Sort overflow ratio.
Percentage of attempted application transactions that are rolled back.
For aspects of Oracle RDBMS that you choose to monitor, you can set thresholds as the boundaries of optimal performance. You can also instruct AppManager for Oracle UNIX/Linux to raise events when the thresholds are crossed.
You can also use the OracleUNIX Knowledge Scripts to collect performance data for use in reports. You can generate reports that range in purpose from evaluating a narrow window of performance data to illustrating trends to aid in capacity planning.