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. |