Why does Optimizer not pick up indexes?

[lgaorcl]

Our database versioin is 9.2.0.6.

What could we do with 'library cache lock'?
It seems that's the reason for our database slow down. What's the reason for 'library chache lock?

Thanks!