Oracle® Enterprise Manager Oracle Fusion Middleware Metric Reference Manual, 11g Release 1 (11.1.0.1) Part Number E18807-01 |
|
|
PDF · Mobi · ePub |
This chapter describes Oracle Discoverer metrics.
Oracle Business Intelligence Discoverer is a business intelligence tool for analyzing data. Discoverer provides an integrated business intelligence solution comprising a set of intuitive ad-hoc query, reporting, analysis, and Web-publishing tools. These tools enable nontechnical users to gain immediate access to information from data marts, data warehouses, and online transaction processing systems. Discoverer integrates seamlessly with Oracle Portal, enabling rapid deployment of Discoverer workbooks and worksheets to Web portals.
Provides information about the metrics aggregated at the level of each Discoverer component.
This metric specifies the total CPU usage time (in milliseconds) for all the Discoverer server sessions of the selected component on the host machine.
This metric specifies the CPU usage (in percentage) for the Discoverer server sessions of the selected component on the host machine.
This metric specifies the memory (in megabytes) used by the Discoverer server sessions of the selected component on the host machine.
This metric displays information about the Discoverer server sessions that are currently active.
This metric indicates the name of the Discoverer component for which the metrics are displayed.
This metric specifies the database user, the database, and the EUL to which the session is connected. The format of this metric value is databaseuser@database - EUL.
This metric specifies the total CPU usage time (in milliseconds) for the Discoverer server session on the host machine.
This metric specifies the CPU usage (in percentage) for the Discoverer server session on the host machine.
This metric specifies the amount of memory (in megabytes) used by the Discoverer server session on the host machine.
This metric specifies the amount of total private memory (in megabytes) used by the Discoverer server session on the host machine.
If Single Sign-On (SSO) is enabled for Discoverer, this column identifies the SSO user that is using the current session. Information about the SSO user is meaningful only for Discoverer Plus and Discoverer Viewer because SSO users work in Plus and Viewer sessions interactively. For Discoverer Portlet Provider, information about the SSO user might not be meaningful because 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.
Provides information about metrics at the Discoverer application level, aggregated for all the server sessions.
This metric specifies the total CPU usage time (in milliseconds) for all Discoverer server sessions on the host machine.
This metric specifies the CPU usage (in percentage) for all Discoverer server sessions on the host machine.
This metric specifies the amount of free physical memory (in megabytes) on the host machine.
This metric specifies the memory (in megabytes) used by all the Discoverer server sessions on the host machine.
This metric specifies the total private memory (in megabytes) used by all the Discoverer server sessions on the host machine.
This metric displays the total CPU and memory consumption for all current sessions created by each Discoverer component (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.
This metric specifies the total CPU usage for the sessions created by each Discoverer UI component. The total CPU usage does not include CPU usage for the servlets of these components. For CPU usage of servlets, see the Discoverer application page under the OC4J_BI_Forms home page.
This metric specifies the total memory usage for the sessions spawned by the given UI component. The total memory usage does not include memory usage for the servlets of these components. For memory usage of servlets, see the Discoverer application page under the OC4J_BI_Forms home page.
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, see the Discoverer application page from the OC4J_BI_Forms home page in the EM standalone console.
This metric specifies the percentage of CPU 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, and Portlet Provider. For the CPU usage of these servlets, see 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.
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, see the Discoverer application page from the OC4J_BI_Forms home page in the EM standalone console.
This metric specifies the total memory usage for all Discoverer sessions.
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.
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 information about all the Discoverer sessions created by Discoverer Plus. The information included for each session is the session ID, OS Process ID, memory usage of the session, CPU usage for the session, database and EUL to which the session is connected, and, if SSO is enabled, the SSO user using the 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, OS Process ID, memory usage of the session, CPU usage for the session, database and EUL to which the session is connected, and, if SSO is enabled, the SSO user using the session.
This metric specifies the Discoverer UI component that started the Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider session.
If Single Sign-On (SSO) is enabled for Discoverer, this column identifies the SSO user that is using the current session. Information about the SSO user is meaningful only for Discoverer Plus and Discoverer Viewer because SSO users work in Plus and Viewer sessions interactively. For Discoverer Portlet Provider, information about the SSO user might not be meaningful because 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 that are currently running on the server. It includes the following information: session ID, OS Process ID, Discoverer UI component (that is, Discoverer Plus, Discoverer Viewer, or Discoverer Portlet Provider) that created the session, memory usage of the session, CPU usage for the session, database and EUL to which the session is connected, and, if Single Sign-On (SSO) is enabled, the SSO user using the session.
This metric indicates the Discoverer UI component that started the Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider session.
This metric specifies the database user, the database, and the EUL to which the session is connected. The format is databaseuser@database - EUL.
This metric specifies the memory used (in megabytes) for all the Discoverer sessions.
If Single Sign-On (SSO) is enabled for Discoverer, this column identifies the SSO user that is using the current session. Information about the SSO user is meaningful only for Discoverer Plus and Discoverer Viewer because SSO users work in Plus and Viewer sessions interactively. For Discoverer Portlet Provider, information about the SSO user might not be meaningful because 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 the total number of sessions created by Discoverer Plus at any given time on the machine.
This metric displays the total number of sessions created by Discoverer Portlet Provider at any given time on the machine.
This metric displays the total number of Discoverer sessions running on the machine at a given time.
This metric displays the total number of sessions created by Discoverer Viewer at any given time on the machine.
This metric displays information about all the Discoverer sessions created by Discoverer Viewer. The information included for each session is the session ID, OS Process ID, memory usage of the session, CPU usage for the session, database and EUL to which the session is connected, and, if SSO is enabled, the SSO user using the session.
This metric specifies the Discoverer UI component that started the Discoverer Plus, Discoverer Viewer or Discoverer Portlet Provider session.
If Single Sign-On (SSO) is enabled for Discoverer, this column identifies the SSO user that is using the current session. Information about the SSO user is meaningful only for Discoverer Plus and Discoverer Viewer because SSO users work in Plus and Viewer sessions interactively. For Discoverer Portlet Provider, information about the SSO user might not be meaningful because 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 that indicates whether Discoverer is up or down.
This metric displays information that indicates whether Discoverer is up or down.
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.
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 |