And select the temporary tablespaces that belong the group

This feature has the following benefits: • Enables one particular user to use multiple temporary tablespaces in different sessions at the same time • Enables the slave processes in a single parallel operation to use multiple temporary tablespaces • Enables multiple default temporary tablespaces to be specified at the database level

Therefore, you can now define more than one default temporary tablespace, and a single SQL operation can use more than one temporary tablespace for sorting. This prevents large tablespace operations from running out of temporary space. This is especially relevant with the introduction of bigfile tablespaces.

Creating and Maintaining Temporary Tablespace Groups

Oracle Database 10g: Administration Workshop II G-16

Over 10 Million Study Resources Now at Your Fingertips