Pro actively Monitoring your E-Business Suite using Oracle Applications Manager.

Pro actively Monitoring your E-Business Suite using Oracle Applications Manager.

As DBA i would not need to emphasize on the importance of pro active monitoring. This is all the more useful if you involved in supporting an existing system. The Oracle Applications Manager (OAM)provides some nice tools which allow the your to monitor your instance pro actively.

The first page when you log on into OAM also know as the Applications dash board give you a general over view of your system, something that you should really visit every morning. i will break up this page into further pats to discuss each of them  separately

The first section above shows the over all system status of your instances including the number of servers there are and  what are the components each of these have on them. It also show the status of each of these components. for example in the above screenshot you can see that there is some problem in your concurrent processing tier.

This section displays the system generated alerts and the alerts that have been initiated by the users. A user initiated alert  happens when the user identified a problem and reports it via the support cart.

This section gives us information on the changes that have happened to the system in the past 24 hours which include new patches applied, profile option changes and context file edition.

Just below this section you can also check the status of your web components. This i will discuss later on.

The monitoring for Oracle Application via the OAM can be classified under

• Database


• Forms Server


• JVM


• Concurrent Managers


• Workflow


• Web Components

Database Monitoring
This is the next section available in the availability section. This again has a nice detailed information about your Current  Database status. The navigation for this is
OAM->Site Map->Monitoring->Availability-> Database

This section of the database status show the general DB information like DB name host name etc.

This section shows the wait events of your database and the memory usage by your SGA etc.

The next section shows the all the information of your tablespaces

The section below shows the status of your rollback segments

Additionally you can also get information on your database sessions and invalid objects in your instance through the following reports

OAM->Site Map->Monitoring->Current Activity-> Database Sessions

OAM->Site Map->Monitoring->Current Activity-> Invalid Objects.

You can get a report based on a date range.

You can also get the SQL activity happing in your database from OAM. The place where you can find this is
OAM->Site Map->Monitoring->Performance->SQL Activity

The information here can be used to perform any database tuning activity on your instance and the information is generated using the afamsact.sql script.

Also available is the init.ora settings for your Oracle Applications database. You can get to this by the following navigation.
OAM->Site Map->Monitoring->System Configuration->Database Init.ora Setting

 

Apart from showing the current settings it also shows the recommended setting for your instance.

Forms Server Monitoring
The Forms section in the availably section show the status of your forms listener. This happens only if your forms listener is being monitored using Generic Service Management (GSM).The navigation for this report is.
OAM->Site Map->Monitoring->Availability->Forms.

Additionally you can also see your forms runtime process and forms sessions using the following navigation paths.
OAM->Site Map->Monitoring->Current Activity->Forms Runtime Processes

OAM->Site Map->Monitoring->Current Activity->Forms Sessions
This report will be available only if you have set your Sing-On Audit Level to FORM in your system profiles.

Java Virtual Machine Monitoring
You can also get a detailed report of the jserv usage from OAM.

Navigation OAM->Site Map->Monotoring->Performance->Jserv

If you want a detailed and a more cosmetic way to monitor your jserv you can try to do this using jconsole from sun.

Concurrent Managers Monitoring
There are various reports in the concurrent managers sections which provide your information on the concurrent processing of your instance.

Internal Concurrent Manager

The internal concurrent manager sections shows the status  of the ICM. You can use the following navigation for this
OAM->Site Map->Monitoring->Availability->Internal Concurrent Manager.

Request Processing Mangers
This section allows you to view and monitor alll the your concurrent managers along with your standard manager. You can also start stop restart and deactivate your concurrent managers from this screen.
OAM->Site Map->Monitoring->Availability->request Processing Manager.

Transaction Managers.
As the name implies here you can view the status of your transaction managers.as with the above to screen you can start restart stop abort and deactivate your transaction managers from here also.
OAM->Site Map->Monitoring->Availability->Transaction Manager.

Concurrent Requests charts.
You can also have various graphical presentations of your concurrent requets through OAM. You can navigate to
OAM->Site Map->Monitoring->Performance->Concurrent Processing Charts.
Here you can get various reports like

Top Running Requests by CPU

Top Running Requests by PGA

Longest Running Requests

Requests Waiting on Locks

Concurrent Request Reports
You can also get a detailed reports regarding your concurrent requests. These reports can be grouped by username, program or  usage statistics. Navigation path is
OAM->Site Map->Monitoring->Usage->Concurrent Processing Reports

Workflows Monitoring
The status of your workflow components can also be monitored using OAM. This screen here shows the status of your workflow components which include notification mailers, agent listeners and service components. You can also drill down each of these components to get a detailed listing.

Navigation Path OAM->Site Map->Monitoring->Availability->Workflow

Web Components Monitoring
The web components part shows the status of the web components as discussed eralier in the applications dash board.

Navigation Path is OAM->Site Map->Monitoring->Availability->Web Components

The web components report shows the status of your

PL/SQL Agent

Servlet Agent

JSP Agent

JTF

Discoverer

Personal homepage

TCF

Pro actively Monitoring your E-Business Suite using Oracle Applications Manager.