Table of Contents
This chapter describes functions added to or modified in Tibero 6 FixSet02.
The following describes new functions added to Tibero 6 FixSet02.
The following functions have been added.
Checking and Modifying Statistics
Added the following procedures that allow users to get and write statistics.
| Procedure | Description |
|---|---|
| dbms_stats.get_table_stats | Gets statistics about the specified table from Data Dictionary (DD) or a statistics table. |
| dbms_stats.set_table_stats | Writes statistics about the specified table to DD or a statistics table. |
| dbms_stats.get_index_stats | Gets statistics about the specified index from DD or a statistics table. |
| dbms_stats.set_index_stats | Writes statistics about the specified index to DD or a statistics table. |
| dbms_stats.get_column_stats | Gets statistics about the specified column from DD or a statistics table. |
| dbms_stats.set_column_stats | Writes statistics about the specified column to DD or a statistics table. |
Backup & Recovery
Added the "alter database register logfile" DDL statement in order to use log that is not located in a base position for an automatic recovery.
DDL
Added virtual columns.
Can compress tables with LONG or LOB column(s).
Added the bitmap index function.
Added the "alter rmgr backup" and "alter rmgr restore" statements.
For more information, refer to Tibero SQL Reference Guide.
Static and Dynamic Views
The V$SYSSTAT and V$SESSTAT views now show statistics about physical and logical reads.
Added the CTIME column that shows the amount of time (in seconds) elapsed after requesting or getting wlock to the V$LOCK view.
The GV$WAITER_SESSION and GV$BLOCKER_SESSION views now show a lock that another node blocks or waits for as well as a lock that the current node does.
Added the interval column to [ALL | DBA | USER]_PART_TABLES.
Added the DEFAULT_LENGTH, CHAR_COL_DECL_LENGTH, and CHAR_LENGTH columns to [ALL | DBA | USER]_TBL_COLUMNS.
Added the DBA_UNDO_EXTENTS view that shows information about undo extents.
Added and modified columns to and in the V$UNDO_FREE_SPA view that shows free and reusable spaces in each UNDO tablespace.
Packages
The following procedures and functions have been added.
DBMS_XMLDOM
| Procedure/Function | Description |
|---|---|
| NEWDOMDOCUMENT | Creates a DOM document. |
| FREEDOCUMENT | Frees resources associated with the specified document. |
| CREATEELEMENT | Creates an element in the specified document. |
| CREATETEXTNODE | Creates a text node in the specified document. |
| GETXMLTYPE | Gets the XML document. |
| MAKENODE | Casts the specified document to a node. |
| APPENDCHILD | Adds a child node to the specified node and outputs the new child node. |
DBMS_XMLGEN
| Procedure/Function | Description |
|---|---|
| SETMAXROWS | Sets the maximum number of rows that can be processed by GETXML or GETXMLTYPE. |
| SETSKIPROWS | Sets the number of rows to skip in GETXML or GETXMLTYPE. |
| GETNUMROWSPROCESSED | Gets the number of rows processed by GETXML or GETXMLTYPE. |
| GETXMLTYPE | Creates an XMLType document from ctxHandle. |
For more information, refer to Tibero tbPSM Reference Guide.
The following functions have been added.
tbLoader
Added the SKIP_ERRORS option that specifies error codes that are not recorded in a bad file.
tbMigrator 2.0
Can migrate an MS SQL function for the timestamp column when migrating from MS SQL to Tibero.
tbExport
Added the REMAP_TABLESPACE parameter to remap tablespaces when performing an export if a tablespace used in a source server is different from that used in a target server.
Can export interval partition tables.
The following describes functions modified in Tibero 6 FixSet02.
The following functions have been improved.
Backup & Recovery
Increased media recovery performance in TAC by improving the logic to read archive log.
Binary Tip
Added the BTIP_PATH environment variable to allow a user to specify a binary tip path.
Records contents of a binary tip file loaded when a database start as trace log.
V$INSTANCE provides information about a binary tip file loaded when a database starts.
Parallel Execution
SO independently allocates and releases parallel execution slaves.
DDL
The "ALTER DATABASE RENAME ~" statement can be used only in the MOUNT mode.
Does not execute a trigger if a DDL statement is executed for the trigger.
Static and Dynamic Views
Modified the values in the STATUS column of V$SESSION.
| Column | Description |
|---|---|
| READY | The session is connected. |
| SESS_CLEANUP | The session resources are being cleaned up. |
| ASSIGNED | The session has an assigned thread, but is not ready yet. |
| ASSIGNED_FOR_PE | The session has an assigned thread for the parallel execution, but is not ready yet. |
| CLOSING | The session is being closed. |
The following functions have been improved.
tbMigrator 2.0
TIME WITH TIME ZONE data of PostgreSQL is migrated to TIME data in Tibero.
TIMESTAMP WITH TIME ZONE data's TIME ZONE of PostgreSQL is migrated to UTC in Tibero.
REAL, FLOAT, and DOUBLE data is migrated to BINARY_DOUBLE or BINARY_FLOAT data.
tbExport
Messages except for DDL statements are commented out in order to immediately export executable queries.
Column comments for materialized views can be migrated.
tbImport
Messages except for DDL statements are commented out in order to immediately import executable queries.
Column comments for materialized views can be migrated.
Skipped objects are not displayed in a console, and they are recorded only in the debug log.