Using ASM to Create a Database

It would be worthwhile to look at the new storage structures in Oracle Database 10g.

Now that ASM files have been explored in more detail, it would be appropriate to examine more information regarding temporary tablespace groups and BigFile Tablespaces. These topics are presented next.

New Tablespace Types

There are new storage structures in Oracle Database 10g. They are Temporary Tablespace Groups (TTG) and BigFile Tablespaces (BFT).

Temporary Tablespace Groups

A Temporary Tablespace Group (TTG) can be described as a group of temporary tablespaces. The dba_tablespace_groups view provides all the temporary tablespace group information.

TTGs have the following characteristics:

• A TTG contains at least one temporary tablespace.
   

• A TTG cannot have the same name as tablespace.
   

• A TTG name can be used instead of a temporary tablespace name. It is created implicitly when the first TEMPORARY tablespace is assigned. It is deleted when the last TEMPORARY tablespace is removed from the TTG.

The benefits of having TTG s are as follows: