13 Oracle BI Analytics Server Metrics

Oracle BI Analytics Server, also known as Oracle BI Server, is a highly scalable, highly efficient query and calculation server designed to optimize concurrency with highly efficient query processing. It provides query parsing, logical request generation, query rewrite and caching optimizations, equivalence processing, code generation, parallel execution and other facilities to optimize query processing and analysis.

You can use the All Metrics page of this target to view the metrics that have been collected for this target by Oracle Management Agent.

DataCache Metrics

This category provides data cache performance metrics for Oracle BI Analytics Server.

Default Collection Interval — Every 5 minutes

Table 13-1 DataCache Metrics

Metric	Description
Data Cache Hit Ratio as %	Shows the percentage of data cache hits during the sampling period.
Data Cache Hits/sec	Shows the number of times a query was satisfied from data cache per second during the sampling period
Data Cache Misses/sec	Shows the number of times an unqualified/qualified query was not satisfied from data cache per second during the sampling period.
Data Cache Qualified Queries Misses/sec	Shows the number of times a qualified query was not satisfied from data cache per second during the sampling period
Data Cache Unqualified Queries Misses/sec	Shows the number of times an unqualified query was not satisfied from data cache per second during the sampling period.

DBConnectionPool Metrics

This category provides DB connection pool performance metrics for Oracle BI Analytics Server.

Default Collection Interval — Every 5 minutes

Table 13-2 DBConnectionPool Metrics

Metric	Description
Current Busy Connection Count	Shows the current number of connections assigned to process a query or processing a query in the DB Connection pool.
Current Connection Count	Shows the current number of open connections in the thread pool.

General Metrics

This category provides general performance metrics for Oracle BI Analytics Server.

Default Collection Interval — Every 5 minutes

Table 13-3 General Metrics

Metric	Description
Active Execute Requests	Shows the number of execute requests active within Oracle BI Server at the end of the sampling interval.
Active Execute Requests Since Last Collection	Shows the number of execute requests active within Oracle BI Server at the end of the sampling interval since Last Collection.
Active Fetch Requests	Shows the number of fetch requests active within Oracle BI Server at the end of the sampling interval.
Active Fetch Requests Since Last Collection	Shows the number of fetch requests active within Oracle BI Server at the end of the sampling interval since Last Collection.
Active Logins	Shows the number of active logins within Oracle BI Server at the end of the sampling interval.
Active Logins Since Last Collection	Shows the number of active logins within Oracle BI Server at the end of the sampling interval since Last Collection.
Active Prepare Requests	Shows the number of query prepare requests active within Oracle BI at the end of the sampling interval.
Active Prepare Requests Since Last Collection	Shows the number of query prepare requests active within Oracle BI at the end of the sampling interval since Last Collection.
Avg. query elapsed time	Shows the elapsed time (in seconds) for the average query that completed, including both successful and fail queries, during the sampling interval.
New Execute Requests	Shows the number of new execute requests received by Oracle BI Server during the sampling interval.
New Execute Requests Since Last Collection	Shows the number of new execute requests received by Oracle BI Server during the sampling interval since Last Collection.
New Fetch Requests	Shows the number of new fetch requests received by Oracle BI Server during the sampling interval.
New Fetch Requests Since Last Collection	Shows the number of new fetch requests received by Oracle BI Server during the sampling interval since Last Collection.
New Prepare Requests	Shows the number of new query prepare requests received by Oracle BI during the sampling interval.
New Prepare Requests Since Last Collection	Shows the number of new query prepare requests received by Oracle BI during the sampling interval since Last Collection.
Queries/sec	Shows the number of queries completed per second by Oracle BI Server during the sampling interval.
Sessions Since Last Collection	Shows the number of sessions connecting clients to Oracle BI Server at the end of the sampling interval since Last Collection.
Total sessions	Shows the number of sessions connecting clients to Oracle BI Server at the end of the sampling interval.

GenericCache Metrics

This category provides generic cache performance metrics for Oracle BI Analytics Server.

