I am seeing a few of my tables constantly having analyze table running on them. How would I determine what would be causing or triggering this and is there a way for me to stop that from running? It seems to be affecting performance as there is a near constant library cache lock on the tables.

Oracle database.

Also note that we are using GoldenGate, but that does not seem to be related to this issue other than it is causing us to ignore these tables for now in our ODS environment because they are locked due to the analyze table function running constantly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.