While exchanging the partition, I am observing significant wait on "Library Cache lock". Is it a bug? is anyone there who experienced the same issue?


Database release 10.2.0.3

ALTER TABLE PSALESREG EXCHANGE PARTITION P123
WITH TABLE PBKPSALESREF WITHOUT VALIDATION


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.11 6684.73 2 9 2 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.11 6684.73 2 9 2 0

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
library cache lock 2274 3.12 6681.32


Rgds