Skip to main content

Search

Welcome to Tibero GTS!

Easy Extraction Method for j_cnt

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

 

 

 

Related to