Document Type | Technical Information
Category | Monitoring/Inspection
Applicable Product Versions | 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 7FS01, 7FS02, 7FS02PS
Document Number | TMOTI012
Overview
By querying j_cnt in tbsql, you can measure the change amount of events over a short period without going through TPR.
This allows you to know the change amount of most event items, and it is possible to extract information not only for all items but also for specific sessions.
Method
Use the function called show j_cnt in tbsql.
Basic Execution
After connecting with the Tibero DBA account, execute show j_cnt.
- These values represent the cumulative totals up to the current point for the target.
- When executed without options, the target is the entire database and the output shows cumulative totals since startup.
SQL> show j_cnt Stat Count Value Time JC_SQL_EXECUTE_ELAPSED_TIME 1761960 0 1834.10888 JC_CSR_FETCH_SELECT 1739494 0 1523.34934 JC_EX_TSCAN_FULL 1747974 0 1478.51925 JC_PROFILE 931557 931557 720.44688 JC_TX 39077 0 439.675915 JC_TPR_SNAP_SAVE 259 259 335.245114 JC_DBWR_WRITE 25507 347041 302.914606 JC_DBWR_WRITE_OS 192856 347041 293.873824 JC_DBWR_SCAN_BUFFER 4689457 347042 269.271834 JC_MSG_CL_CONN_REQ_TOTAL 1687 0 267.398389 JC_CSR_FETCH_INSERT 10114 0 242.279107 JC_REDO_WRITE 39729 2666669 205.098374 JC_DD_SEARCH 3698056 0 174.058557 JC_FSCAN_FETCH 1781550 23784497 82.239399 JC_ASH_SNAP_SAVE 259 0 61.205445 JC_CSR_FETCH_DELETE 10516 0 59.878291 JC_EX_DML_DELETE 10745 0 47.404454 JC_EX_DML_INSERT 19970 0 42.639348 JC_FSCAN_FETCH_MREAD 1781550 23784497 37.614983 (truncated)
Case 1. Query Specific Event
You can check only a specific event by entering show j_cnt {event name}. (Output: cumulative values for the entire DB)
SQL> show j_cnt JC_SQL_EXECUTE_ELAPSED_TIME Stat Count Value Time JC_SQL_EXECUTE_ELAPSED_TIME 1762243 0 1834.46432
Case 2. Query Specific Session
You can check j_cnt only for a specific session by using show j_cnt sess=local (for the session you are connected to) or show j_cnt sess={SESSION ID}. (Output: cumulative event values since the specific session connected)
Caution
Note that show j_cnt itself internally executes queries.When extracting events for specific cases, the output for the entire DB is difficult to use.
SQL> show j_cnt JC_SQL_EXECUTE_ELAPSED_TIME Stat Count Value Time JC_SQL_EXECUTE_ELAPSED_TIME 1762243 0 1834.46432