Oracle Database Discussions

Hi All,

Last saturday one table of my database met problem it seems locked but when i was checking the lock objects it was not. We cannot do any operations to this table, when operating some query in the table, it's hanging. I was not to the office this time and becasue of the urgency of the problem, my friend has to restart the database and after restarting it was fine.
When coming to the office, after some checking, i fount in the user trace file a text bellow:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: ab-db1
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: abdb1
Redo thread mounted by this instance: 1
Oracle process number: 195
Unix process pid: 3891, image: oracle@ab-db1

*** 2008-05-17 16:45:29.213
*** SERVICE NAME:(abdb) 2008-05-17 16:45:29.118
*** SESSION ID:(283.57308) 2008-05-17 16:45:29.118
KGL recovered in-flux handle for lock c0000002092024b0
----------------------------------------
SO: c0000002092024b0, type: 53, owner: c00000021ad8a1d0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=c0000002092024b0 handle=c000000217c21970 request=S
call pin=0000000000000000 session pin=0000000000000000 hpc=0000 hlc=0000
htl=c000000209202530[c000000213613678,c000000213613678] htb=c000000213613678 ssga=c0000002136132a0
user=c00000023e8f3b30 session=c00000023e8f3b30 count=0 flags=[0000] savepoint=0x30cfb
LIBRARY OBJECT HANDLE: handle=c000000217c21970 mtx=c000000217c21aa0(0) cdp=0
name=ABILLITY.CB_COUPONS
hash=8886e5e6b19e4374a9c5bf512cc37f2c timestamp=04-28-2007 23:47:02
namespace=TABL flags=KGHP/TIM/XLR/[00000020]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=0 latch#=3 hpc=dce6 hlc=dce4
lwt=c000000217c21a18[c000000209b64c88,c0000002092024e0] ltm=c000000217c21a28[c000000217c21a28,c000000217c21a28]
pwt=c000000217c219e0[c000000217c219e0,c000000217c219e0] ptm=c000000217c219f0[c000000217c219f0,c000000217c219f0]
ref=c000000217c21a48[c000000217c21a48,c000000217c21a48] lnd=c000000217c21a60[c000000214d70860,c000000214fa3420]
LOCK INSTANCE LOCK: id=LB8886e5e6b19e4374
PIN INSTANCE LOCK: id=NB8886e5e6b19e4374 mode=S release=F flags=[00]
INVALIDATION INSTANCE LOCK: id=IV00014bff1c183003 mode=S
LIBRARY OBJECT last freed from HPD addn data CBK

It seems that the OBJECT LIBRARY of the table CB_COUPONS is locked.

My question is Why an object library is locked and how to solve or to avaoid this kind of problem.

Many thanks

raitsarevo