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
Articles Related
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
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
- Metrics Dump: fmw_home/user_projects/domains/bifoundation_domain/servers/bi_server1/logs/metrics