Release note_7.2.2
This chapter briefly describes newly added and updated features in Tibero 7.2.2.
New Features
This section lists and briefly describes newly added features.
DBMS Engine
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).
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
Utilities
gateway for oracle
– Added a memory allocator dump feature of the gateway used to link Tibero to Oracle database.
Updated Features
DBMS Engine
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.
Parameter
Modified Parameters
DBWR_CNT
1
3
OPTIMIZER_LOG_OUTLINE
NO
YES
OPTIMIZER_USE_SQL_PROFILES
NO
YES
SQL_STAT_HISTORY_QSIZE
50
10
SQL_STAT_HISTORY_THRESHOLD
50
100
New Parameters
DATABASE_REPLAY_CAPTURE_WORKLOAD
NO
DATABASE_REPLAY_CAPTURE_DEST
DATABASE_REPLAY_CAPTURE_FILE_SIZE
10485760
DATABASE_REPLAY_CAPTURE_DIR_LIMIT
(MAX_SESSION_COUNT * DATABASE_RE
PLAY_CAPTURE_FILE_SIZE) * 100
DATABASE_REPLAY_DUMP_MMAP_SIZE
65536
EXTRA_LISTENER_IPS
-1
GROUP_BY_SORT_TREE_NODE_DUMP_MAKE_NEW
NO
GROUP_BY_SORT_TREE_NODE_DUMP_MAKE_RE
SULT
NO
SEQUENCE_PIN_BUCKET_CNT
100
USE_SQL_STAT_HIST_IN_BG_PROC
NO
USE_TRUNCATE_OBJ_PRIVILEGE
NO
Known Issue
This section briefly describes known issues of Tibero 7.2.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.
Last updated