Document Type | Technical Information
Category | Utility
Applicable Product Versions | 5, 6FS07, 6FS07PS, 7FS02, 7FS02PS
Document Number | TUTTI021
Overview
This document explains each menu of the engineer-oriented Monitor Tool, Monitor Shell.
Method
Note
Whether tm is installed needs to be checked by verifying if an alias exists in .profile or .bash_profile depending on the OS shell type.
This document is based on tm version 1.4.3, and functionality and output may vary by version.
0. Running tm
1) tm Login
After connecting to the terminal, entering tm + <Enter> connects you to tm. The password used for connection is the sys account password.
================================
Tibero RDBMS Monitor Ver1.4.38
================================
==================================================
(Disclaimer)
These scripts come without warranty of any kind.
Use them at your own risk.
==================================================
Enter SYS Password :
2) Initial tm Connection
By selecting the desired menu and entering a two-digit number or letter, the corresponding function is executed.
Example) To check all sessions currently connected to the DB, enter 31 + <enter>
-----------------------------------------------------------------------------------
1.GENERAL | 2.SHARED MEMORY
---------------------------------------- + ----------------------------------------
11 - Instance/Database Info | 21 - Database Buffer Hit Ratio
12 - Parameter Info | 22 - Shared Cache Hit Ratio
13 - Tibero Memory Info | 23 - Spinlock(Latch) Hit Ratio
14 - Backup Status |
15 - Backup Status (RMGR Backup Set) |
-----------------------------------------------------------------------------------
3.SESSION | 4.WAIT EVENT/LOCK
---------------------------------------- + ----------------------------------------
31 - Current Session Info | 41 - Current Lock Info
32 - Current Running Session Info | 42 - System Event
33 - Current Running Session Wait Info | 43 - Session Event
34 - Running Session SQL Info | 44 - Session Wait
35 - Current Transaction | 45 - Sysstat
36 - Open Cursor | 46 - Jcntstat
37 - Current Session(TAC) | 47 - Redo Nowait Info
38 - Current Running Session(TAC) |
39 - Current Running Session Wait(TAC) |
-----------------------------------------------------------------------------------
5.SPACE | 6.I/O
---------------------------------------- + ----------------------------------------
51 - Database File Info | 61 - File I/O Info
52 - Tablespace Usage | 62 - Session I/O Info
53 - Undo Segment Usage | 63 - Archivelog Count
54 - Temp Segment Usage |
55 - Diskspace/ASFile Info(TAS) |
-----------------------------------------------------------------------------------
7.OBJECT | 8.SQL
---------------------------------------- + ----------------------------------------
71 - Schema Object Count | 81 - SQL Plan(Input SQL_ID)
72 - Object Invalid Count | 82 - Top SQL
73 - Object Invalid Object | 83 - Check Static Query Pattern
74 - Segment Size(Top 50) | 84 - Check Plan Change(TPR)
75 - Segment Total/Used Size | 85 - Check Plan Change - Range(TPR)
| 86 - SQL Plan(TPR)
-----------------------------------------------------------------------------------
9.TPR (Use Carefully) | 10.TAS
---------------------------------------- + ----------------------------------------
91 - Create TPR Snapshot | 101 - Diskspace Status
92 - Create TPR Snapshot For TAC | 102 - Disk Status
93 - Show TPR Snapshot | 103 - TAS Operation Status
94 - Create TPR Report |
-----------------------------------------------------------------------------------
1. GENERAL
Menu to check basic DB information, startup configuration values, and whether Begin backup is active.
1) Instance/Database Info
Menu to view basic DB information.
============================
Tibero Instance Infomation
============================
Instance Name Database Name Version Status NLS Character Log Mode DB Create Time DB Uptime
--------------- --------------- ------------------------- ------------ -------------------- ------------- -------------------- ---------------
jh_tibero jh_tibero 7 2 292332 FS02_PS03 READ WRITE UTF8/UTF16 ARCHIVELOG 2025/11/10 16:27:54 0d 4h 47m- Instance Name: The name of the running instance, which is the same as the TB_SID value set when Tibero starts.
- Database Name: The name of the running database, set when the database was created after the initial installation.
- Version: The installed Tibero version information.
- Status: Displays the booting mode.
- NLS Character: The encoding used when data is stored in the database, determined in the Create Database statement.
- Log Mode: Displays whether the redo log is archived (Archivelog / Noarchivelog).
- DB Create Time: The date the database was created.
- DB Uptime: The time Tibero has been running.
2) Parameter Info
Menu to check parameter values set in the $TB_SID.tip file and internally within the system.
======================
Parameter Infomation
======================
Parameter Name Value
---------------------------------------- -------------------------
DB_CACHE_SIZE 2863923200
DD_CACHE_MAX 429496729
EX_MEMORY_AUTO_MANAGEMENT YES
EX_MEMORY_HARD_LIMIT -1
GATHER_SQL_EXEC_TIME YES
GATHER_SQL_PLAN_STAT YES
ILOG_TOTAL_SIZE_LIMIT 10737418240
LIBRARY_CACHE_MAX 429496729
LIBRARY_DD_CACHE_MAX 858993459
LISTENER_PORT 8833
MAX_SESSION_COUNT 300
MEMORY_TARGET 8589934592
NLS_DATE_FORMAT YYYY/MM/DD HH24:MI:SS
OPTIMIZER_MODE ALL_ROWS
PEP_PROC_CNT 10
SEM_SET_COUNT 823
SLOG_TOTAL_SIZE_LIMIT 3221225472
TOTAL_SHM_SIZE 4294967296
TPR_SNAPSHOT_RETENTION 30
TPR_SNAPSHOT_TOP_SQL_CNT 10
UNDO_RETENTION 1800
USE_TS_QUOTA NO
USGMT_ONLINE_MAX 360
USGMT_ONLINE_MIN 60
WTHR_PER_PEP 40
_AOP_LOCKTBL_SIZE 128
_CCC_RECL_MAX_DB_CACHE_SIZE 2863311530
_DBWR_AFFINITY_SHIFT 7
_DB_BLOCK_HASH_BUCKETS 699069
_DB_SETUP_COMPLETE YES
_DD_SHP_ALLOC_SLAVE_CNT 1
_HASH_JOIN_BUCKET_SIZE_V 16
_INDEX_BUILD_USING_FULL_SCAN YES
_LC_SHP_ALLOC_SLAVE_CNT 1
_LICENSE_EXPIRE_CHECK_INTERVAL 86400
_MISC_SHP_ALLOC_SLAVE_CNT 4
_OPT_ADJUST_TABLE_PRED_SELECTIVITY 100
_OPT_BIND_PEEKING NO
_RCACHE_BUCKET_COUNT 4096
_RCMAP_BUCKET_COUNT 512
_SMALL_TABLE_THRESHOLD 43690
_TCBUF_EXT_SIZE 512
_USE_DYNAMIC_SAMPLING NO
_USGMT_UNIFORM_EXTSIZE 1024
3) Tibero Memory Info
Menu to check memory settings and usage information of the running Tibero.
=====================
TSM(SGA) Infomation
=====================
NAME Size
---------------------------------------------------------------- --------------------
SHARED MEMORY 4096(MB)
SHARED POOL MEMORY 728(MB)
Database Buffers 2731(MB)
Redo Buffers 100(MB)
DB_BLOCK_SIZE 8(KB)
===============================
Tibero Used Memory Infomation
===============================
NAME Size(MB)
---------------------------------------------------------------- ----------
MEMORY_TARGET 8192
SGA(Used) 3919.83
PGA(Allocated) 588.18
PGA(Used) 26.16
- SHARED MEMORY: The TOTAL_SHM_SIZE value set in $TB_SID.tip. (=Equivalent to Oracle's SGA)
- SHARED POOL MEMORY: The amount of memory used for the SHARED POOL (SQL Cache + Data Dictionary Cache) within SHARED MEMORY.
- Database Buffers: The size of memory used to store actual data. (=Equivalent to Oracle's DB Buffer Cache). If data needed for the buffer is not present or modified data needs to be saved, I/O occurs on the datafile.
- Redo Buffers: The size of the memory area holding contents to be written to the Online RedoLog.
- DB_BLOCK_SIZE: The size of the DB block, the minimum unit of I/O.
- MEMORY_TARGET: The total memory (SGA + PGA) used by the DB.
- SGA(Used): The amount of memory currently used within SHARED MEMORY.
- PGA(Allocated): The size currently allocated in the PGA area used by each session.
- PGA(Used): The size of PGA currently in use.
4) Backup Status
Menu to check information related to tablespace Online Backup.
===============
Backup Status
===============
Tablespace Name Datafile Status Backup Time
-------------------- ------------------------------------------------------------ ------------ -------------------
SYSSUB /sdiske/ps1/pjha/tbdata7/syssub001.dtf NOT ACTIVE
SYSTEM /sdiske/ps1/pjha/tbdata7/system001.dtf NOT ACTIVE
UNDO0 /sdiske/ps1/pjha/tbdata7/undo001.dtf NOT ACTIVE
USR /sdiske/ps1/pjha/tbdata7/usr001.dtf NOT ACTIVE
- Tablespace Name: The name of the tablespace.
- Datafile: The path and filename of the file where data is physically stored.
- Status: Displays whether Begin Backup is active for the tablespace (NOT ACTIVE / ACTIVE).
- Backup Time: The date when the last hot backup was performed for the tablespace (date when Begin Backup was last performed).
2. SHARED MEMORY
Menu to check memory hit rates closely related to DB performance.
1) Database Buffer Hit Ratio
Menu to check the hit ratio for Database Buffers (=Buffer Cache) for operations after DB startup.
Note
The hit ratio increases when data is read directly from memory and decreases when read from the datafile. A low buffer hit ratio may cause performance degradation due to disk I/O.
Improvements can be made by allocating more memory or tuning SQL to avoid full table scans.
===========================
Database Buffer Hit Ratio
===========================
Time Physical read Logical read Hit Status
------------------- ------------- ------------ ---------- --------
2025/12/08 13:26:45 2127 671571 99.68 Good- Time: The time this menu was queried.
- Physical read: The number of times data blocks were read from the datafile.
- Logical read: The number of times data blocks were read from memory only.
- Hit: Calculated as 1 - (Physical read / Logical read) * 100.
- Status: Hit > 90 then 'Good', 70 <= Hit <= 90 then 'Average', Hit < 70 'Not Good'.
2) Shared Cache Hit Ratio
Menu to check the hit ratio for Shared Cache (=Shared Pool) after DB startup.
========================
Shared Cache Hit Ratio
========================
Time Name Hit(%) Status
------------------- ------------------ ---------- --------
2025/12/08 13:27:09 SQL(Library) Cache 99.37 Good
2025/12/08 13:27:09 Dictionary Cache 99.56 Good
Time Name Used(MB) Total(MB) Memory Usage(%)
------------------- ----------------------- ---------- ---------- ---------------
2025/12/08 13:27:09 Shared Cache Free Space 552 728 75.81
Time Soft Parse(%)
------------------- -------------
2025/12/08 13:27:09 80.66- SQL(Library) Cache: The ratio of soft parsing during SQL execution.
Note
Values shortly after DB startup are not very meaningful; values after some operation time are important.
A low SQL Cache Hit indicates frequent hard parsing when executing SQL.
This wastes system resources (CPU and Shared Pool) and negatively affects performance.
Improvement can be made by reviewing frequently used SQLs to unify spacing, case, etc., converting literal queries to bind variables, and applying the CURSOR_SHARING=FORCE parameter.
- Dictionary Cache: The ratio at which object information for the input SQL is found in the cache area.
Note
Frequent DDL execution or a large number of objects exceeding allocated memory can cause a drop in hit ratio; maintaining above 90 is recommended.
Improvement can be made by allocating additional memory.
- Shared Cache Free Space: The free space in Shared Cache; generally recommended to maintain above 10%.
Note
Having less than 10% free space alone is not problematic, but if SQL Cache or Dictionary Cache Hit is low (below 70), memory allocation for Tibero should be checked.
- Soft Parse(%): The percentage of soft parses for user-executed SQLs, excluding system-internal SQLs; may differ from SQL(Library) Cache Hit.
3) Spinlock(Latch) Hit Ratio
Menu to check the hit ratio for Spinlock (Latch) after DB startup.
===========================
Spinlock(Latch) Hit Ratio
===========================
NAME Gets Misses miss(%) Sleeps slps/miss(%) wait_time(s) Nowait Request Nowait Miss(%)
------------------------------ ---------------- ---------------- ---------- ------------ ------------ ---------------- -------------- --------------
SPIN_SHP_ALLOC_SLAB 6,835 6,727 98.42 3,786 56.28 166 13801 54.76
SPIN_DD_CACHE_BUCKET 141,774 10,847 7.65 574 5.29 1 0 -1
SPIN_BITQ 13,911,685 86 0 1 1.16 0 0 -1
SPIN_L1CL 5,765,774 14,356 .25 7,137 49.71 0 0 -1
SPIN_PARAM 320,569 22,228 6.93 2,896 13.03 0 0 -1
SPIN_ALLOC 28,757,584 24,826 .09 1,049 4.23 0 0 -1
SPIN_BUF_WS_CKPT 5,024,792 0 0 0 -1 0 0 -1
SPIN_BUF_WS 4,239,924 0 0 0 -1 0 419626 .01
... truncated- NAME: The name of the spinlock.
- Gets: The number of spinlock requests.
- Misses: The number of spinlock waits.
- miss(%): The ratio of waits compared to spinlock requests.
- Sleeps slps/miss(%): The ratio of acquiring spinlock after sleep.
- wait_time(s): The spinlock wait time.
- Nowait Request: The number of spinlock requests in nowait mode.
- Nowait Miss(%): The failure rate of spinlock in nowait mode.
3. SESSION
Menu to check information about sessions connected to the DB.
1) Current Session Info
Displays all sessions currently connected to the DB.
======================
Current Session Info
======================
Sid,Serial Username Status IPaddr Logon_Time Program SQL_ID Client_Pid Wthr_Pid Wthr_Id
---------- --------------- ---------- --------------- -------------------- ------------------ ---------------- ---------- ---------- ----------
19,8 SYS ACTIVE 127.0.0.1 2015/12/15 03:27:01 tbsql 40 13078 13041 1
20,61916 SYS ACTIVE 192.168.194.1 2015/12/15 18:50:31 tbAdmin 128 -1 13041 2
21,65540 TIBERO SESS_RECOV 127.0.0.1 2015/12/15 19:44:33 tbsql 15944 13041 3
ERING
22,65465 SYS ACTIVE 127.0.0.1 2015/12/15 19:43:26 tbsql 15963 13041 4
23,65617 SYS RUNNING 127.0.0.1 2015/12/15 19:45:42 tbsql 41 16126 13041 5
29,65612 SYS RUNNING 2015/12/15 19:45:37 UPDATE SESS LTIME 0 13042 1
9,5 SYS ACTIVE 2015/12/15 03:26:59 APM SESSION 0 13040 1
[Run: 2] [Tot: 7]
- Sid, Serial#: Values for session ID used for Kill Session or dump commands.
- Username: The connected user name.
- Status: The session status (ACTIVE / RUNNING / TX_RECOVERING / SESS_RECOVERING / ASSIGNED).
- IPaddr: The client IP information.
- Logon_Time: The time the session connected to the DB.
- Program: The client program type.
- SQL_ID: The ID of the SQL last executed (or executing) by the session; used to check the SQL in the v$sqlarea view or in Monitor Shell's 81 - SQL Plan(Input SQL_ID) menu.
- Client_Pid: The client PID.
- Wthr_Pid: The ID of the working process the session belongs to, matching the OS PID shown by the ps command.
- Wthr_Id: The ID of the thread connected within the working process the session belongs to.
2) Current Running Session Info
Same structure as 3.1 Current Session Info but shows sessions currently performing transactions (status RUNNING).
3) Current Running Session Wait Info
Menu to check wait events of sessions currently running.
===========================
Current Session Wait Info
===========================
Sid,Serial Username Staus Program PGA(MB) SQL_ID SQL Wlock_Wait Wait_Event Object_Name Wait_Time(s)
---------- --------- ---------- --------------- ---------- ---------------- ------ ------------ ----------------- -------------------- ------------
21,66727 SYS RUNNING tbsql 2 151 SELECT . 0- Sid, Serial, Username, Status, Program are the same as in menus 3.1 and 3.2.
- PGA(MB): The size of PGA currently used by the session.
- SQL_ID: The ID of the SQL currently executing in the session.
- Wlock_Wait: The type of WLOCK the session is waiting for.
- Wait_Event: The type of wait event for the session.
- Object_Name: The name of the object related to the wait event.
- Wait_Time: The time the session has been waiting due to the event.
4) Running Session SQL Info
Menu to check information about currently running SQL.
======================
Running Session(SQL)
======================
SID USERNAME PIECE Type SQL
---------- --------------- ---------- ---------- ----------------------------------------------------------------------
19 TIBERO 0 WTHR insert into test select level from dual connect by level < 10000
19 TIBERO 1 WTHR 000000- SID: Displays the session ID.
- USERNAME: Displays the user name running the SQL.
- PIECE: The order of the SQL output.
- Type: The process type of the session; WTHR when the user is executing SQL.
Note
FGWP: Working Process
RCWP: Recovery Process
PEWP: Parallel Process
MGWP: Monitor Process
AGNT: Sequence Process
DBWR: Database Writer Process
- SQL: Displays the currently executing SQL.
5) Current Transaction
Menu to view currently active transactions.
=====================
Current Transaction
=====================
SID User OBJ Status Usn Used_blk Time [ SQL_ID]Text
---------------------------------------------------------------------------------------------------------------
19 TIBERO TIBERO.TEST ACTIVE 2 6 0:01:05 [1032] insert into test select level
from dual connect by level < 10000- SID: Displays the session ID.
- User: Displays the user name.
- OBJ: Displays the transaction target object in 'owner.name' format.
- Status: Indicates the session status (ACTIVE / RUNNING).
- Usn: Displays the Undo Segment number allocated to the transaction.
- Used_blk: Displays the number of undo blocks used by the transaction.
- Time: Displays the transaction duration up to the query time.
- [SQL_ID]Text: Displays the SQL ID and SQL text.
6) Open Cursor
Menu to check the number of open cursors per session.
====================
Open Cursor Status
====================
SID COUNT
---------- --------
123 1
- SID: Displays the session ID.
- COUNT: The number of cursors used by the session; normally one cursor is used per SQL execution.
7) Current Session(TAC)
TAC version of item 3.1. Inst_ID (node ID) is added for each node distinction.
8) Current Running Session(TAC)
TAC version of item 3.2. Inst_ID (node ID) is added for each node distinction.
9) Current Running Session Wait(TAC)
TAC version of item 3.3. Inst_ID (node ID) is added for each node distinction.
4. WAIT EVENT/LOCK
Menu to check wait events and transaction lock information.
1) Current Lock Info
Menu to view lock information for current transactions.
1-1) Blocking/Waiting Lock
Displays lock information for blocking and waiting sessions.
=======================
Blocking/Waiting Lock
=======================
Blocking User Waiting User Blocking Sid Waiting Sid Lock Type Holding mode Request mode SQL_ID
--------------- --------------- ------------- ------------ ------------ --------------- --------------- ----------------
TIBERO TIBERO 20 19 WLOCK_TX [5]Exclusive(X) [6]PIN 144- Blocking User: The user name of the session holding the lock.
- Waiting User: The user name of the session waiting for the lock.
- Blocking Sid: The session ID holding the lock.
- Waiting Sid: The session ID waiting for the lock.
- Lock Type: The type of lock (WLOCK_TX: Transaction Lock / WLOCK_DD_OBJ: Object Lock).
- Holding Mode: The lock mode of the holding session.
Note
0: None
1: Row-Shared (RS)
2: Row-Exclusive (RX)
3: Shared (S)
4: Shared-Row-Exclusive (SRX)
5: Exclusive (X)
6: Pin (Special mode for TX-wait)
- Request Mode: The lock mode requested by the waiting session (same types as Holding Mode).
- SQL_ID: The SQL ID of the session holding the lock.
1-2) DML Lock Information
Displays DML lock information.
======================
DML Lock Information
======================
Sid Status User Object Lock_time Lock mode SQL_ID
---------- -------- --------------- ----------------------------------- --------------- --------------- ----------------
20 ACTIVE TIBERO TIBERO.TEST 0:00:31 [2]Row-X(RX) 144
19 RUNNING TIBERO TIBERO.TEST 0:00:16 [2]Row-X(RX) 146
- Sid: Session ID requesting the lock.
- Status: Session status information.
- User: User who executed the DML.
- Object: Object on which DML was performed.
- Lock_time: Lock wait time.
- Lock mode: Displays the lock mode.
Note
0: None
1: Row-Shared (RS)
2: Row-Exclusive (RX)
3: Shared (S)
4: Shared-Row-Exclusive (SRX)
5: Exclusive (X)
6: Pin (Special mode for TX-wait)
- SQL_ID: The SQL ID of the session holding the lock.
1-3) Object Lock Information
Displays DML lock information.
============================================
Object Lock Information(Library cache Lock)
============================================
Sid Owner Object Type LOCK_TYPE
---------- --------------- ----------------------------------- --------------- ---------------
19 TIBERO TEST TABLE WLOCK_DD_OBJ
19 TIBERO TEST TABLE WLOCK_DD_OBJ- Sid: Displays the session ID requesting the lock.
- Owner: Displays the owner name of the locked object.
- Object: Displays the name of the locked object.
- Type: Displays the type of the object.
- LOCK_TYPE: Displays the type of lock.
2) Hierarchical Lock Info
Menu to view locks hierarchically to identify blocking and waiting sessions.
======================
Hierarchical Lock Info
======================
Sid-Path TYPE ID1 ID2 LMODE REQUESTED
------------ ------------- ---------- ---------- ---------- ----------
20/19 WLOCK_TX 655406 16 0 6- Sid-Path: Displays Blocking Session ID - Waiting Session ID.
- TYPE: Displays the lock type.
- ID1: Lock resource identifier (dependent on lock type).
- ID2: Lock resource identifier (dependent on lock type).
- LMODE: Displays the lock mode of the holding session.
Note
0: None
1: Row-Shared (RS)
2: Row-Exclusive (RX)
3: Shared (S)
4: Shared-Row-Exclusive (SRX)
5: Exclusive (X)
6: Pin (Special mode for TX-wait)
- REQUESTED: Displays the lock mode requested by the waiting session (same types as LMODE).
3) Hierarchical Lock Info (TAC)
TAC menu for item 4.2. Instance number is added to Sid-Path.
4) System Event
Menu to check system wait event information, showing weighted values since DB startup.
NAME TIME_WAITED TOTAL_WAITS TOTAL_TIMEOUTS AVERAGE_WAIT MAX_WAIT
---------------------------------------- ----------- ----------- -------------- ------------ ----------
WE_WTHR_RECV 681104 200 0 3405.52 263781
WE_JC_LARC_WRITE 101858 6 0 16976.3333 30626
WE_JC_DBWR_WRITE_OS 53740 2394 0 22.4477861 3306
WE_JC_BUF_DISK_READ 48213 17456 0 2.76197296 3353
... truncated- NAME: Displays the name of the wait event.
- TIME_WAITED: Displays the wait time for the event (in milliseconds).
- TOTAL_WAITS: Displays the number of times the event was waited on.
- TOTAL_TIMEOUTS: Displays the number of timeouts for the event.
- AVERAGE_WAIT: Displays the average wait time for the event.
- MAX_WAIT: Displays the maximum wait time for the event.
5) Session Event
Menu to check event information performed by a specified session.
==============
System Event
==============
TID DESC TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT
---------- -------------------------------------------------- ----------- -------------- ----------- ------------ ----------
19 wthr receive client msg 16 0 403003.754 25187.734 263781.975
19 multi block disk read time 678 0 4686.731 6.912 59.887
19 block disk read time 7927 0 2930.26 .369 65.234
19 get multi block read count time 268 0 356.067 1.328 27.917
19 multi block read check on cache time 698 0 56.726 .081 .478
19 spinlock total wait 269 0 4.258 .015 .378
19 spinlock: cache buffers chains 244 0 3.525 .014 .107
19 spinlock: cache buffers lru chain 1 0 .008 .008 .008
... truncated- TID: Displays the session ID.
- DESC: Displays the event description.
- TOTAL_WAITS: Displays the number of times the event was waited on.
- TOTAL_TIMEOUTS: Displays the number of timeouts for the event.
- TIME_WAITED: Displays the wait time for the event (milliseconds).
- AVERAGE_WAIT: Displays the average wait time.
- MAX_WAIT: Displays the maximum wait time.
6) Session Wait
Menu to check current wait event information for sessions.
==============
Session Wait
==============
SID PID User Event Time Waited(ms) Timeout(ms) Program IP
------------------------------------------------------------------------------------------------------------------
9 0 SYS WE_NOEVENT 300 1000 APM SESSION
19 7108 TIBERO WE_WLOCK_TX 633700 0 tbsql 127.0.0.1- SID: Displays the session ID.
- PID: Displays the process ID.
- User: Displays the name of the account connected to the DB.
- Event: Displays the name of the wait event.
- Time Waited(ms): Displays the wait time for the event.
- Timeout(ms): Displays the timeout value for the event.
- Program: Displays the name of the client program connected.
- IP: Displays the client IP information.
- LMODE: Displays the lock mode of the holding session.
7) Sysstat
Menu to check system execution statistics with weighted values since instance startup.
=========
Sysstat
=========
STAT# NAME CLASS VALUE
----------------------------------------------------------------------------------------
1632 transactions total time 5 719276606
596 redo log size 1 556309133
1687 req service time 5 105217245
1692 SQL processing time 3 105075909
... truncated- STAT#: Displays the stat ID.
- NAME: Displays the stat name.
- CLASS: Displays the stat class.
- VALUE: Displays the stat value.
8) Jcntstat
Menu for debugging purposes.
9) Redo Nowait Info
Menu to check redo space request information for redo entry logging.
=============
Redo Nowait
=============
Redo entries Redo space requests Redo NoWait %
------------ ------------------- -------------
20 2862362 100- Redo entries: The number of redo records written to the log buffer by the session.
- Redo space requests: The number of times the session requested space allocation in the log buffer.
- Redo NoWait %: The percentage of redo acquired in nowait mode. Calculation: (ROUND(100*(1-rlsr/rent),2))