| TEMP TABLESPACE [message #445462] |
Tue, 02 March 2010 00:08  |
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
|
Member |
|
|
Just to clear my doubt. My temporary tablespace temp is of 40G and the HWM also shows 40G. At this moment free space is also 40G. Now if I ran a SQL statement that nees the temp for sorting
will the temp tablespace available. Bit confused for the HWM
|
|
|
|
| Re: TEMP TABLESPACE [message #445467 is a reply to message #445462] |
Tue, 02 March 2010 00:25  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Temporary tablespace are not used like other ones.
See Database Concepts
Chapter 2 Data Blocks, Extents, and Segments
Section Overview of Segments
Paragraph Introduction to Temporary Segments
Chapter 3 Tablespaces, Datafiles, and Control Files
Section Overview of Tablespaces
Paragraph Temporary Tablespaces for Sort Operations
Extents are created in tablespace by the instance when they are needed and they are NEVER feed until the end of the instance but they can be reallocated for other operations than the one that saw its creation.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
