Table of Contents
This chapter briefly describes newly added and updated features in Tibero 7.2.1.
This section lists and briefly describes newly added features.
The following features have been added.
TAC(Tibero Active Cluster)
Replaceable online undo tablespaces
Enables the replacement of undo tablespaces during online operations in TAC environment.
TSC(Tibero Standby Cluster)
Zero-downtime standby
Enables the creation of a standby database only using archive log files without requiring a backup of the online redo log files and disruption to the primary database.
Forcible synchronization with standby
Clears different logs without returning the original primary database to its primary status, brings the data block images, accessed by the logs, from the new primary database (originally the standby), and forcibly synchronizes them to ensure that the original primary database is reverted to the standby status.
Replaceable online undo tablespaces
Enables the replacement of undo tablespaces during online operations in TSC environment.
Limiting primary IP addresses connected to standby
Limits the primary IP addresses allowed to connect to the standby database.
Collecting Statistics
[ DBA | ALL | USER ]_TAB_MODIFICATIONS
Added a view to display row modifications in the table through DML operations since the last statistics collection.
[ DBA | ALL | USER ]_TAB_STATISTICS
Added a view to display statistics for the table.
GRANULARITY option
Added the GRANULARITY option for collecting DATABASE, DICTIONARY, SCHEMA, and INDEX statistics.
Added a feature to collect statistics for a specified subpartition when gathering table statistics.
Improved performance of statistics collection
Added a feature to use TEMPORARY TABLE to collect statistics.
System Package
DBMS_PARALLEL_EXECUTE
Added the package to enable parallel updates to a table.
DBMS_XMLDOM
Supports the DBMS_XMLDOM package on Solaris 5.11.
TAS
Added the begin and end backup feature in TAS to ensure compatibility of TAS meta files.
Frame
Added the feature to clean up the sessions with active transactions when no client requests are received during a specific time period.
This section lists and briefly describes modifies and improved key features.
The following features have been improved.
Data Definition Language (DDL)
Improved the performance of parallel index building.
Improved handling of deadlocks and race conditions between sessions.
Improved performance when using sequences in large quantities.
Improved usability by saving unusable index space.
Added the UPDATE GLOBAL INDEXES feature.
Optimizer
Enabled the INDEX SKIP SCAN feature when using the LIKE condition.
Improved the performance of the JOIN plan.
Executor
Improved block sampling when performing TABLE FULL SCAN.
Improved performance by performing TABLE FULL SCAN in the PGA for tables larger than a specific threshold.
CONTEXT INDEX
Improved the creation of CONTEXT INDEX.
Improved search performance using CONTEXT INDEX.
Buffer Cache
Improved handling of contention for buffer cache buckets.
TAC(Tibero Active Cluster)
Improved handling of resource race conditions in a TAC environment.
Improved FULL SCAN performance in a TAC environment.
Stabilized the message processing logic between instances in a TAC environment.
TSC(Tibero Standby Cluster)
Enables ASYNC LNW to send log referring to LOG_ARCHIVE_DEST.
TAS
Improved TAC resynchronization to allow a new TAC instance to boot immediately, without waiting for resyncronization to complete.
Modified to skip rebalancing as needed when performing DISK ADD in a TAS environment with external redundancy diskspace.
Improved functionality and stability of TBASCMD.
Controlfile
Improved the stability of input/output logic related to control files.
TPR
Added the SQL ID to each query information in the TPR report.
Label Security
Changes the Label Security system user from SYS to LBACSYS.
Added or improved the following packages and procedures.
SA_POLICY_ADMIN
SA_USER_ADMIN
SA_AUDIT_ADMIN