Table of Contents
This chapter describes functions added to or modified in Tibero 6 FixSet07.
The following describes new functions added to Tibero 6 FixSet07.
The following functions have been added.
Character Sets
Added the Taiwanese character sets: ZHT16BIG5 and ZHT16MSWIN950.
Added the Japanese character set: SJISTILDE.
Context Index
Supports context index-sync on commit.
Supports context index local partitions.
DD/DDL
Supports 'including exchange'.
Can execute 'alter table exchange partition including indexes'.
Can rebuild the local partition index for a partition to be exchanged.
Added deferred unique constraints.
Added a system table and parameter for log-in audit.
Can modify a default tablespace of a partition index.
Added the 'update global indexes' option to the 'alter table [table_name] drop partition [partition_name]' statement.
Allows SYSAUD users to use the DBMS_AUDIT_EVENT package in Separation of Duties (SOD) environments.
Executor
Added the B number format.
Added over (partition by clause) for the LISTAGG function.
Added the GETNUMBERVAL function as an XMLType member function.
Supports XMLType (object type) in the LENGTH function.
Supports XMLType (CLOB) in the XMLSEQUENCE function.
Can use the NLS_NUMERIC_CHARACTERS parameter for the TO_NUMBER function.
Added the MAC and RANDOMBYTES functions to the DBMS_CRYPTO package.
Supports the CONCAT, UPPER, LOWER, LIKE, TRIM, SUBSTR, INSTR, and PAD functions for NCLOB data.
Added TO_NCLOB and the function that processes NCLOB for REPLACE.
Added TO_BLOB.
Supports parallel merge into statements.
Frame
Added the CONSUMED_CPU_TIME column to V$SESSION.
Added the function that processes DPL messages after compressing them.
Added the following to DBMS_SCHEDULER.
STOP_JOB.
When registering a JOB, a day of week is supported in crontab expressions.
Optimizer
Can collect statistics about NVARCHAR and NCHAR columns.
Added mview refresh on commit for XA.
Parser
Supports UTF-8 full-width comma.
Added the cast (null as index by table or record) statement.
PSM
Added the UTL_I18N.UNESCAPE_REFERENCE function.
Added the UTL_I18N.TRANSLITERATE function. (Only supports kana_fwkatakana.)
Supports the TZ_OFFSET function.
Added the PSM preprocessor.
Can use out parameters for dynamic SQL.
Added SEQUENCE.CURRVAL function.
Supports the LENGTH(BLOB) function.
System view
Added the following views.
DBA_RSRC_PLANS view
DBA_RSRC_CONSUMER_GROUPS view
DBA_RSRC_PLAN_DIRECTIVES view
DBA_RSRC_AUDIT view
V$INTERCONNECTION view
TAC
Supports VIP for IPMP interfaces in Solaris.
TAS
Can perform rebalancing forcibly.
Tibero Cluster Manager (TBCM)
Can dynamically modify retry_cnt and retry_interval of the following resources: databases, Active Storages (AS), and Virtual IPs (VIP).
Can check local resources in all cluster nodes from a node by using cmrctl show all.
Added cmrctl show vip.
Can specify the failure count for cmrctl show db and cmrctl show as.
tbstat
Supports the tbstat library for Windows.
TSC
Can change the status of a primary tablespace to read only and read write.
Can dynamically configure a TSC environment.
Tx(+undo)
Added undo span.
The following functions have been added.
tbLoader
Added the parallel parameter.
Can load multiple input files.
Supports the American format for date, time, and timestamp data.
tbExport
Added the REMAP_TABLE parameter.
Added the following functions.
When exporting constraints, the deferrable and initially deferred options can be used.
If tbExport is not terminated normally, a dump file name has .UNSAFE as a suffix, which allows users to recognize whether the export is complete or not.
Added index_nologging.
The following describes functions modified in Tibero 6 FixSet07.
The following functions have been improved.
Cache
If LOG WRITER fails to write desired data, it retries as many times as the value specified.
Data Dictionary
Improved the performance of the [DBA|ALL|USER]_SEGMENT views.
Added the DEFERABLE and DEFERRED columns to the [DBA|ALL|USER]_SEGMENT views.
DDL
Cannot perform truncate even when processing 'grant all privileges' if USE_TRUNCATE_PRIVILEGE is set to N.
Executor
Improved the following for bind variable capture.
Allocates a fixed size of memory to a shared pool for bind variable capture at boot.
Removes an existing bind variable and saves a new variable if it fails to allocate memory for bind variable capture.
Added the flush function.
SQL> alter system flush bvc;
Improved number sum aggregation.
Improved sort aggregation without group by.
Frame
Modified the default value of the TOTAL_SHM_SIZE parameter to 2 GB.
Modified the default value of the MEMORY_TARGET parameter to 4 GB.
The Resource Manager can control and monitor PEP sessions.
Improved resources-related views.
Can query resource information for each consumer group or session if the Resource Manager is used.
Added statistics such as consumed CPU time, yields, and read blocks.
Lock
Removed WLOCK DUMP because information about all locks can be queried through V$LOCK.
Optimizer
Improved trim, substr, and replace functions for VARCHAR data.
Improved the performance of queries with both 'rownum = 1' and 'order by desc'.
Allows a number without a decimal point to have a format with a decimal point (example, 9999D9999).
Improved the pruning performance when range predicate is used for LIST partitions.
Improved the accuracy of the DBMS_STATS histogram.
Parser
Improved the algorithm that analyzes join predicate when creating views.
Can use slashes (/) and asterisks (*) for hints. The following is an example.
SELECT /*+ INDEX_ASC(BASE "QA/DQA.QA1.DAT_KEY") */ * FROM " QA/DQA.QA1.DAT" BASE WHERE KEY IS NOT NULL;
Can use parallel hints without parameters.
PSM
Can modify the maximum size of a PSM bcode segment by using a parameter. (The size was fixed to 1 MB.)
TAC
When performing allocation and free of a large volume of temp extents in TAC, only a part of multiple tempfiles is used, which causes spinlock competitions. By reducing the competitions, the performance improved.
TAS
When performing rebalancing, if a target disk to which extents are tried to be moved is insufficient, the rebalancing fails. After a certain number of attempts, the target disk is replaced according to the following order.
A disk in the same failure group as the original target disk
A disk in a failure group that has no redundancy of the extents to move
An arbitrary disk without mirroring
Can upgrade a control file in TAS environments.
Tibero Cluster Manager (TBCM)
Executing the 'cmrctl help' command displays relevant information by the action and resource type.
cmrctl help
Usage: cmrctl [action]
cmrctl help
cmrctl [action] [res_type]
Action (action):
add, del, show, start, stop, act, deact, modify
Resource Types (res_type):
file, network, cluster, service, as, db, vip
When the CM resource file exists only in CM_RESOURCE_FILE_BACKUP, not in CM_RESOURCE_FILE, users can determine whether to boot CM with the backup file.
Can use a broadcast address for VIP.
Can add VIP without the root privilege (not recommended).
Tibero Performance Repository (TPR)
Improved the performance of deleting SQLTEXT, SQL_PLAN_STAT, and SQL_PLAN data.
Saves ping status between TAC nodes of the snapshot area, not the status at the time when the report is displayed.
The following functions have been improved.
CLI (ODBC)
Added the logdir parameter to the xa_open function.
Gateways included in each Tibero 6 FixSet07 platform are as follows.
| OS | Gateway |
|---|---|
| Linux (64-bit) | gw4db2_v10 gw4db2_v9 gw4orcl_10g gw4orcl_11g gw4orcl_12c |
| Linux (32-bit) | gw4db2_v10 gw4db2_v9 gw4orcl_10g gw4orcl_11g |
| Linux IA64 | gw4orcl_10g |
| Linux PPC (Little Endian) | None |
| Linux PPC (Big Endian) | gw4orcl_10g gw4orcl_11g gw4orcl_12c |
| AIX 5.3 | gw4db2_v10 gw4db2_v9 gw4orcl_10g gw4orcl_11g gw4orcl_12c |
| AIX 7.1 | gw4db2_v10 gw4db2_v9d gw4orcl_10g gw4orcl_11g gw4orcl_12c |
| HP IA64 | gw4db2_v10 gw4db2_v9 gw4orcl_10g gw4orcl_11g |
| Solaris 5.10 | gw4orcl_10g gw4orcl_11g |
| Solaris 5.11 | gw4orcl_10g gw4orcl_11g |
| Windows (32-bit) | gw4db2_v10.exe gw4db2_v10.pdb gw4db2_v9.exe gw4db2_v9.pdb gw4orcl_10g.exe gw4orcl_10g.pdb gw4orcl_11g.exe gw4orcl_11g.pdb |
| Windows (64-bit) | gw4db2_v10.exe gw4db2_v10.pdb gw4db2_v9.exe gw4db2_v9.pdb gw4orcl_10g.exe gw4orcl_10g.pdb gw4orcl_11g.exe gw4orcl_11g.pdb |