OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » truncate (oracle 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

truncate [message #278661]

Mon, 05 November 2007 05:42

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: truncate [message #279127 is a reply to message #278706]

Wed, 07 November 2007 01:20

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

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