Home » RDBMS Server » Performance Tuning » TEMP TABLESPACE (11G, WINDOWS)
TEMP TABLESPACE [message #445462] Tue, 02 March 2010 00:08 Go to next message
Messages: 95
Registered: May 2006
Location: KOLKATA
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 Go to previous message
Michel Cadot
Messages: 64948
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: ora-1652
Next Topic: Should an index be rebuilt or recreated during data load.
Goto Forum:

Current Time: Fri Jun 23 03:51:28 CDT 2017

Total time taken to generate the page: 0.09020 seconds