Default Collection Interval — Every 5 minutes

Table 13-4 GenericCache Metrics

Metric	Description
Generic Cache Avg. Hits/sec	Shows the average number of hits per second for the specified cache object during the sampling period.
Generic Cache Avg. Misses/sec	Shows the average number of misses per second for the specified cache object during the sampling period.
Generic Cache Requests Since Last Collection	Shows the total number of requests during the sampling period against the specified cache object since Last Collection.
Generic Cache Total Requests	Shows the total number of requests during the sampling period against the specified cache object.
Generic Cache Utilization Ratio (%)	Shows the percentage of specified cache object in use.

PhysicalDB Metrics

This category provides physical DB performance metrics for Oracle BI Analytics Server.

Default Collection Interval — Every 5 minutes

Table 13-5 PhysicalDB Metrics

Metric	Description
Avg. query request response time	Shows the average time (in seconds) a physical query waits for responses to its back-end database requests during the sampling interval.
Failed Queries/sec	Shows the number of queries that failed per second in the back-end physical database during the sampling interval.
Queries/sec	Shows the number of queries completed per second by back-end physical database during the sampling interval.
Rows/sec	Shows the number of rows retrieved per second from back-end physical database (both completed and failed queries) during the sampling interval.

Resources Metrics

This category provides resource usage metrics for Oracle BI Analytics Server.

Default Collection Interval — Every 5 minutes

Table 13-6 Resources Metrics

Metric	Description
CPU (%)	Shows the CPU usage (in percentage) of Oracle BI Analytics Server.
Memory (KB)	Shows the memory usage (in KB) for Oracle BI Analytics Server.

Response Metrics

This category provides status metrics for Oracle BI Analytics Server.

Default Collection Interval — Every minute

Table 13-7 Response Metrics

Metric	Description
Status	shows the current status of Oracle BI Analytics Server. The status can be Agent Unreachable, Under Blackout, Metric Collection Error, Up, Down, Partially Up, Agent Down, or Status Pending.

Failed Dashboards in Last 24 Hours Metrics

This category provides details about the dashboards that failed in the last 24 hours.

Default Collection Interval — Real-time only

Table 13-8 Failed Dashboards in Last 24 Hours Metrics

Metric	Description
End Time	Shows the time when the server finished servicing a logical request for the dashboard.
Error Code	Shows the error code that was displayed for the failed dashboard. The error codes can be 0 (Successfully completed), 1 (Time out), 2 (Row limits exceeded), or 3 (Some other reason).
Error Message	Shows the error message that was displayed for the failed dashboard.
Repository	Shows the name of the repository the dashboard was trying to access before it failed.
Start Time	Shows the time when the server received a logical request for the dashboard.
Subject Area	Shows the name of the subject area.

Top Dashboards in last 7 Days Metrics

This category provides details about the top dashboard requests that were made during a given interval.

Default Collection Interval — Real time only

Table 13-9 Top Dashboards in last 7 Days Metrics

Metric	Description
Total Compile Time	Shows the total time taken for converting all the logical queries to physical queries.
Total Database Time	Shows the total time taken by the database to service all the physical requests made for the dashboard.
Total Failed Requests	Shows the total number of logical requests failed for the dashboard.
Total Requests	Shows the total number of logical requests that were made for the dashboard.
Total Time	Shows the total time taken by all the logical requests made for the dashboard.

Top Users in last 7 Days Metrics

This category provides details about the dashboard requests made by different users during a given interval.

Default Collection Interval — Real time only

Table 13-10 Top Users in Last 7 Days Metrics

Metric	Description
Total Compile Time	Shows the total time taken for converting all the logical queries to physical queries.
Total Database Time	Shows the total time taken by the database to service all the physical requests made by the user.
Total Failed Requests	Shows the total number of logical requests failed for the user.
Total Requests	Shows the total number of logical requests that were made by the user.
Total Time	Shows the total time taken by all the logical requests made by the user.