An Oracle BI Instance target is comprised of all Oracle Business Intelligence system components (such as Oracle BI Server, Oracle BI Presentation Services, and Oracle BI Scheduler) in a given Oracle Business Intelligence installation. You can use Fusion Middleware Control to monitor and manage these processes.
This category shows metrics related to the rate at which requests are being processed by the given Oracle BI Presentation Services component.
The number of active Presentation Services sessions.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of bad requests.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of requests completed.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of requests completed each second.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The current number of requests being processed.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of failed requests.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of GET requests completed each second.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of GET requests completed.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of GET/POST requests completed each second.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of GET/POST requests completed.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of long running requests.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The peak number of requests concurrently being processed.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of POST requests completed each second.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of POST requests completed.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
This category shows performance information and metrics related to requests processed across all Oracle BI Presentation Services components in the BI cluster.
The number of active sessions for all Oracle BI Presentation Services components in the BI cluster.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of requests completed each second for all Oracle BI Presentation Services components in the BI cluster.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The current number of requests being processed across all Oracle BI Presentation Services components in the BI cluster.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of failed requests across all Oracle BI Presentation Services components in the BI cluster.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
This category shows performance information and metrics for all Oracle BI Server components in the BI cluster.
The average elapsed time, in seconds, for queries that completed during the sampling interval, for all Oracle BI Servers across the BI cluster. This metric includes both successful and failed queries.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
This category shows performance information about the Oracle BI Server query cache.
The percentage of hits for the Oracle BI data cache during the sampling period.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of times each second that a query was satisfied from the data cache during the sampling period.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of times each second a qualified query was not satisfied from the data cache during the sampling period.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of times each second an unqualified query occurred. An unqualified query is a query that did not qualify to hit the cache.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
This category provides information about the database connection pools used by Oracle Business Intelligence.
The total number of connections that were opened for this connection pool. New connections can be opened as fresh connections, when a connection times out, or when there is a problem with the connection.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of requests that have been submitted to the given database connection pool.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of connections that were closed and reopened with a different logon. It includes connections that were closed at the end of processing the previous request.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average number of requests that had to wait in queue for a connection to become available, since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average number of milliseconds that a request waited in queue before a connection became available, since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average number of connections that were opened since the server was started. New connections can be opened as fresh connections, when a connection times out, or when there is a problem with the connection.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average number of requests per second that have been submitted to the given database connection pool since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average number of connections that were closed and reopened with a different logon since the server was started. It includes connections that were closed at the end of processing the previous request.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The maximum number of connections that the given database connection pool allows.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The current number of connections assigned to process a query in the given database connection pool.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The current number of open connections in the thread pool.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of requests that are currently queued, waiting for a connection to become available.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of milliseconds that the request that is next in line for processing has waited in queue.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The smallest number of requests that have been in queue since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The smallest number of milliseconds that a request has had to wait in queue since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The maximum number of connections assigned to process a query during the lifetime of the given database connection pool.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The maximum of number of open connections during the lifetime of the thread pool.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The peak number of requests that have been in queue since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The peak number of milliseconds that a request has had to wait in queue since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The Producer ID of the oldest queued request in the given database connection pool. The oldest queued request will be the next request to obtain a database connection. The request may have to wait for a thread before obtaining the connection.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The Request ID of the oldest queued request in the given database connection pool. The oldest queued request will be the next request to obtain a database connection. The request may have to wait for a thread before obtaining the connection.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
This category shows performance information and metrics for the given Oracle BI Server.
The number of execute requests active within the Oracle BI Server at the end of the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of fetch requests active within the Oracle BI Server at the end of the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of open file handles that are servicing client requests or physical execution requests at the end of the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of initialization block requests active within the Oracle BI Server at the end of the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of active logins within the Oracle BI Server at the end of the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of query prepare requests active within the Oracle BI Server at the end of the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average elapsed time, in seconds, for failed logins that completed during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average elapsed time, in seconds, for the execution of initialization blocks that completed during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average elapsed time, in seconds, for queries that completed during the sampling interval. This metric includes both successful and failed queries.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The average elapsed time, in seconds, for successful logins that completed during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of file handles currently being written to or being read from.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of objects waiting for a file handle to become available.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of available file handles in the file handle pool.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The maximum time, in seconds, for the execution of a single initialization block for each login request that completed during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The peak number of concurrently running file handles since the server was started.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of new execute requests received by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of new fetch requests received by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of new initialization block requests received by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of new login requests received by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of new query prepare requests received by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The total number of new requests received by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The number of queries completed per second by the Oracle BI Server during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
The percentage of initialization block requests that succeeded during the sampling interval.
The following table shows how often the metric's value is collected.
| Target Version | Collection Frequency |
|---|---|
| All Versions | Every 15 Minutes |
This metric category provides information about internal Oracle BI Server caches, including:
Star_ColumnAggrInfo_Cache
Star_DrillDownInfo_Cache
Star_DrillDownQuery_Cache
Star_LDAP_Cache
Star_Plan_Cache
Star_RowWiseInit_Cache
The average number of hits each second for the specified cache object during the sampling interval.
The average number of misses each second for the specified cache object during the sampling interval.
The average number of entries added each second to the specified cache object during the sampling interval.
The average number of entries deleted each second from the specified cache object during the sampling interval.
The average number of requests each second against the specified cache object during the sampling interval.
This category shows performance information and metrics for LDAP requests. Only legacy custom LDAP server requests are included.
The number of active LDAP authentication requests received by the Oracle BI Server during the sampling interval.
The average elapsed time, in seconds, for failed LDAP authentication requests received by the Oracle BI Server during the sampling interval.
The average elapsed time, in seconds, for successful LDAP authentication requests received by the Oracle BI Server during the sampling interval.
The percentage of LDAP authentication requests that successfully hit the LDAP cache during the sampling period.
The total number of new impersonated LDAP authentication requests received by the Oracle BI Server during the sampling interval.
This category shows performance information and metrics for all physical databases that are being used as data sources for Oracle Business Intelligence.
The number of outstanding executes that remain at the given physical database at the end of the sampling interval.
The number of outstanding fetches that remain at the given physical database at the end of the sampling interval.
The number of outstanding prepares that remain at the given physical database at the end of the sampling interval.
The average time, in seconds, that it takes for the given physical database to respond to a query request during the sampling interval.
The number of queries that failed each second in the given physical database during the sampling interval.
The number of kilobytes retrieved each second from the given physical database during the sampling interval. This metric includes both completed and failed queries.
The number of executes sent to the given physical database during the sampling interval.
The number of fetches sent to the given physical database during the sampling interval.
The number of prepares sent to the given physical database during the sampling interval.
This category provides information about caches within Oracle BI Presentation Services.
This category provides information related to Oracle BI Presentation Catalog access.
This category provides information related to the Oracle BI Presentation Catalog attribute cache. The attribute cache maintains information in memory about recently accessed items in the Oracle BI Presentation Catalog.
This category provides information related to the Oracle BI Presentation Services chart engine and cache. The chart cache maintains recently accessed charts on disk for instantaneous response.
The number of charts submitted for creation each second. This does not include chart requests satisfied by the chart cache.
The current number of entries in the chart cache. This includes finished, queued, and running charts in the cache.
The number of charts that are currently being processed. This does not include charts waiting in queue for processing.
This category provides information related to connections established from Oracle BI Presentation Services to the Oracle BI Server.
The current number of Oracle BI Server connections in the process of being authenticated and established.
The peak number of Oracle BI Server connections being concurrently authenticated and established.
This category provides information related to Oracle BI Presentation Services directory searches.
This category provides information related to the Oracle BI Presentation Data Exchange Engine (DXE).
The total number of queries compiled as Aggregate type.
The total number of queries compiled as Expression type.
The total number of queries compiled as Presort Cube type.
The total number of queries compiled as Presort Table type.
The total number of requests to process Aggregate type queries.
The total number of requests to process Regular type queries.
The total number of requests to process Union type queries.
This category provides information related to file access within Oracle BI Presentation Services.
This category provides information related to Oracle BI Presentation Services HTTP 1.1 socket usage.
The total number of sockets that were reported closed by the TCP layer when an attempt was made to reuse them.
The total number of sockets closed at first read (in other words, after the request was sent). These closed sockets have the potential to cause repeated delivery at the HTTP server.
The total number of sockets closed because the HTTP protocol requested explicit closure.
The total number of sockets that could not be reused because their response was not fully consumed.
The total number of sockets closed because they reached the timeout specified in the Keep-Alive response header from the HTTP server.
This category provides information about the JavaHost proxy requests, used for PDF, charts, and so on.
This category provides information related to metadata retrieved by Oracle BI Presentation Services from the Oracle BI Server.
This category provides information about the Oracle BI Presentation Services cache for Oracle BI Server queries.
The number of queries each second that have been returned as canceled by the Oracle BI Server.
The current number of entries in the Presentation Services query cache.
The number of query preparations currently being executed against the Oracle BI Server.
The number of immediate queries that are currently queued waiting for execution against the Oracle BI Server. Immediate queries bypass the Presentation Services query cache.
The number of queries that are currently queued waiting for execution against the Oracle BI Server.
The number of immediate queries that are currently being executed against the Oracle BI Server. Immediate queries bypass the Presentation Services query cache.
The number of queries that are currently being executed against the Oracle BI Server.
The number of queries each second that have failed to execute against the Oracle BI Server.
The peak number of entries concurrently in the Presentation Services query cache.
The peak number of concurrent query preparations being executed against the Oracle BI Server.
The peak number of immediate queries concurrently queued waiting for execution. Immediate queries bypass the Presentation Services query cache.
The peak number of concurrently running immediate queries against the Oracle BI Server. Immediate queries bypass the Presentation Services query cache.
The peak number of concurrently running queries against the Oracle BI Server.
The number of times each second the query cache has been proactively cleaned up due to limited resources, or because the allowed limits of the cache were exceeded.
The number of queries each second that have 'piggybacked' off of an equivalent running query.
The number of queries each second that have been returned by the Oracle BI Server without error.
The total number of queries that have been returned as canceled by the Oracle BI Server.
The total number of queries that have failed to execute against the Oracle BI Server.
The number of times the query cache has been proactively cleaned up due to limited resources, or because the allowed limits of the cache were exceeded.
The total number of queries that have 'piggybacked' off of an equivalent running query.
This category shows performance information related to requests processed by Oracle BI Presentation Services.
This category provides information about Oracle BI Presentation Services sessions. A session can be a browser or an Intelligent Agent session.
The number of current embryonic sessions. An embryonic session is a session that has not yet logged in, or in other words, a session that is still at the login page.
This category provides information related to Oracle BI Presentation Services sockets.
This category provides information about thread pools within Oracle BI Presentation Services. A thread pool is responsible for executing jobs of a specific type.
The number of jobs currently waiting in queue for processing by this thread pool.
The peak number of concurrent jobs waiting in queue for processing by this thread pool.
This category provides information related to Oracle BI Presentation Services threads.
This category provides performance information related to all searches made using the User Population Manager.
This category provides information related to the Oracle BI Presentation Services XML document caches.
The amount of disk space deleted in kilobytes since the server was started.
This category provides information related to XML validations within Oracle BI Presentation Services.
This category provides performance information about the Oracle BI Server thread pools. Note that the requests measured by these metrics are internal server requests, not user queries.
The total number of requests serviced by the Oracle BI Server thread pools since the server was started.
The average number of milliseconds that it took for a request to be processed.
The average number of requests waiting for a thread to become available.
The average number of milliseconds that a request waited for a thread to become available.
The average number of requests that were processed each second by the Oracle BI Server.
The number of milliseconds that it took for the most recent request to be processed.
The number of requests currently waiting for a thread to become available.
The number of milliseconds that the request that is next in line for processing has waited in queue.
The total number of threads currently in the Oracle BI Server thread pools.
The smallest number of milliseconds that it has taken to process a request since the server was started.
The smallest number of requests that have been in queue since the server was started.
The smallest number of milliseconds that a request has had to wait in queue.
The peak number of milliseconds that it took for a request to be processed.
The peak number of requests that have been in queue since the server was started.
This category shows performance information for each Web application deployed on a given Oracle WebLogic Server. You can display the metrics in this category to compare with other values.
This category shows average performance information for Action Framework requests across the Oracle WebLogic Server cluster.
This category shows total/average performance information for all managed servers across the Oracle WebLogic Server cluster.
The average number of servlet and/or JSP invocations per minute for the BI Analytics Web application across the Oracle WebLogic Server cluster, in the last 5 minutes.
This category shows average performance information for Web services requests across the Oracle WebLogic Server cluster.
This category shows performance information for the given Oracle WebLogic Server. You can display the metrics in this category to compare with other values.
The percentage of the CPU that is being used by the Oracle WebLogic Server. As traffic increases, CPU utilization increases.
The amount of heap space (total program memory) used, in megabytes, by the Oracle WebLogic Server.
The average number of servlet and/or JSP invocations per minute for the Oracle WebLogic Server in the last 5 minutes.