Table of Contents
This chapter describes functions added to or modified in Tibero 6 FixSet04.
The following describes new functions added to Tibero 6 FixSet04.
The following functions have been added.
Cache
Can perform Scattered Multi-Block Read (MBR) for blocks that do not exist in a buffer cache after copying them to PGA through AIO.
Added the Flashback Database function that recovers an entire database to a specific TSN.
Tibero Cluster Manager (TBCM)
Removed the -n option from the tbcm command.
For more information, refer to "Chapter 9. Tibero Cluster Manager" in Tibero Administrator's Guide.
Tibero Active Cluster (TAC)
Added the "ALTER SYSTEM SWITCH LOGFILE GLOBAL" statement.
Tibero Standby Cluster (TSC)
Can create a Standby DB without stopping a database by performing a hot (online) backup.
Displays a hotfix patch applied to Tibero in a TPR report.
Tibero Performance Repository (TPR)
Can create a TPR report every hour.
Can create a report about a user-specified snapshot.
For more information, refer to "Chapter 14. Tibero Performance Repository" in Tibero Administrator's Guide.
Data Definition Language (DDL)
Added the ACTION column to DBA|ALL|USER_AUDIT_TRAIL views.
Added flashback-related DDL statements.
For more information, refer to Tibero SQL Reference Guide.
PSM
Added the UTL_RECOMP package.
Added the DBMS_LOB.LOADFROMFILE procedure.
Added the FORALL statement to run a dynamic DML statement multiple times.
system.sh Script
Can record the start time of executing the system.sh script.
Added the -e option to find script errors that can occur when executing system.sh.
Added the Temp Tablespace Shrink function for tablespaces.
DB Link
Displays a dump about PGA memory allocation used by libraries when linking databases.
Executor
Added the SESSIONTIMEZONE function.
Support functions for object tables.
Can use a member function for object tables.
Can transform WGS84 coordinates.
Optimizer
Can unnest subqueries in the select list when executing the "INSERT INTO SELECT" statement.
Parser
Added functions for Japanese lexer.
Character Set
Displays Tibero character sets that are shown as the result of "tbboot -C".
Packages
The following packages have been added.
DBMS_SERVER_ALERT package
DBMS_MONITOR package
DBMS_SERVER_ALERT package
Parameter
The following parameters have been added.
Parameter | Description |
---|---|
AS_ADDR | IP address of the TAS instance accessed by Tibero instance. |
FLASHBACK_LOG_ARCHIVE_ FORMAT | Flashback database archive log format. |
PSM_ERROR_CONV | Option to automatically convert errno to user-specified error number when compiling PSM. |
USE_ACTIVE_STORAGE | USE_TAS used in previous versions is renamed to USE_ACTIVE_STORAGE. |
USE_RESOURCE_MANAGER | Option to use instance caging. |
The following parameters have been removed.
Parameter | Description |
---|---|
USE_TAS | Renamed to USE_ACTIVE_STORAGE. |
CM_NODE_ID | Removed because TBCM no longer manage membership manually. |
CM_NODES | Removed because TBCM no longer manage membership manually. |
The following function has been added.
JDBC
Added the function that encrypts login passwords.
The following describes functions modified in Tibero 6 FixSet04.
The following functions have been improved.
Data Definition Language (DDL)
The maximum number of columns in a table is changed from 1000 to 1500.
Data Layer
Can merge indexes created by "CREATE INDEX" for non-NUMBER and non-VARCHAR columns.
Executor
Can perform a full table scan with Multi Block Read Count that has a changeable value, not a fixed value, such as 1, 2, and 4 regardless of the rownum condition.
Tibero Active Storage (TAS)
Establishes only one connection when Tibero accesses a TAS instance.
Added the DMON (Disk Monitor) thread to periodically try to perform disk I/O. If the I/O fails, the disk status becomes FAIL.