Home » RDBMS Server » Server Administration » Gathering Table Stats (Oracle 11i)
Gathering Table Stats [message #649133] Mon, 14 March 2016 12:49 Go to next message
abhayman
Messages: 29
Registered: August 2011
Location: CA
Junior 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 #649134 is a reply to message #649133] Mon, 14 March 2016 12:55 Go to previous messageGo to next message
BlackSwan
Messages: 26191
Registered: January 2009
Location: SoCal
Senior Member
abhayman wrote on Mon, 14 March 2016 10:49
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


since V10 the default behavior is for job to run once every 24 hours to collect statistics; as needed.

post SQL & results that show why you believe running statistics manually is necessary.

BTW - an "old" date in LAST_ANALYZED does not mean that statistics are not current & valid.
Re: Gathering Table Stats [message #649135 is a reply to message #649134] Mon, 14 March 2016 13:00 Go to previous messageGo to next message
abhayman
Messages: 29
Registered: August 2011
Location: CA
Junior Member
We are having some performance issue and DBA has suggested as gather the stats on the table . So, wanted to confirm on same.
Re: Gathering Table Stats [message #649137 is a reply to message #649135] Mon, 14 March 2016 13:03 Go to previous messageGo to next message
BlackSwan
Messages: 26191
Registered: January 2009
Location: SoCal
Senior Member
abhayman wrote on Mon, 14 March 2016 11:00
We are having some performance issue and DBA has suggested as gather the stats on the table . So, wanted to confirm on same.


post SQL & EXPLAIN PLAN to see details that might indicate source of performance issue
Re: Gathering Table Stats [message #649147 is a reply to message #649133] Tue, 15 March 2016 02:12 Go to previous message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
abhayman wrote on Mon, 14 March 2016 17:49
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
No, there not any issue. Gathering statistics doesn't lock anythng.
Previous Topic: Useful Tablespace Usage
Next Topic: Number of instance with oracle license
Goto Forum:
  


Current Time: Wed Oct 17 12:14:56 CDT 2018