Skip Headers
Oracle® Enterprise Manager Oracle Application Server Metric Reference Manual
10g Release 2 (10.2)

Part Number B25987-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

6 Discoverer

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.

6.1 Discoverer Components

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


6.2 Discoverer Plus Sessions

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


6.3 Discoverer Portlet Provider Sessions

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.


6.4 Discoverer Sessions

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.


6.5 Discoverer Viewer Sessions

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.


6.6 Response

This metric is derived directly from the OPMN tree. It reports the Up/Down Status of the Discoverer Preferences Server.

6.6.1 UpDown Status

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


6.7 Total Discoverer CPU Usage

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.

6.7.1 Total Discoverer CPU Usage (%)

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%%%


6.8 Total Discoverer Memory Usage

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.

6.8.1 Total Discoverer Memory Usage (MB)

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


6.9 Total Number Of Discoverer Plus Sessions

This metric displays the total number of Discoverer sessions on the machine created by Discoverer Plus at any given time.

6.9.1 Total Number Of Discoverer Plus Sessions

The total number of Discoverer sessions on the machine created by Discoverer Plus 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

6.10 Total Number Of Discoverer Portlet Provider Sessions

This metric displays the total number of Discoverer sessions on the machine created by Discoverer Portlet Provider at any given time.

6.10.1 Total Number Of Discoverer Portlet Provider Sessions

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

6.11 Total Number Of Discoverer Sessions

This metric displays the total number of Discoverer sessions running on the machine at a given time.

6.11.1 Total Number Of Discoverer Sessions

The total number of Discoverer sessions running on the machine at a 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

6.12 Total Number Of Discoverer Viewer Sessions

This metric displays the total number of Discoverer sessions on the machine created by Discoverer Viewer at any given time.

6.12.1 Total Number Of Discoverer Viewer Sessions

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