Home » RDBMS Server » Performance Tuning » gather stats estimated
gather stats estimated [message #340111] Mon, 11 August 2008 08:44 Go to next message
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
Re: gather stats estimated [message #340115 is a reply to message #340111] Mon, 11 August 2008 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user_tables.sample_size.

Regards
Michel
Re: gather stats estimated [message #340119 is a reply to message #340111] Mon, 11 August 2008 08:58 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Mike, Could you be more clear on that ? Appeciate that !!

thx,
AB
Re: gather stats estimated [message #340133 is a reply to message #340119] Mon, 11 August 2008 10:13 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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

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


Current Time: Sun Dec 04 02:24:55 CST 2016

Total time taken to generate the page: 0.08250 seconds