Home » RDBMS Server » Performance Tuning » truncate (oracle 7)
truncate [message #278661] Mon, 05 November 2007 05:42 Go to next message
dirish
Messages: 232
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

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
To 1, the initial extent always exists.

Regards
Michel

Report message to a moderator

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: 232
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.

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
TRUNCATE TABLE table_name DROP STORAGE should release the additional extents.
Ross Leishman

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DROP STORAGE is the default option.

Regards
Michel

Report message to a moderator

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: 232
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

Report message to a moderator

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: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Yes

Report message to a moderator

Re: truncate [message #279948 is a reply to message #279940] Mon, 12 November 2007 00:58 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 13 00:36:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.