Home » SQL & PL/SQL » SQL & PL/SQL » Shrink space (Oracle 11g/12c)
Shrink space [message #659127] Fri, 06 January 2017 10:01 Go to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Hello,

I am planning to reclaim unused space and executing below shrink command for the same. But it is never ending from past one hour.
Please advise if there is any other option for the same.

alter table MRC_Bkp enable row movement;
alter table MRC_Bkp shrink space;

The table is 30 GB size and has around 200 million records. Please advise what is the best method.

I have also given parallel enable but no improvement in shrink command execution.

Alter session enable parallel ddl;
Alter table MRC_Bkp parallel (degree 16);

Regards,
SRK

[Updated on: Fri, 06 January 2017 10:07]

Report message to a moderator

Re: Shrink space [message #659128 is a reply to message #659127] Fri, 06 January 2017 10:03 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Perhaps it simply needs a long time. You can interrupt it, when you run it again it will pickup from where it left off.
Re: Shrink space [message #659129 is a reply to message #659128] Fri, 06 January 2017 10:05 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
One other possibility - it will hang at the end if there is an active transaction. You may need to cancel the operation and try again.
Re: Shrink space [message #659130 is a reply to message #659129] Fri, 06 January 2017 10:10 Go to previous message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Thanks. I will try to interrupt it and run again.

As of now, there is no active transactions on the table. Also, we are performing this on DB downtime. Hence no other big transactions/jobs are running.
Previous Topic: email validation
Next Topic: How to Move fast the data from one database to another database ?
Goto Forum:
  


Current Time: Fri Mar 29 00:07:54 CDT 2024