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: 65088
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: Wed Jul 26 02:11:28 CDT 2017

Total time taken to generate the page: 0.11016 seconds