Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
and select the temporary tablespaces that belong t

And select the temporary tablespaces that belong the group

Temporary Tablespace Group: Benefits

HR Serial HR




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.

G-16 Copyright © 2006, Oracle. All rights reserved.

Creating and Maintaining Temporary Tablespace Groups

Oracle Database 10g: Administration Workshop II G-16

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Ashlee Fields

PageId: ELIE7D89AC