About Parameters for ODBC/JDBC Procedures

The following tables provide parameter reference information for each category type.

Parameter Name	Description
TOTAL SESSIONS	The total number of sessions connecting clients to the Oracle BI Server.
QUERIES PER SEC	The number of queries completed each second by the Oracle BI Server.
NEW LOGINS	The total number of new login requests received by the Oracle BI Server.
ACTIVE LOGINS	The total number of active logins within the Oracle BI Server.
NEW REQUESTS	The number of new process requests received by the Oracle BI Server.
DATA CACHE HIT PER SEC	The percentage of data cache hits for each second.
NEW INIT BLOCKS	The total number of new initialization block requests received by the Oracle BI Server.

Parameter Name	Description
QUERIES PER SEC	The number of queries completed each second by the back-end database.
FAILED QUERIES PER SEC	The number of queries that failed each second in the back-end database.
NEW PREPARES	The number of prepares sent to the back-end database.
ROWS PER SEC	The number of rows retrieved each second from the back-end database.
KB PER SEC	The number of kilobytes retrieved each second from the back-end database.

Parameter Name	Description
NEW REQUESTS	The total number of new LDAP authentication requests received.
NEW IMPERSONATED REQUESTS	The total number of new impersonated LDAP authentication requests received.
ACTIVE REQUESTS	The number of LDAP authentication requests active within the Oracle BI Server.

Parameter Name	Description
CAPACITY	The maximum number of connections that the database connection pool allows.
CONNECTION COUNT	The current number of open connections in the thread pool.
BUSY CONNECTION COUNT	The number of connections that have been assigned to process a query, or that are currently processing a query, in the database connection pool.
AVG REQUESTS PER SEC	The average number of requests each second that have been submitted to the database connection pool.
AVG OPEN REQUESTS PER SEC	The average number of connections that are opened each second. Connections might be opened for new connections, because other connections timed out, or because of problems with a connection.

Parameter Name	Description
CAPACITY	The maximum number of threads allowed by the thread pool.
THREAD COUNT	The current number of threads in the thread pool.
BUSY THREAD COUNT	The current number of threads that have been assigned work. The thread might be blocked waiting for a resource or data, or it could be actively running on a CPU.
ACCUMULATED REQUESTS	The total number of requests that have been submitted to the thread pool.
MAX STACK SIZE	The maximum number of stack bytes consumed for all threads in the thread pool.

Parameter Name	Description
CAPACITY	The total capacity of the specified cache object.
TOTAL REQUESTS	The total number of requests each second against the specified cache object.
AVG REQUESTS	The average number of requests each second against the specified cache object.
AVG HITS	The average number of hits each second for the specified cache object.
AVG MISS	The average number of misses each second for the specified cache object.