OraFAQ Forum: Performance Tuning » alter table.. shrink space command hanging..

Home » RDBMS Server » Performance Tuning » alter table.. shrink space command hanging.. (Sun OS, 10.2.0.3.0)

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

alter table.. shrink space command hanging.. [message #515866]

Wed, 13 July 2011 19:41

lg123
Messages: 225
Registered: August 2008

Senior Member

I gave 2 commands.

1) alter table xxxxxx.xxxxxx enable row movement;
table altered.

2) alter table xxxxx.xxxxx shrink space;

After the shrink space command, I dont see any error. The command is just hanging. I checked if its running in the background,its not. Please let me know why the shrink space command is hanging and how to resolve it?

Report message to a moderator

Re: alter table.. shrink space command hanging.. [message #515867 is a reply to message #515866]

Wed, 13 July 2011 19:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid,serial#,true);

do above or below

You could use realtime monitoring via

SELECT DBMS_SQLTUNE.REPORT_SQL_MONITOR('<sql_id>') FROM DUAL;

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Wed, 13 July 2011 19:55]

Report message to a moderator

Re: alter table.. shrink space command hanging.. [message #515893 is a reply to message #515866]

Thu, 14 July 2011 02:33

John Watson
Messages: 8979
Registered: January 2010
Location: Global Village

Senior Member

Hi - you say
Quote:

checked if its running in the background,its not

How did you do this check? The compaction phase of SHRINK SPACE can take a long time, are you sure it was not running?

Report message to a moderator

Previous Topic:	Wait Stats
Next Topic:	Query Optimization Help - Date-Range Matching results in MERGE JOIN CARTESIAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 09 03:27:59 CDT 2025