Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table having hw contention

orausernDec 28 2010 — edited Dec 28 2010
Hi,

I have a table in Prod. which is having HW contention. There are live sessions currently that are inserting data into it.
SQL> select * from gv$lock where block=1;

   INST_ID ADDR             KADDR                   SID TY        ID1        ID2
---------- ---------------- ---------------- ---------- -- ---------- ----------
     LMODE    REQUEST      CTIME      BLOCK
---------- ---------- ---------- ----------
         1 00000001F73C1BA0 00000001G73B1MC0       5056 HW          7   29360283
         6          0          0          1
Now the table is not allowing to be altered manually to allocate any extent to it:
SQL>alter table EMP MOVE tablespace index1 ;
alter table EMP MOVE tablespace index1
            *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL>alter table emp allocate extent;
alter table emp allocate extent
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
In this scenario, what are the options available? How can we remove the HW lock and allocate required space to the table?
The table has 2 clob columns

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2011
Added on Dec 28 2010
11 comments
576 views