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).

Note

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

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

Parameter name	Default Value Before	Default Value After
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

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_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.