Table of Contents
This chapter describes functions added to or modified in Tibero 6 FixSet06.
The following describes new functions added to Tibero 6 FixSet06.
The following functions have been added.
Tibero Active Storage (TAS)
Added the view that shows jobs running on all disk spaces mounted by a TAS instance.
Can authenticate an ascmd user.
Can back up and recover TAS meta data.
Tibero Standby Cluster (TSC)
Can switchover between TAC and TSC.
DATA
Can compress, encrypt, and deduplicate LOB data.
DD/DDL
Added the [ALL|USER|DBA]_TYPE_VERSIONS catalog views.
Added the [ALL|USER|DBA]_TAB_COLS views.
Added the NUM_NULLS column to the [ALL|USER|DBA]_TAB_COLUMNS views.
Added the PARAMETERS, DOMIDX_STATUS, and DOMIDX_OPSTATUS columns to the [ALL|USER|DBA]_INDEXES views.
Added the TABLE_NAME column that has the same values as in the OBJECT_NAME column to the [ALL|USER|DBA]_CATALOG views.
Added the ELAPSED_TIME and END_TIME columns to the V$SESSION_LONGOPS view.
Added the BANNER column to the V$VERSION view.
Added the LTSN and ITSN columns related to DD versioning to the V$DDCACHE_INFO view.
Added the GV$SQL view.
Can use ALTER statements for external tables.
Added DDL statments for deferrable constraints.
Can encrypt a user password.
Added the disable option for the CREATE TRIGGER statement.
Executor
Can use partition outer join.
Can perform partial sort.
Added the xmlsequence(extract(xmltype)) function.
Supports the following deferred constraints.
not null constraint
check constraint
Added the SYS_TYPEID function.
Frame
Can check NULL for the AGNT deadlock detection logic.
Can retrieve OS statistics.
Added the COMMENTS column and statistics data about CPU and TCP to the V$OSSTAT2 view.
Added the CPU_NAME, PLATFORM_NAME, IP_ADDRESS, and OS_UPTIME columns to the V$DATABASE view.
Can get a host address with the USERENV function.
Character Set
Added MSWIN1253, MSWIN1256, ISO-8859-6, and ISO-8859-7 character sets.
Optimizer
Added the USE_CONCAT and NO_EXPAND hints.
Added partial Indexes.
Implemented range partition pruning for LIKE.
Can collect statistics about table subpartitions with DBMS_STATS.GATHER_TABLE_STATS.
Added the block_sample parameter to the GATHER_[TABLE|SCHEMA|DICTIONARY|DATABASE]_STATS procedures in the DBMS_STATS package.
Added the url_charset parameter to the ESCAPE and UNESCAPE functions in the UTL_URL package.
Can use the relies_on function for a query result cache.
Added the DBMS_ALERT function.
PSM
Can inherit PSM objects.
Added the OWA_UTIL.WHO_CALLED_ME procedure.
Added the TO_NCHAR function.
Added DBMS_UTILITY.CURRENT_INSTANCE and DBMS_UTILITY.DB_VERSION.
Recovery
Can perform a hot backup for multiple tablespaces.
Recovery Manager (RMGR)
Removes relevant data files if a backup fails.
Added the V$BACKUPSET view.
Can perform a backup or recovery in parallel.
TPR (Tibero Performance Repository)
Added 'YES' and 'NO' to the TSC item in a TPR report.
The following functions have been added.
JDBC
Can use a query to check a gateway.
Supports the following character sets.
Classification | Character Set |
---|---|
ISO 8859-7 | Latin/Greek |
ISO 8859-6 | Latin/Arabic |
Windows-1253 | Windows Greek |
Windows-1256 | Windows Arabic |
The following describes functions modified in Tibero 6 FixSet06.
The following functions have been improved.
Optimizer
Adjusts too small sample_size created according to estimate_percent specified in DBMS_STATS by a user. This prevents performance decrease.
Can refresh MView of another schema by using the privilege to access the schema and its synonym.
Improved the selectivity prediction function.
DDL
Improved using the block space when executing the "MULTI INSERT" statement.
PSM
Removed FUNCTION from the list of reserved words.
Parser
Can use the PARALLEL hint for the "MERGE INTO" statement.
Can use the outer join operator (+) along with the TABLE() function.
Improved the DBMS_AQ package.
Can use the object type of payload for AQ.
Can enqueue and dequeue object values.
Can configure retention_time for a single consumer queue.
Tibero Cluster Manager (TBCM)
Modified the connection path between Tibero and CM.
Before modification
Interconnect IP:PORT
After modification
localhost IP:CM_UI_PORT