Monitoring database status

BMC PATROL for Oracle e-Business Suite allows you to monitor the status of the database, database sessions, and database objects.

This topic contains the following information:

• • To monitor database status
  • To monitor database sessions

To monitor database status

When the Oracle database is up and running, background processes are also created and are running. The following four processes are monitored by PATROL to determine the status of the database instance:

• LogWriter (lgwr)
• DBWriter (dbwr)
• Process Monitor (pmon)
• System Monitor (smon)

If any of these processes are not functioning properly, the OraDbStatus parameter enters an alarm state.

Access the OraDbStatus parameter through the DB_STATUS (OA_DBSTATUS) application. The history of the database status is displayed on a graph along a graphical time line.

To monitor database sessions

The following parameters in the DB_SESSION (OA_DB_SESSION) application display database session information:

Parameter	Type	Description
ListAllDBSession	Report (text)	Displays Oracle SID, Oracle user name, OS user name, OS process ID, audit SID, start time, status, blocked or idle time, and program name for all current database sessions. Information is provided by annotation from the NumAllDBSession parameter from the same application.
NumAllDBSession	Graph	Displays the total number of current database sessions. The value of the NumAllDBSession parameter is the same as the value of the NumAllDBProcess parameter in the APP_PROCESS (OA_PROCESS) application. Annotated data points are available for more information on a specific time point.

The following parameters in the APP_USER (OA_USER) application display database session information:

Parameter	Type	Description
NumInactiveSession	Graph	Displays the total number of currently inactive Oracle Applications user sessions. Inactive sessions are sessions with no CPU usage or user call changes.
NumActiveSession	Graph	Displays the total number of currently active Oracle Applications user sessions. Active sessions are session with CPU usage or user call changes.