OBIEE 11g - Bi Server metrics functions (JDBC/ODBC)
> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)
Table of Contents
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.
2 - Articles Related
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
Advertising
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
Advertising