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

About

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

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.

_

Documentation / Reference


Powered by ComboStrap