OraFAQ Forum: Server Administration » histograms in dbms_stats.gather_table

Home » RDBMS Server » Server Administration » histograms in dbms_stats.gather_table_stats (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)

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

histograms in dbms_stats.gather_table_stats [message #681677]

Fri, 14 August 2020 17:16

wtolentino
Messages: 328
Registered: March 2005

Senior Member

usually i use the default when i am using the dbms_stats.gather_table_stats package to collect the statistics.

for example:

 execute dbms_stats.gather_table_stats('HR','EMPLOYEE');

then i was been asked this question "does using a default on dbms_stats.gather_table_stats creates a histogram and if so how?".

how does dbms_stats.gather_table_stats creates a histogram?

thank you,
warren

Report message to a moderator

Re: histograms in dbms_stats.gather_table_stats [message #681678 is a reply to message #681677]

Fri, 14 August 2020 23:25

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

does using a default on dbms_stats.gather_table_stats creates a histogram and if so how?".

It depends on your default gathering method (as you specified none):

SQL> select dbms_stats.get_param('METHOD_OPT') from dual;
DBMS_STATS.GET_PARAM('METHOD_OPT')
---------------------------------------------------------
FOR ALL COLUMNS SIZE AUTO

Quote:

how does dbms_stats.gather_table_stats creates a histogram?

Doc: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_STATS.html#GUID-CA6A56B9-0540-45E9-B1D7-D78769B7714C

[Updated on: Fri, 14 August 2020 23:25]

Report message to a moderator

Previous Topic:	no listener
Next Topic:	UPDATE taking a long time, indication disappeared

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 20:34:33 CST 2021