Originally posted by ORA-1578
hmmm...,if I remember correctly, there used to be a locking issue when selecting from and analyzing the same object!

what type of analyze? I suspect in your application that you are using RBO, so what are you analyzing for? estimate stats and gathering stats in general are for CBO!
if you are validating structure, then that is a (no no) if the business users are accessing the table!! since this will lock the object and all its dependencies (if cascade) is used for the duration of the analyze.
Have you noticed anyone complaining about performance when whatever analyze you are doing is performed?
but I like the dead locking issue better, however, if memory serves. this was fixed in 7.3.4 and you are on 7.3.4. So I am back to you locking the table. Any error messages, deadlock errors?
________________________________________________________________
ORA-1578
A nipple is the only intuitive interface, everything else needs a manual
What has analyze takes long time to do with locking...? Anyone said validating structure? Anyone said dead lock?