OraFAQ Forum: Performance Tuning » gather stats estimated

Home » RDBMS Server » Performance Tuning » gather stats estimated

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

gather stats estimated [message #340111]

Mon, 11 August 2008 08:44

ArvindBhope
Messages: 55
Registered: June 2008

Member

Guys,

The following stmt has been fired Can we crosscheck the estimate_percent with what it was analyzed ?

EXEC DBMS_STATS.gather_schema_stats('ABCXYZ', estimate_percent => 33);

thanks,
AB

Report message to a moderator

Re: gather stats estimated [message #340115 is a reply to message #340111]

Mon, 11 August 2008 08:52

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

user_tables.sample_size.

Regards
Michel

Report message to a moderator

Re: gather stats estimated [message #340119 is a reply to message #340111]

Mon, 11 August 2008 08:58

ArvindBhope
Messages: 55
Registered: June 2008

Member

Mike, Could you be more clear on that ? Appeciate that !!

thx,
AB

Report message to a moderator

Re: gather stats estimated [message #340133 is a reply to message #340119]

Mon, 11 August 2008 10:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is as clear as your question.
From doc, ALL_TABLES:

Quote:

SAMPLE_SIZE NUMBER Sample size used in analyzing this table

Regards
Michel

Report message to a moderator

Previous Topic:	shink blob column
Next Topic:	oracle instance log increased

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:59:36 CST 2024