Table of Contents
This chapter briefly describes newly added and updated features in Tibero 6.7.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)
Multi-Node standby (Multi-Node TSC)
Ensures high availability between the primary and standby nodes. In read-only mode, queries are distributed across the nodes and this results in a greater query performance.
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.
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.
CM(Cluster Manager)
Cluster Auto Restart
Restarts the cluster following interconnect recovery.
VIP Relocate
Transfers or changes VIP ownership.
CM STONITH
Isolates a failed node in CM to ensure continued operation.
TAS Disk Repair Timer
Automatically drops a failed disk in TAS after a certain period of time.
Splitting Encryption Keys with HSM Devices
Stores wallet-managed keys to a Hardware Security Module (HSM).
The following HSM devices are supported.
D'Amo KMS (Penta Security)
Vormetric Data Security Manager (Thales)
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.
CLIENT_APPCTX
Added the package to set and delete attributes in the Application Context.
The following features have been added.
tbJDBC
JDBC 4.1 Standards
Supports java.math.BigInteger and JDBC type BIGINT.
Supports disconnection using the connection.abort function.
Supports specifying schema using the connection.setSchema function.
Supports specifying a timeout using the connection.setNetworkTimeout function.
Supports closing statements upon the end of result sets using the statement.closeOnCompletion function.
Supports specifying return types using a class as the argument of the Resultset.getObject function.
JDBC 4.2 Standards
Supports java.time.LocalDate, LocalTime, LocalDateTime, OffsetTime, and OffsetDateTime types.
Supports specifying types using SQLType as the argument of the setObject and registerOutParameter functions.
Supports returning the affected row count value in the long data type using the Statement.executeLargeUpdate function.
Added BATCH INSERT feature for the USER DEFINED type.
Enabled the ANYDATA type in JDBC.
The following utilities have been added.
Recovery Manager Tool (TBRMGR)
Provides compatibility for NetBackup, a backup and recovery solution by Veritas.
Provides additional features of the Recovery Manager Tool.
Stabilized the Recovery Manager Tool.
tbLoader
Added the BLANK keyword to the WHEN and NULLIF conditions in the control file.
Loads zoned decimal format.
Loads JSON type.
tbExport
Exports JOBs.
Exports the user defined type.
Exports table data without migrating the data dictionary.
Exports the directory when using the FULL mode.
tbImport
Imports JOBs.
Imports the user defined type.
This section lists and briefly describes modifies and improved key features in Tibero 6.7.1.
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.
Frame
Improved memory management.
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.
Improved TAC network of high-performance server.
Improved the instance recovery performance.
Stabilized the message processing logic between instances in a TAC environment.
TAS
Improved handling of contention related to resyncronization in a TAS environment.
Improved tbascmd.
Enhanced user-friendliness.
Added the mv and check commands.
Added the cp parallel execution.
Stability
Improved the stability of parallel execution.
Improved the stability of TAS.
Improved the stability of synchronization in TSC.
Improved the stability of memory use.
Improved the functionality and stability of DBMS_METADATA.
Improved the stability of the GIS function.