OraFAQ Forum: Performance Tuning » different between move and shink table

Home » RDBMS Server » Performance Tuning » different between move and shink table (11g windows)

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

different between move and shink table [message #517060]

Fri, 22 July 2011 03:41

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
What is different between move table and shrink table?

Report message to a moderator

Re: different between move and shink table [message #517063 is a reply to message #517060]

Fri, 22 July 2011 03:51

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

Senior Member
Account Moderator

MOVE moves, SHRINK shrinks.

Database SQL Reference

Regards
Michel

Report message to a moderator

Re: different between move and shink table [message #521449 is a reply to message #517060]

Tue, 30 August 2011 01:27

jai_subi
Messages: 7
Registered: May 2007
Location: Chennai

Junior Member

Empty_blocks do not change after alter table move clause whereas empty_blocks decrease after shrink clause.

The below query helps you to verify:

select table_name,a.blocks,b.bytes/1024 as KB,num_rows,empty_blocks
from user_tables a, user_segments b
where a.table_name = b.segment_name
and empty_blocks >0 order by empty_blocks desc

Regards,
subi

Report message to a moderator

Previous Topic:	harsh area size and sort area size
Next Topic:	Importing Partitioning rows from Many Export Files.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 21:30:28 CDT 2024