Skip to Main Content
Forums

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!

library cache lock event occuring

534640Jan 31 2008 — edited Feb 2 2008
Hi all,
We are using oracle database 10.2.0.3 on AIX 5.3
I am facing library cache lock event while creating a index on a partitioned table having size 10G.
All other processes are running fine and there is no problem with other objects. DML operations are fine.
I have killed the sessions once and tried to run the create index statement again but again after some time the same event is occuring.
Can any one help me to resolve this problem.

Index Statement:
=====================
CREATE INDEX odsprerevusgcube_dwdatekey_idx ON dev.ods_pre_rev_usg_cube_msisdn
(dw_date_key) LOCAL
NOLOGGING
TABLESPACE ods_indexes
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64 k
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
PARALLEL (DEGREE 16)

This statement was executed yesterday in 10 min and today its giving me errors. I have tried creating global and local indexes on this table and still same lib cache lock event in occuring.
Any idea experts????
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2008
Added on Jan 31 2008
#general-database-discussions
6 comments
5,283 views