New Features
DBMS Engine
TCC (Tibero Columnar Compression)
Provides column-based compression feature during Direct Path Load/Insert
Offers compression levels: ARCHIVE HIGH / ARCHIVE LOW / QUERY HIGH / QUERY LOW
Note: Refer to "Tibero Administrator Guide" section 4.2.5
Use of DP (Direct Path) Bitmap Build
Utilizes Bitmap Build during DPL, DPI, INDEX FAST BUILD in cluster environments
Reduces contention and improves performance by minimizing CCC Lock acquisition and decreasing Shared Pool usage
Bcode Lookup Table
Embeds bcode for PL/SQL execution plans and caches it in Shared Memory
Allows Package modification DDL in other sessions even if a Package Instance access session exists
Improves contention on internal DD queries during PL/SQL calls
Pending Statistics
Feature to hold statistics without immediately publishing them
-
Usage examples
Publish after testing
Held statistics โ can be copied to another DB
Note: Refer to "Tibero tbPSM Reference Guide" DBMS_STATS Pending feature
Added IF NOT EXISTS / IF EXISTS Syntax
Allows CREATE / DROP statements to execute without errors depending on object existence
Note: Refer to "Tibero SQL Reference Guide" CREATE/DROP TABLE
Added GIS Function ST_FILTER
Quickly searches only objects where the minimum bounding rectangles of two GEOMETRY objects overlap
Note: Refer to "Tibero Spatial Reference Guide"
Multi Redo Buffer
Allows creation of multiple Redo Log Buffers
Improves Redo buffer contention when many DML sessions exist
Requires ENABLE_MULTI_LOG_BUFFER = Y (default is N)
TAC Memory OOM Automatic Recovery
If Shared Pool shortage persists beyond a specific time (default 5 minutes)
โ automatically performs operational recovery via cluster manager (tbcm) reboot
Supported OS Additions
RHEL 9.6 / Rocky 9.6 / Oracle Linux 9.6
SUSE Linux Enterprise Server 15 SP6
Windows Server 2025
Changed Features
DBMS Engine
Changed Shell Used for Installation / Patch
Use system_install.sh / system_patch.sh to prevent error logs
Note: See โInstallation Guide Appendix H,Iโ
Changed Default Users and Sample Schemas During Installation
Changed tibero privileges (removed dba), removed tibero1
-
Sample schemas: Added LIBRARY / FITNESS (optional)
Creation/deletion scripts available at:
$TB_HOME/scripts/sample_user
LGWR AIO (Asynchronous IO) Feature Improvements
Improved AIO suspend method
Expanded number of IO Event handlers, added batch option
Improved failure handling
Parameter activation required
The following parameters have been changed.
| Parameter name | Before | After | Description |
|---|---|---|---|
| CPU_COUNT | 0 | TB_MAX(1, get_ncpu()) | Specifies the number of CPUs allowed for the instance |
| TB_CTHR_HEARTBEAT | TB_CTHR_HEARTBEAT_TIMEOUT | TB_CTHR_HEARTBEAT_INTERVAL | Changed client connection check interval |
| TB_LOG_ARCHIVE_FORMAT | %s_%t_%s.arc |
%s_%t_%s.arc (default unchanged, internal format improved) |
Improved log archive filename format handling |
| TB_CM_DISC_TIMEOUT | 300 | 600 | Changed TAC cluster disconnect timeout |
| TB_LOG_SWITCH_INTERVAL | 900 | 600 | Shortened redo log switch interval |
| TB_LGWR_AIO_ENABLE | FALSE | TRUE | Enabled LGWR asynchronous IO by default |
| TB_SNAPSHOT_INTERVAL | 3600 | 1800 | Changed snapshot creation interval |
| TB_CCC_REMASTER_PARALLEL | 1 | 4 | Changed number of parallel threads for TAC CCC remastering |
The following parameters have been added.
| Parameter name | Default Value | Description |
|---|---|---|
| ENABLE_MULTI_LOG_BUFFER | N | Whether to enable Multi Redo Buffer feature |
| TB_CM_AUTO_RESTART_TIME | 300 | TAC automatic restart threshold time (seconds) when Shared Pool OOM state persists |
| TB_LOG_ARCHIVE_PARALLEL | 4 | Number of threads for log archive parallel processing |
| TB_AUDIT_FILE_SIZE | 100MB | Single audit file size limit |
| TB_RMGR_BACKUP_SIGNATURE | Y | Whether to generate signature during RMGR backup |
| TB_LGWR_PARALLEL_IO | Y | Enable LGWR parallel IO feature |
| TB_REDO_BUFFER_GROUPS | 4 | Separate Redo Buffers into groups to reduce contention |
| TB_TCC_COMPRESS_LEVEL | QUERY_HIGH | Default compression level for Columnar Compression |
| TB_AUTO_PURGE_INTERVAL | 600 | Recyclebin auto purge interval (in seconds) |
The following parameters have been deleted.
| Parameter name | Description |
|---|---|
| TB_EXT_TABLE_CACHE | Removed due to changes in External Table metadata caching feature |
| TB_CM_HEARTBEAT_INTERVAL | Removed due to integration of CM Heartbeat logic |
| TB_JDBC_COMPAT_MODE | Removed due to end of support for JDBC versions 1.4/1.6 |
| TB_AUDIT_LOG_LEVEL | Audit settings moved to integrated parameter |
| TB_STATS_JOB_INTERVAL | Removed due to improvements in Auto Job Scheduler |
This section briefly describes known issues in Tibero 7.2.4.
Error occurs when deleting FGA (Fine-Grained Auditing) policy
Increased execution time for some queries due to AGGR_TO_ANAL feature improvement
STANDBY startup failure when running standby and recovery manager (RMGR) backup simultaneously
TBR-22003 error occurs when executing ls command after connecting to tbsql on TAS instance