Analyze table locking
We have a table with about 90 million rows. We do many inserts and updates, a few per second at peak.
Every night we run analyze on the table and it locks it for almost a minute which causes all sorts of issues in our application. I understand this is the intended behavior, locking the table when running the command, but is there a better way to accomplish what we are looking for?
Rebuild the indexes/statistics without locking the table.
Thanks.
Subject
Views
Written By
Posted
Analyze table locking
5070
March 24, 2010 12:54PM
2288
March 25, 2010 03:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.