Re: Analyze table locking
ANALYZE TABLE needs to lock the table, no real way around that. You may want to consider partitioning the table or breaking it up using the MERGE engine. Then you only need to analyze the "active" portion of the table, which should be much smaller. This is how I deal with a few large tables here, one has ~2.3 billion rows over all of the merged tables and it works fine.
Subject
Views
Written By
Posted
5070
March 24, 2010 12:54PM
Re: Analyze table locking
2287
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.