AppManager provides the following Knowledge Scripts for monitoring Oracle RDBMS.
NOTE:Each Knowledge Script is configured to run at a specific interval. While you can change that interval to suit your needs, we recommend that you not use intervals of less than five minutes. Running at shorter intervals might negatively impact system performance.
From the Knowledge Script view of the Control Center Console, you can access more information about any Knowledge Script by selecting it and pressing F1.
|
Knowledge Script |
What It Does |
|---|---|
|
Monitors the number of active transactions that are ongoing as a percentage of the maximum number of transactions that can be executed concurrently (set as an initialization parameter). |
|
|
Scans the Oracle RDBMS alert log for entries that match a search string that you specify. |
|
|
Monitors the total memory usage and the total number of physical read/write (I/O) operations per second for Oracle RDBMS background processes. |
|
|
Monitors block-level database activity (visits per transaction and changes per transaction). |
|
|
Monitors the user sessions that are blocking other sessions and processes from accessing the Oracle RDBMS. |
|
|
Monitors the number of buffer busy waits and the number of logical reads, and computes a ratio between the two numbers (expressed as a percentage). |
|
|
Monitors the frequency with which requested data and resources are retrieved from the cache. |
|
|
Monitors the demand placed on a database instance from all sources. |
|
|
Monitors the demand placed on a database instance by each transaction. |
|
|
Monitors Oracle instances in a cluster and notifies you when an instance fails or becomes inactive. |
|
|
Monitors the extent to which applications exercise the read consistency mechanism to ensure database consistency. |
|
|
Monitors rows that span more than one database block. |
|
|
Checks the connectivity to Oracle databases. |
|
|
Monitors the status of the background processes of a database. |
|
|
Monitors the size of the datafile of an Oracle RDBMS. |
|
|
Monitors the Consistent Change Ratio, Continued Row Ratio, Row Source Ratio, and Sort Overflow Ratio. |
|
|
Monitors the amount of disk space available for the archive log file, the background process log file, and user log files of a database. |
|
|
Monitors the number of freelist waits and the total number of data requests, and computes a ratio of the two numbers. |
|
|
Monitors Oracle instances in a cluster, the connectivity to Oracle databases, and the status of the background process of Oracle database. |
|
|
Monitors Oracle listeners running on the host. |
|
|
Monitors the Oracle background processes, buffer busy waits, cache, and freelist waits. |
|
|
Determines which SQL statements are being executed on a given Oracle Database most frequently. |
|
|
Monitors the percentage of cursors opened per session, as well as the total number of cursors open in the system. |
|
|
Monitors the open cursors, CPU time for current user sessions, physical reads and writes (I/O) for current user sessions, the current number of user-held locks on an Oracle Database, and memory usage (User Global Area and Program Global Area) for current user sessions. |
|
|
Monitors the number of times that a process tries to write an entry in the redo log buffer, the number of redo logs not archived, if archiving is turned on for a given Oracle Database, and the redo log space wait ratio. |
|
|
Monitors the number of times that a process tries to write an entry in the redo log buffer. |
|
|
Monitors the number of redo logs which are not being archived, if archiving is turned on for a given Oracle Database. |
|
|
Monitors the redo log space wait ratio. |
|
|
Monitors rollback segment contention for a database. |
|
|
Monitors the row source ratio. |
|
|
Runs a SQL statement. |
|
|
Monitors the scheduled job status in the New Oracle Scheduler. |
|
|
Monitors the percentage of extents (extensions of free space) available to each segment in a tablespace. |
|
|
Sets the various monitoring options available for OracleUNIX jobs, especially in clustered environments. |
|
|
Monitors the sort overflow ratio. |
|
|
Monitors statistics from V_$SYSSTAT table of an Oracle Database. |
|
|
Monitors the disk space used by tablespaces. |
|
|
Monitors the CPU time for current user sessions |
|
|
Monitors physical reads and writes (I/O) for current user sessions. |
|
|
Monitors the current number of user-held locks on an Oracle RDBMS. |
|
|
Monitors memory usage (User Global Area and Program Global Area) for current user sessions. |
|
|
Determines which SQL queries for Oracle Database are consuming the most resources per execution on their UNIX hosts. |
|
|
Monitors the number of active transactions, the demand placed on a database instance from all sources, the demand placed on a database instance by each transaction, and the transaction rate for an Oracle Database. |
|
|
Monitors the transaction rate for an Oracle RDBMS. |
|
|
Updates the list of Oracle databases/instances on each UNIX host used to update authentication information in the AppManager Service Manager and for discovery of new databases. |
|
|
Monitors the number of user calls per parse, the user rollback ratio for an Oracle RDBMS, the total number of user sessions accessing an Oracle RDBMS, and the user sessions that are blocking other sessions and processes from accessing the Oracle Database. |
|
|
Monitors the number of user calls per parse. |
|
|
Monitors the user rollback ratio for an Oracle RDBMS. |
|
|
Monitors the total number of user sessions accessing an Oracle RDBMS. |
To run Knowledge Script using SYSDBA authentication, ensure that the user account used to run the UNIX agent is a member of the Oracle Database Administrator (OSDBA) group.
To run all of the Knowledge Scripts in the OracleUNIX category, your account must grant you SELECT permissions for all of the following tables:
DBA_DATA_FILES
DBA_FREE_SPACE
DBA_JOBS
DBA_SCHEDULER_JOBS
DBA_SEGMENTS
DBA_TABLESPACES
DBA_TEMP_FILES
DBA_USERS
GV_$INSTANCE (for Oracle RAC monitoring only)
V_$ARCHIVE_DEST
V_$ASM_ALIAS
V_$ASM_DISK
V_$ASM_DISKGROUP
V_$ASM_FILE
V_$BGPROCESS
V_$DATABASE
V_$DATAFILE
V_$DIAG_INFO (for Oracle 11g and later)
V_$INSTANCE
V_$LIBRARYCACHE
V_$LOCK
V_$LOG
V_$OSSTAT
V_$PARAMETER
V_$PROCESS
V_$ROWCACHE
V_$SESSION
V_$SESSTAT
V_$SGASTAT
V_$SORT_SEGMENT
V_$SQLAREA
V_$STATNAME
V_$SYSSTAT
V_$VERSION
V_$WAITSTAT