Gathering Table Stats [message #649133] |
Mon, 14 March 2016 12:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/7202559ce9392961706cfdbdb1324ac2?s=64&d=mm&r=g) |
abhayman
Messages: 37 Registered: August 2011 Location: CA
|
Member |
|
|
Hi,
Is there any issue if we gather table stats while write is still on the table or table has to be in read only mode (Locked) while we are doing so ?
Regards
|
|
|
|
|
|
Re: Gathering Table Stats [message #649147 is a reply to message #649133] |
Tue, 15 March 2016 02:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
abhayman wrote on Mon, 14 March 2016 17:49Hi,
Is there any issue if we gather table stats while write is still on the table or table has to be in read only mode (Locked) while we are doing so ?
Regards No, there not any issue. Gathering statistics doesn't lock anythng.
|
|
|