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!

LIBRARY CACHE LOCK

187628Jun 3 2005 — edited Jun 6 2005
I´m trying ANALYZE a table and the event LIBRARY CACHE LOCK increase forever and the command don´t finish.
A had analyzed all tables and indexes of database but , i can´t do this just with one table. A had run ANALYZE VALIDATE STRUCTURE on that table and the command run successfully without errors. I had made an EXPORT of that table too, and don´t have any problem with that.


Any help???

Tks,

Paulo Portugal.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2005
Added on Jun 3 2005
4 comments
534 views