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 |