11gR2 - Creating Histogram
edited May 19, 2011 11:02PM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 4 commentsAnswered
We have a 11g R2 2 node RAC database and the application has a table (TEST) with appx 2.6 million rows
one of the column of that table has the following distribution of values
S COUNT(*)
- ----------
P 2356510
O 39571
F 135407
E 146414
one of the queries goes after this column with a where clause that looks like below
WHERE (service0_.RESULT_STATUS='F' or service0_.RESULT_STATUS='O' or service0_.RESULT_STATUS='E')
this query is doing full table scans and we are thinking of creating a histogram on this column to help the OPTIMIZER
Could someone please guide us (an exact syntax would be really appreciated) as to what type of histogram and with how many buckets to create the histogram with that would help the query
0