Home » RDBMS Server » Performance Tuning » truncate (oracle 7)
truncate [message #278661] Mon, 05 November 2007 05:42 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi,

I have a table which has reached an extent of 194 (times) over 249 (times).

This table contains many records and I want to truncate the table.

If I truncate it, will the extent reached of 194 times drop to 0 time(s).



Thank you,
Dirish
Re: truncate [message #278671 is a reply to message #278661] Mon, 05 November 2007 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To 1, the initial extent always exists.

Regards
Michel
Re: truncate [message #278674 is a reply to message #278671] Mon, 05 November 2007 06:28 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
yea sure, the initial extent should exist, but first records should fill the initial extent to move on to the next extent.

Re: truncate [message #278706 is a reply to message #278674] Mon, 05 November 2007 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean "first records should fill the initial extent to move on to the next extent"?
After a truncate there is no more record.

Regards
Michel
Re: truncate [message #279127 is a reply to message #278706] Wed, 07 November 2007 01:20 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
TRUNCATE TABLE table_name DROP STORAGE should release the additional extents.

Ross Leishman
Re: truncate [message #279149 is a reply to message #279127] Wed, 07 November 2007 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DROP STORAGE is the default option.

Regards
Michel
Re: truncate [message #279940 is a reply to message #279149] Mon, 12 November 2007 00:45 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi All,

I did the test and in fact the extent reached fell to 0.

I have another issue.

I have a table in oracle 7 and want to increase the next extent. Is this possible?

Thx
Re: truncate [message #279943 is a reply to message #279940] Mon, 12 November 2007 00:51 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Yes
Re: truncate [message #279948 is a reply to message #279940] Mon, 12 November 2007 00:58 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I did the test and in fact the extent reached fell to 0.

This is wrong, post your evidence.

Regards
Michel
Previous Topic: Perfomance in Delete and Insert
Next Topic: BUFFER CACHE
Goto Forum:
  


Current Time: Sat Dec 10 20:29:48 CST 2016

Total time taken to generate the page: 0.07765 seconds