Run Specific Diagnostics

Running diagnostics for specific categories helps troubleshoot issues and ensures the system is optimized.

After you obtain the available diagnostic categories, you can call OBISDiagnostics(string) to obtain diagnostics for individual categories, where string is a category name. For example:

call OBISDiagnostics('ThreadPool:orcldb_pool')

The results appear similar to the following:

Parameter Name	Value
CAPACITY	1000
THREAD COUNT	20
BUSY THREAD COUNT	15
ACCUMULATED REQUESTS	5
MAX STACK SIZE	100

The spelling of the category must be correct, or no rows are returned.

Another example might be:

call OBISDiagnostics('General')

The results appear similar to the following:

Parameter Name	Value
TOTAL SESSIONS	10
QUERIES PER SEC	5
NEW LOGINS	10
ACTIVE LOGINS	7
NEW REQUESTS	30
DATA CACHE HIT PER SEC	5
NEW INIT BLOCKS	10