About
From 11g, is it now possible to get the DMS metrics from a JDBC/ODBC BI Server function call for the BI Server.
Articles Related
API
OBISAvailableDiagnostics
The API entry is the following function which list all Bi Server metrics.
call OBISAvailableDiagnostics()
Example of output with the flight demo:
Category
varchar
General
DBInstance:06 - TimesTen Agg Tables
DBInstance:DEMO - USAGE_TRACKING
DBInstance:DIREP01 - UT
DBInstance:EXAREPO - SA
DBInstance:X0 - Airlines Demo Dbs (ORCL)
DBInstance:X1 - ORCL Database Admin
DBInstance:_TotalPhysicalDB
LDAPInstance:_TotalLDAPAuthentication
DBConnectionPool:Exalytics_DEMO_instance_X0 - Airlines Demo Dbs (ORCL)_Aggr Connection
DBConnectionPool:Exalytics_DEMO_instance_X1 - ORCL Database Admin_SYSTEM DB Connection Pool
DBConnectionPool:Exalytics_DEMO_instance_DEMO - USAGE_TRACKING_SampleApp Init Blocks
DBConnectionPool:Exalytics_DEMO_instance_DEMO - USAGE_TRACKING_BSC
DBConnectionPool:Exalytics_DEMO_instance_06 - TimesTen Agg Tables_Aggs TT Connection
DBConnectionPool:Exalytics_DEMO_instance_EXAREPO - SA_CP_SUMMARY_ADVISOR
DBConnectionPool:Exalytics_DEMO_instance_Rvs_Rvs Agg
DBConnectionPool:Exalytics_DEMO_instance_Rvs_Rvs
DBConnectionPool:Exalytics_DEMO_instance_DEMO - USAGE_TRACKING_UT Connection Pool
DBConnectionPool:Exalytics_DEMO_instance_X0 - Airlines Demo Dbs (ORCL)_Atomic Connection
DBConnectionPool:Exalytics_DEMO_instance_DIREP01 - UT_CP_USAGE_TRACKING
ThreadPool:Exalytics_DEMO_instance_06 - TimesTen Agg Tables_Aggs TT Connection
Cache:Exalytics_DEMO_instance_Plan_Cache
Cache:Exalytics_DEMO_instance_LDAP_Cache
OBISDiagnostics
You get then more information for one metrics by calling the following function:
call OBISDiagnostics('ThreadPool:Exalytics_DEMO_instance_06 - TimesTen Agg Tables_Aggs TT Connection')
Parameter Name | Value |
---|---|
varchar | varchar |
CAPACITY | 10 |
THREAD COUNT | 10 |
BUSY THREAD COUNT | 0 |
ACCUMULATED REQUESTS | 337 |
MAX STACK SIZE | 72160 |
with the Issue SQL facility General corresponds to the Oracle_BI_General DMS metrics tables.