Home » RDBMS Server » Server Administration » TEMP tablespace
TEMP tablespace [message #399266] Tue, 21 April 2009 06:32 Go to next message
zanric
Messages: 6
Registered: April 2009
Junior Member

The Temp tablespace is used to store temporary data.
When become empty? is it possibile to empty it?
Thanks in advance

Report message to a moderator

Re: TEMP tablespace [message #399269 is a reply to message #399266] Tue, 21 April 2009 06:36 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Quote:
When become empty? is it possibile to empty it?


If it is empty, why would you want to empty it?

Report message to a moderator

Re: TEMP tablespace [message #399273 is a reply to message #399266] Tue, 21 April 2009 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
is it possibile to empty it?

If you meant deallocate segments/extents, no.

Regards
Michel

Report message to a moderator

Re: TEMP tablespace [message #400797 is a reply to message #399266] Wed, 29 April 2009 11:31 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Michel,i belive it will freeup used EXTENTS.Cant it be called deallocate ? (Database level, not OS level)

select TABLESPACE_NAME, TOTAL_EXTENTS, TOTAL_BLOCKS, USED_EXTENTS, USED_BLOCKS, FREE_EXTENTS, FREE_BLOCKS from v$sort_segment
TABLESPACE_NAME                 TOTAL_EXTENTS TOTAL_BLOCKS USED_EXTENTS USED_BLOCKS FREE_EXTENTS FREE_BLOCKS
------------------------------- ------------- ------------ ------------ ----------- ------------ -----------
TEMP                                       19         2432            0           0           19        2432

Report message to a moderator

Re: TEMP tablespace [message #400799 is a reply to message #400797] Wed, 29 April 2009 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It logically frees the extents not physically in files then it has not to reallocate them if it needs it.

Regards
Michel

[Updated on: Wed, 29 April 2009 11:59]

Report message to a moderator

Re: TEMP tablespace [message #400819 is a reply to message #399266] Wed, 29 April 2009 14:25 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Yeah ,correct. Thanks!

Report message to a moderator

Previous Topic: XDB not working properly after Oracle Upgrade
Next Topic: Grant privilege
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 23:10:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.