It depends.
For instance, 'analyze index validate structure' takes out
'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze
index compute/estimate statistics' does not.
For more info see 'Practical Oracle 8i' by Jonathan Lewis -
very good book.
|
- Analyze table and locking Robertson Lee - lerobe
- RE: Analyze table and locking Vadim Gorbounov
- RE: Analyze table and locking Shevtsov, Eduard
- RE: Analyze table and locking Robertson Lee - lerobe
- RE: Analyze table and locking Rajaram
- RE: Analyze table and locking Igor Neyman
- RE: Analyze table and locking Riyaj_Shamsudeen
- Re: Analyze table and locking Raghu Kota
- RE: Analyze table and locking Vadim Gorbounov
- RE: Analyze table and locking Robertson Lee - lerobe
- Re: Analyze table and locking Jeremiah Wilton
- RE: Analyze table and locking PD Miller
- RE: Analyze table and locking Christopher Spence
- RE: Analyze table and locking Christopher Spence
- RE: Analyze table and locking Christopher Spence
- RE: Analyze table and locking Rajaram