| Oracle® Enterprise Manager Oracle Application Server Metric Reference Manual 10g Release 2 (10.2) Part Number B25987-01 |
|
|
View PDF |
| Oracle® Enterprise Manager Oracle Application Server Metric Reference Manual 10g Release 2 (10.2) Part Number B25987-01 |
|
|
View PDF |
Oracle Business Intelligence Discoverer is a business intelligence tool for analyzing data and is a key component of Oracle Application Server. Discoverer provides an integrated business intelligence solution comprising a set of intuitive ad-hoc query, reporting, analysis, and Web-publishing tools. These tools enable non-technical users to gain immediate access to information from data marts, data warehouses, and online transaction processing systems. Oracle Business Intelligence Discoverer integrates seamlessly with OracleAS Portal, enabling rapid deployment of Discoverer workbooks and worksheets to Web portals.
This metric displays the total CPU and memory consumption for all current sessions created by each Discoverer component (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider).
Note that the total CPU and memory consumption displayed here is only for the sessions and does not include the CPU and memory consumption of the servlets for these components. This metric also displays the total number of sessions created by the component.
|
Note: For all target versions, the collection frequency for each metric is every 5 minutes. |
The following table lists the metrics and their descriptions.
Table 6-1 Discoverer Components Metrics
| Metric | Description |
|---|---|
|
CPU Usage (%) |
The total CPU usage for the sessions created by the each Discoverer UI component. The total CPU usage does not include the CPU usage for the servlets of these components. For CPU usage of servlets check the Discoverer application page under the OC4J_BI_Forms home page |
|
Memory Usage (MB) |
The total memory usage for the sessions spawned by the given UI component. The total memory usage does not include the memory usage for the servlets of these components. For memory usage of servlets check the Discoverer application page under the OC4J_BI_Forms home page. |
|
Number of Sessions |
The total number of Discoverer sessions created by the given component |
This metric displays information about all the Discoverer sessions created by Discoverer Plus. The information included for each session is the session ID, the OS Process ID, the memory usage of the session, the CPU usage for the session, the database and EUL to which the session is connected and if SSO is turned on, the SSO user using the session.
The following table lists the metrics and their descriptions.
Table 6-2 Discoverer Plus Sessions Metrics
| Metric | Description |
|---|---|
|
Component Type |
The Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider). |
|
CPU Usage (%) |
Percentage CPU usage for this session |
|
DBUser@DB - EUL |
Database user, database name and EUL for this session |
|
Memory Usage (MB) |
Amount of memory used in megabytes for this session |
|
OS Process ID |
Operating system process ID for this session |
|
SSO USer |
Name of the single sign-on user for this session |
This metric displays information about all the Discoverer sessions created by Discoverer Portlet Provider. The information included for each session is the session ID, the OS Process ID, the memory usage of the session, the CPU usage for the session, the database and EUL to which the session is connected and if SSO is turned on, the SSO user using the session.
The following table lists the metrics and their descriptions.
Table 6-3 Discoverer Portlet Provider Sessions Metrics
| Metric | Description |
|---|---|
|
Component Type |
The Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider). |
|
CPU Usage (%) |
Percentage CPU usage for this session |
|
DBUser@DB - EUL |
Database user, database name and EUL for this session |
|
Memory Usage (MB) |
Amount of memory used in megabytes for this session |
|
OS Process ID |
Operating system process ID for this session |
|
SSO USer |
If SSO (i.e. single sign-on) is enabled for Discoverer, this column identifies the SSO user that is using the current session. The SSO user is generally only meaningful for Discoverer Plus and Discoverer Viewer components, where SSO users are using the sessions interactively. For the Discoverer Portlet Provider, the SSO user may not be meaningful, since Discoverer Portlet Provider runs queries in the background, and a query could run as a given SSO user even when that SSO user is not currently logged in. |
This metric displays information about all the Discoverer Server sessions currently running on server machine. It includes the following information: the session ID, the OS Process ID, the Discoverer UI Component (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider) that created the session, the memory usage of the session, the CPU usage for the session, the database and EUL to which the session is connected and if single sign-on (SSO) is turned on, the SSO user using the session.
The following table lists the metrics and their descriptions.I
Table 6-4 Discoverer Sessions Metrics
| Metric | Description |
|---|---|
|
Component Type |
The Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider) |
|
CPU Usage (%) |
Percentage of CPU used for all Discoverer sessions |
|
DBUser@DB - EUL |
Database user, the database and the EUL that the session is connected to. The format is databaseuser@database - EUL |
|
Memory Usage (MB) |
Amount of memory used (in megabytes) for all Discoverer sessions |
|
OS Process ID |
Operating system process ID for the given session |
|
Private Memory Usage (MB) |
Private memory usage in megabytes |
|
Shared Memory Usage (MB) |
Shared memory usage in megabytes |
|
SSO User |
If SSO (i.e. single sign-on) is enabled for Discoverer, this column identifies the SSO user that is using the current SSO user. The SSO user is generally only meaningful for Discoverer Plus and Discoverer Viewer components, where SSO users are using the sessions interactively. For the Discoverer Portlet Provider, the SSO user may not be meaningful, since Discoverer Portlet Provider runs queries in the background, and a query could run as a given SSO user even when that SSO user is not currently logged in. |
This metric displays information about all the Discoverer sessions created by Discoverer Viewer. The information included for each session is the session ID, the OS Process ID, the memory usage of the session, the CPU usage for the session, the database and EUL to which the session is connected and if SSO is turned on, the SSO user using the session.
The following table lists the metrics and their descriptions.
Table 6-5 Discoverer Viewer Sessions Metrics
| Metric | Description |
|---|---|
|
Component Type |
The Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider) |
|
CPU Usage (%) |
Percentage of CPU usage for this session |
|
DBUser@DB - EUL |
Database user, the database name and EUL for this session |
|
Memory Usage (MB) |
Amount of memory used in megabytes for this sessions |
|
OS Process ID |
Operating system process ID for this session |
|
SSO User |
If SSO (i.e. single sign-on) is enabled for Discoverer, this column identifies the SSO user that is using the current session. The SSO user is generally only meaningful for Discoverer Plus and Discoverer Viewer components, where SSO users are using the sessions interactively. For the Discoverer Portlet Provider, the SSO user may not be meaningful, since Discoverer Portlet Provider runs queries in the background, and a query could run as a given SSO user even when that SSO user is not currently logged in. |
This metric is derived directly from the OPMN tree. It reports the Up/Down Status of the Discoverer Preferences Server.
This metric displays information that identifies whether the Discoverer Preference, is up or down
Metric Summary
The following table shows how often the metric's value is collected and compared against the default thresholds. The 'Consecutive Number of Occurrences Preceding Notification' column indicates the consecutive number of times the comparison against thresholds should hold TRUE before an alert is generated.
Table 6-6 Metric Summary Table
| Target Version | Evaluation and Collection Frequency | Upload Frequency | Operator | Default Warning Threshold | Default Critical Threshold | Consecutive Number of Occurrences Preceding Notification | Alert Text |
|---|---|---|---|---|---|---|---|
|
All Versions |
Every 5 Minutes |
After Every 12 Samples |
= |
Not Defined |
0 |
1 |
The Discoverer instance is down |
This metric displays the total CPU percentage used by all Discoverer sessions running on the machine at a given time. The total CPU usage does not include the CPU usage of the servlets for Discoverer Plus, Viewer or Portlet Provider. For the CPU usage of these servlets, please navigate to the Discoverer application page from the OC4J_BI_Forms home page in the EM standalone console.
The total CPU percentage used by all Discoverer sessions running on the machine at a given time. The total CPU usage does not include the CPU usage of the servlets for Discoverer Plus, Viewer or Portlet Provider. For the CPU usage of these servlets, please navigate to the Discoverer application page from the OC4J_BI_Forms home page in the EM standalone console.
Metric Summary
The following table shows how often the metric's value is collected and compared against the default thresholds. The 'Consecutive Number of Occurrences Preceding Notification' column indicates the consecutive number of times the comparison against thresholds should hold TRUE before an alert is generated.
Table 6-7 Metric Summary Table
| Target Version | Evaluation and Collection Frequency | Upload Frequency | Operator | Default Warning Threshold | Default Critical Threshold | Consecutive Number of Occurrences Preceding Notification | Alert Text |
|---|---|---|---|---|---|---|---|
|
All Versions |
Every 5 Minutes |
After Every 12 Samples |
> |
Not Defined |
Not Defined |
2 |
CPU Usage is %value%%% |
This metric displays the total memory used by all Discoverer sessions running on the machine at a given time. The total memory usage does not include the memory usage of the servlets for Discoverer Plus, Viewer or Portlet Provider. For the memory usage of these servlets, please navigate to the Discoverer application page from the OC4J_BI_Forms home page in the EM standalone console.
The total memory usage for all Discoverer sessions as explained in the description of the metric.
Metric Summary
The following table shows how often the metric's value is collected and compared against the default thresholds. The 'Consecutive Number of Occurrences Preceding Notification' column indicates the consecutive number of times the comparison against thresholds should hold TRUE before an alert is generated.
Table 6-8 Metric Summary Table
| Target Version | Evaluation and Collection Frequency | Upload Frequency | Operator | Default Warning Threshold | Default Critical Threshold | Consecutive Number of Occurrences Preceding Notification | Alert Text |
|---|---|---|---|---|---|---|---|
|
All Versions |
Every 5 Minutes |
After Every 12 Samples |
> |
Not Defined |
Not Defined |
2 |
Memory Usage is %value% MB |
This metric displays the total number of Discoverer sessions on the machine created by Discoverer Plus at any given time.
This metric displays the total number of Discoverer sessions on the machine created by Discoverer Portlet Provider at any given time.
The total number of Discoverer sessions on the machine created by Discoverer Portlet Provider at any given time.
Metric Summary
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 5 Minutes |
This metric displays the total number of Discoverer sessions running on the machine at a given time.
This metric displays the total number of Discoverer sessions on the machine created by Discoverer Viewer at any given time.
The total number of Discoverer Sessions on the machine created by Discoverer Viewer at any given time.
Metric Summary
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 5 Minutes |
