OraFAQ Forum: Server Administration » Gathering Table Stats

Home » RDBMS Server » Server Administration » Gathering Table Stats (Oracle 11i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Gathering Table Stats [message #649133]

Mon, 14 March 2016 12:49

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

Report message to a moderator

Re: Gathering Table Stats [message #649134 is a reply to message #649133]

Mon, 14 March 2016 12:55

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Gathering Table Stats [message #649135 is a reply to message #649134]

Mon, 14 March 2016 13:00

abhayman
Messages: 37
Registered: August 2011
Location: CA

Member

We are having some performance issue and DBA has suggested as gather the stats on the table . So, wanted to confirm on same.

Report message to a moderator

Re: Gathering Table Stats [message #649137 is a reply to message #649135]

Mon, 14 March 2016 13:03

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Gathering Table Stats [message #649147 is a reply to message #649133]

Tue, 15 March 2016 02:12

John Watson
Messages: 8960
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.

Report message to a moderator

Previous Topic:	Useful Tablespace Usage
Next Topic:	Number of instance with oracle license

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 06:22:33 CST 2024