Re: Histogram ENDPOINT_ACTUAL_VALUE empty using DBMS_STATS
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 03 Sep 2004 03:34:11 -0600
I don't get ENDPOINT_ACTUAL_VALUEs with either gather_table_stats or
analyze on Oracle 9.2.0.4 (or 8.1.7.4) on W2K. Can't test on Linux at the
moment. Maybe it's an XP thing.
At 06:19 PM 9/2/2004, you wrote:
>I was doing some histogram testing and came across something I couldn't
>explain nor could I find anything on Metalink about it and was hoping
>someone could assist.
>
>Here are the specifics:
>9.2.0.4 on Windows XP
>table with 1 million rows
>county column (varchar2(30)) has 11 distinct values
>data values in the column are distributed as follows:
>COUNTY COUNT(*)
>-------------------- ----------
>ANDERSON 50000
>BROWN 25000
>CANNON 25000
>DAVIDSON 50000
>FAYETTE 50000
>GORDON 25000
>HARRISON 25000
>LANCOME 25000
>MULTNOMAH 25000
>SMITH 100000
>WASHINGTON 600000
>
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
