| Histogram Issue [message #424734] |
Mon, 05 October 2009 12:58  |
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 #424737 is a reply to message #424736] |
Mon, 05 October 2009 13:08  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
