Search This Blog

Sunday, July 1, 2007

Oracle Database 10g(10.1) New Features

Oracle 10g(10.1) New Features

Bigfile tablespaces

Oracle Database lets you create single-file tablespaces, called bigfile tablespaces, which can contain up to 232 or 4G blocks. The benefits of bigfile tablespaces are the following:

They significantly enhance the storage capacity of an Oracle Database.

They reduce the number of datafiles needed for an ultra large database.

They simplify database management by providing datafile transparency.

Multiple default temporary tablespace support for SQL operations

You can create a temporary tablespace group that can be specifically assigned to users in the same way that a single temporary tablespace is assigned. A tablespace group can also be specified as the default temporary tablespace for the database.

Rename tablespace

The RENAME TO clause of the ALTER TABLESPACE statement enables you to rename tablespaces

Cross-platform transportable tablespaces

Tablespaces can be transported from one platform to another. The RMAN CONVERT command is used to do the conversion

SYSAUX tablespace

Oracle Database creates an auxiliary system tablespace called SYSAUX at database creation. This tablespace can be used by various Oracle Database features and products, rather than saving their data in separate tablespaces or in the SYSTEM tablespace.

Automatic Storage Management

Automatic Storage Management provides a logical volume manager integrated with Oracle Database, eliminating the need for you to purchase a third-party product. Oracle Database creates Oracle-managed files within user-defined disk groups that provide redundancy and striping.

Drop database

The new DROP DATABASE statement lets you delete a database and all of its files that are listed in the control file.

Oracle Flashback Transaction Query

This feature introduces the FLASHBACK_TRANSACTION_QUERY view, which lets you examine changes to the database at the transaction level. As a result, you can diagnose problems, perform analysis, and audit transactions.

Oracle Flashback Version Query

Using undo data stored in the database, you can now view multiple changes to one or more rows, along with the metadata for the changes.

Oracle Flashback Table

A new FLASHBACK TABLE statement lets you quickly recover a table to a point in time in the past without restoring a backup

Oracle Flashback Drop

Oracle Database now provides a way to restore accidentally dropped tables. When tables are dropped, they are placed into a recycle bin from which they can later be recovered.

Enhanced online redefinition

New procedures have been added to the DBMS_REDEFINITION package that automate the cloning of dependent objects such as indexes, triggers, privileges, and constraints. Some restrictions have been lifted, allowing more types of tables to be redefined.

Automatic statistics collection

You no longer need to specify the MONITORING keyword in the CREATE TABLE or ALTER TABLE statement to enable the automatic collecting of statistics for a table. Statistics are now collected automatically as controlled by the STATISTICS_LEVEL initialization parameter. Automatic statistics collection is the default.


Oracle Database provides advanced scheduling capabilities through the database Scheduler.

Simplified recovery through resetlogs

The format for archive log file naming, as specified by the ARCHIVE_LOG_FORMAT initialization parameter, now includes the resetlogs ID, which allows for easier recovery of a database from a previous backup.

Automated shared server configuration and simplified shared server configuration parameters.

You no longer need to preconfigure initialization parameters for shared server. Parameters can be configured dynamically, and most parameters are now limiting parameters to control resources. The recommended method for enabling shared server now is by setting SHARED_SERVERS initialization parameter, rather than the DISPATCHERS initialization parameter.

Consolidation of session-specific trace output

For shared server sessions, the trcsess command-line utility consolidates in one place the trace pertaining to a user session.

Block remote access to restricted instances

Remote access to a restricted instance through an Oracle Net listener is blocked.

Dynamic SGA enhancements

The JAVA_POOL_SIZE initialization parameter is now dynamic. There is a new STREAMS_POOL_SIZE initialization parameter, which is also dynamic. A new view, V$SGAINFO, provides a consolidated and concise summary of SGA information.

Irreversible database compatibility

In previous releases you were allowed to lower the compatibility setting for your database. Now, when you advance the compatibility of the database with the COMPATIBLE initialization parameter, you can no longer start the database using a lower compatibility setting, except by doing a point-in-time recovery to a time before the compatibility was advanced.

Flash recovery area

You can create a flash recovery area in your database where Oracle Database can store and manage files related to backup and recovery

Copying Files Using the Database Server

You do not have to use the operating system to copy database files. You can use the DBMS_FILE_TRANSFER package to copy files.

Deprecation of MAXTRANS physical attribute parameter

The MAXTRANS physical attribute parameter for database objects has been deprecated. Oracle Database now automatically allows up to 255 concurrent update transactions for any data block, depending on the available space in the block.

Deprecation of use of rollback segments (manual undo management mode)

Manual undo management mode has been deprecated and is no longer documented in this book. Use an undo tablespace and automatic undo management instead.

Deprecation of the UNDO_SUPPRESS_ERRORS initialization parameter

When operating in automatic undo management mode, the database now ignores any manual undo management mode SQL statements instead of returning error messages.

Deprecation of the PARALLEL_AUTOMATIC_TUNING initialization parameter

Oracle Database provides defaults for the parallel execution initialization parameters that are adequate and tuned for most situations. The PARALLEL_AUTOMATIC_TUNING initialization parameter is now redundant and has been deprecated.

No comments: