OBIEE 11g - Bi Server metrics functions (JDBC/ODBC)

1 - About

From 11g, is it now possible to get the DMS metrics from a JDBC/ODBC BI Server function call for the BI Server.

3 - API

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

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

4 - Documentation / Reference

dat/obiee/obis/bi_server_metrics.txt ยท Last modified: 2018/09/15 16:38 by gerardnico