Table of Contents
This chapter briefly describes newly added and updated features in Tibero 6.7.2.
This section lists and briefly describes newly added features.
The following features have been added.
Database Replay
Added the program to validate the effects on applications when updating or patching Tibero DBMS.
This program captures the workload within the database at the message level to perform the same operations.
Database Replay captures the database itself and replays its operation to assess effects without downtime. This process simulates database operations precisely, allowing an accurate reflection of the operational workload.
This program is particularly effective for environments where procedures and functions are heavily used.
DBreplay is performed in the process of the following steps: Database workload capture, Preprocess, Replay, and Result (optional).
For more information about Database Replay, refer to DBReplay User Guide.
Data Definition Language (DDL)
Automates statistics collection for index creation.
Automatically collects index statistics when executing CREATE INDEX.
Added the following ALTER TYPE statements.
ALTER TYPE ADD METHOD
ALTER TYPE DROP METHOD
ALTER TYPE RENAME ATTRIBUTE
This section lists and briefly describes modified and improved key features of Tibero 6.7.2.
The following features have been improved.
Data Definition Language (DDL)
Improved the performance of the tablespace creation statement when the number of tablespaces is high.
Improved the MOVE operation for LOB-type columns.
Optimizer
Improved the DISPLAY_CURSOR function in the DBMS_XPLAN package.
Executor
Executes DISTINCT AGGREGATION with less memory and at a faster speed.
Reduces memory usage when specifying a partition or subpartition of a partitioned table in a query.
PSM
Increases the maximum size of CHAR and VARCHAR data types used in PSM from 32767 to 65532.
Improved the RESULT_CACHE function in PSM.
Allows sequence in the RESULT_CACHE function.
Displays an error when using REF CURSOR in the RESULT_CACHE function.
Displays an error when using RESULT_CACHE in the nested function.
Displays an error when using RESULT_CACHE in a function in anonymous block.
Recovery
Modified to allow adding datafiles to a tablespace in hot backup status through BEGIN BACKUP.
Cache
Enables V$THRINFO to display buffer handle usage by session and across the entire database instance in real time.
Stability
Improved the stability of the logic related to CCC in a TAC environment.
This section briefly describes updated, added or deleted parameters in Tibero 6.7.2.
The following parameters have been updated.
| Parameter name | Default Value Before | Default Value After |
|---|---|---|
| DBWR_CNT | 1 | 3 |
| LOG_BUFFER | 10485760 | 104857600 |
| SQL_STAT_HISTORY_QSIZE | 50 | 10 |
| SQL_STAT_HISTORY_THRESHOLD | 50 | 100 |
The following parameters have been added.
| Parameter name | Default Value |
|---|---|
| DATABASE_REPLAY_CAPTURE_WORKLOAD | NO |
| DATABASE_REPLAY_CAPTURE_DEST | |
| DATABASE_REPLAY_CAPTURE_FILE_SIZE | 10485760 |
| DATABASE_REPLAY_CAPTURE_DIR_LIMIT | (MAX_SESSION_COUNT * DATABASE_REPLAY_CAPTURE_FILE_SIZE) * 100 |
| DATABASE_REPLAY_DUMP_MMAP_SIZE | 65536 |
| OPTIMIZER_LOG_OUTLINE | NO |
| OPTIMIZER_USE_SQL_PROFILES | NO |
| SQLTUNE_CATEGORY | DEFAULT |
| USE_SQL_STAT_HIST_IN_BG_PROC | NO |
| USE_TRUNCATE_OBJ_PRIVILEGE | NO |
| USE_ZETA | NO |
This section briefly describes known issues of Tibero 6.7.2.
Missing statistics of a partition with no data when creating a partitioned index
Issue
When creating a partitioned index in parallel, the collected statistics do not include the block count value for the index segment of no-data partition, and '0' is entered instead.
Action
Recollect the index statistics by using EXEC DBMS_STATS.GATHER_INDEX_STATS.
Missing subpartition processing in the EXPORT/IMPORT_STATS function of the DBMS_STATS package
Issue
When migrating statistics, subpartitions are not processed for the EXPORT_TABLE/INDEX_STATS and IMPORT_TABLE/INDEX_STATS functions.
Action
None: Plans to provide a patch.
Error with the LAST_ELAPSED_TIME value in the DISPLAY_CURSOR function of the DBMS_XPLAN package
Issue
When displaying LAST_ELAPSED_TIME in the DISPLAY_CURSOR function of the DBMS_XPLAN package, the subquery execution time is double-counted.
Action
Refer to AVG_ELAPSED_TIME instead of LAST_ELAPSED_TIME, taking care to note that the two have different meanings.
Refer to TOT ELAPSED TIME after the query is hard-parsed and executed once.
Error with Wait Time items within Wait Events in TPR
Issue
Some Wait Time items, including TPR Wait Events by Wait Time, show values exceeding 100%.
Action
None: Plans to provide a patch.
Error caused by multi update on tables with LONG and LOB columns
Issue
Performing multiple updates on tables containing LONG and LOB columns causes an error due to missing row reset.
Action
Avoid using multiple operations (by setting _ENABLE_TDD_MU=N and _TDD_MU_ENABLE_ALL_COL=N).
Error caused when enabling standby REDO thread
Issue
Enabling the standby REDO thread causes TBR-2400 error if the number of standby log files exceeds that of online log files.
Action
Add the same number of standby log files as online log files.