Table of Contents

About

You can use WLST DMS Custom commands to periodically save DMS metric information to a file so that you have a record of past metric values.

The implementation of the DMS commands are in the python file: Middleware\oracle_common\common\ojbst\lib\OracleDMS.py

Prerequisites

The wlst script must be started from this directory:

Middleware_Home\oracle_common\common\bin>wlst.cmd
connect('weblogic','password','host:7001')

Command

displayMetricTableNames

metricTableNames = displayMetricTableNames()
obiMetricTableNames = [i for i in metricTableNames if 'Oracle_BI' in i]
for i in obiMetricTableNames: print i
Oracle_BI_Applications
Oracle_BI_DB_Connection_Pool
Oracle_BI_Data_Cache
Oracle_BI_Disconnected
Oracle_BI_General
Oracle_BI_Generic_Cache
Oracle_BI_Instance_Status
Oracle_BI_LDAP_Authentication
Oracle_BI_PS_Caches
Oracle_BI_PS_Catalog_Access
Oracle_BI_PS_Catalog_Attribute_Cache
Oracle_BI_PS_Chart_Engine
Oracle_BI_PS_Connection_Pool
Oracle_BI_PS_DXE
Oracle_BI_PS_DirectorySearches
Oracle_BI_PS_File_Accesses
Oracle_BI_PS_HTTP_Socket_Pool
Oracle_BI_PS_Internal_Object_Reference_Counts
Oracle_BI_PS_Internal_User_Population_API
Oracle_BI_PS_JavaHost_Proxy_Requests
Oracle_BI_PS_Metadata
Oracle_BI_PS_ODBC_Fetch_Information
Oracle_BI_PS_Prompt_Value_Result_Cache
Oracle_BI_PS_Query_Cache
Oracle_BI_PS_Request_Processor
Oracle_BI_PS_Sessions
Oracle_BI_PS_Sockets
Oracle_BI_PS_Thread_Pools
Oracle_BI_PS_Threads
Oracle_BI_PS_User_Population_Searches
Oracle_BI_PS_XML_Document_Caches
Oracle_BI_PS_XML_Validator
Oracle_BI_PS_XslFo_Post_Processor
Oracle_BI_Physical_DB
Oracle_BI_Thread_Pool

listoftables.zip

displayMetricTables

wls:/bifoundation_domain/serverConfig> displayMetricTables('Oracle_BI_Physical_D*')

You get a list of metrics block separated by a white line. The key by block is the attribute “Name”.

---------------------
Oracle_BI_Physical_DB
---------------------

Active_Executes.value:  0
Active_Fetches.value:   0
Active_Prepares.value:  0
Avg._query_request_response_time.value: 0
Failed_Queries_per_sec.value:   0
Host:   Exalytics-01
KiloBytes_per_sec.value:        0
Name:   MyConnectionName
New_Executes.value:     0
New_Fetches.value:      0
New_Prepares.value:     0
OBPERF_***.value:       0
Oracle_BI_Applications: Oracle BI Server
Parent: /Oracle BI Server
Process:        Oracle BI Server:11842:/instance1/coreapplication_obis1
Queries_per_sec.value:  0
Rows_per_sec.value:     0
ServerName:     /instance1/coreapplication_obis1

dumpMetrics

Displays available metrics in the format raw (default), xml, pdml. The returned value is a text document.

Documentation / Reference