|
Oracle® Enterprise Manager Metric Reference Manual
10g Release 1 (10.1) Part No. B12015-01 |
|
|
|
|
Oracle® Enterprise Manager Metric Reference Manual
10g Release 1 (10.1) Part No. B12015-01 |
|
|
|
|
OracleAS Discoverer is a business intelligence tool for analyzing data and is a key component of Oracle Application Server OracleAS). 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. OracleAS 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.
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.
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.
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 Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider.
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 Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider
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 Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider.
The database user, the database and the EUL that the session is connected to. The format is databaseuser@database - EUL.
The amount of memory used (in megabytes) for all Discoverer sessions.
The amount of shared memory used (in megabytes) for all Discoverer sessions.
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 Discoverer UI component that started the particular session (i.e. Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider
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 Discoverer (i.e. the OAD process).
This metric displays information that identifies whether the Discoverer Services: OAD, OSAgent and Discoverer Preferences, are up or down. Since all the services are started and stopped as a single entity, this metric only reports the status of the OAD.
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-1 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.
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-2 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.
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-3 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%%% |
This metric displays the total number of Discoverer sessions on the machine created by Discoverer Plus at any given time.
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.
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.
