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 220.127.116.11 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.