Release note_7.2.1
This chapter briefly describes newly added and updated features in Tibero 7.2.1.
New Features
This section lists and briefly describes newly added features.
DBMS Engine
TAC(Tibero Active Cluster)
Online Undo tablespace replacement
Undo Tablespace can be replaced during online on TAC environment.
TSC(Tibero Standby Cluster)
Non-stop standby deployment
– Added a function to build a standby DB using only archive logfiles without stopping the primary DB and backing up online redo logfiles.
Standby forced reverse synchronization
The existing primary can clear the logs with differences without rebuilding, receive the data block image accessed by the log from the primary (existing standby), force sync, and become a standby.
Online Undo tablespace replacement
Undo Tablespace can be replaced during online on TSC environment.
Restrict primary connection IP from standby
– Restricts connection from Standby to only specific IPs of the Primary.
Statistical information collection
[ DBA | ALL | USER ]_TAB_MODIFICATIONS
– Added view to check the amount of change in ROWS that has been DML proceeded to the table since the last statistical information collection.
[ DBA | ALL | USER ]_TAB_STATISTICS
– Added a view that provides statistical information about the table.
GRANULARITY
– Added GRANULARITY to DATABASE, DICTIONARY, SCHEMA, INDEX statistical information collection.
– Added TABLE statistics collection only on specified SubPartitions.
Statistical information collection performance
– Collects statistics information using TEMPORARY TABLE.
System Package
DBMS_PARALLEL_EXECUTE
– Added a package to provide the ability to update tables in parallel.
DBMS_XMLDOM
– Supports DBMS_XMLDOM package on Solaris 5.11.
TAS
– Added TAS begin/end backup to ensure the consistency of the TAS metafile.
Frame
– Added a feature to clean up the session if no request from client for a certain period of time in a session where an active transaction exists.
Utilities
tbImport
– Added option to set INDEX PARALLEL DEGREE when importing.
Updated Features
DBMS Engine
Data Definition Language (DDL)
– Improved Parallel INDEX build performance.
– Improved DD LOCK contention between sessions.
– Improved performance when using bulk SEQUENCE.
– Improved usability by returning space in UNUSABLE INDEX.
– Added the UPDATE GLOBAL INDEXES.
Optimizer
– Activated INDEX SKIP SCAN when using the LIKE conditional statement.
– Improved JOIN plan performance.
Executor
– Improved BLOCK SAMPLING performance during TABLE FULL SCAN.
– Improved Performance by performing a TABLE FULL SCAN of a size larger than a certain HRESHOLD using PGA.
CONTEXT INDEX
– Improved CONTEXT INDEX creation performance.
– Improved Search performance using CONTEXT INDEX.
Buffer Cache performance
– Improved Buffer cache bucket contention.
TAC(Tibero Active Cluster)
– Improved resource contention in the TAC environment.
– Improved FULL SCAN performance in the TAC environment.
– Stabilized the message processing logic between instances In the TAC environment.
TSC(Tibero Standby Cluster)
– Added ASYNC LNW to transmit logs by referring to LOG_ARCHIVE_DEST.
TAS
– Improved TAS to boot immediately without waiting for resync to complete If a new TAC Instance is booted while TAS is performing resync.
– skipped rebalance on necessary When adding a DISK in a TASK environment consisting of external redundancy disk space.
– Improved feature and stability of TBASCMD.
Controlfile
– Improved a stability of controlfile related I/O logic.
TPR
– Added SQL ID item output to the query unit information in the TPR report.
Label Security
Renamed the Label Security system user from SYS to LB
Added or improved packages and procedures
SA_POLICY_ADMIN
SA_USER_ADMIN
SA_AUDIT_ADMIN
Utilities
tbSQL
– Expanded a range of SET INTERVAL support from natural numbers to real numbers with 3 decimal places.
– Added a feature to specify the number of loops adding COUNT to LOOP.
Last updated