Home » RDBMS Server » Performance Tuning » Histogram Issue (oracle 9.2.0.6)
Histogram Issue [message #424734] Mon, 05 October 2009 12:58 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
I tried to create a histogram with the below command.

exec DBMS_STATS.GATHER_TABLE_STATS (ownname =>'SA',tabname =>'TABLE_ACT_ENTRY',method_opt => 'FOR COLUMNS SIZE 5 ACT_ENTRY2DOC_INST');

The above command gets executed sucessfully however the below command does show no bucket is created .
I have executed the above command twice however the same results. The datatype for the column ACT_ENTRY2DOC_INST is number.

SQL> SELECT COLUMN_NAME, NUM_BUCKETS FROM DBA_TAB_COLUMNS WHERE
2 OWNER = 'SA' AND TABLE_NAME = 'TABLE_ACT_ENTRY'
3 AND NUM_BUCKETS > 1;

no rows selected

There are no background analyze command or any relevant jobs getting executed.

Kindly help .

Regards


Re: Histogram Issue [message #424736 is a reply to message #424734] Mon, 05 October 2009 13:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post NUM_DISTINCT, NUM_NULLS, DENSITY, LOW_VALUE and HIGH_VALUE as well and remove condition on NUM_BUCKETS.

Regards
Michel

[Updated on: Mon, 05 October 2009 13:05]

Report message to a moderator

Re: Histogram Issue [message #424737 is a reply to message #424736] Mon, 05 October 2009 13:08 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Thanks Micheal

I have checked the Num_Bucket column its value is 1 for all the columns of that table.


Is there any other way to check the number of buckets created for that column?

Thanks in advance
Re: Histogram Issue [message #424739 is a reply to message #424737] Mon, 05 October 2009 13:23 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post what I asked.

regards
Michel
Previous Topic: hard parse for SQL (merged)
Next Topic: Pctfree
Goto Forum:
  


Current Time: Sun Dec 04 22:46:44 CST 2016

Total time taken to generate the page: 0.18108 seconds