1) I have been steeped in a bunch of Incremental Stats blog posts for the past week and I think I am just confusing myself at this point. If I want to use Incremental stats on my Partitioned tables, I am under the impression I need to use AUTO_SAMPLE_SIZE. Is this accurate? Is it not possible to use a custom Sample Size in conjunction with Incremental Stats? Or is it possible but my synopses will be less accurate? 2) Reason I am asking is that I have a table that I can't get stats on... keeps erroring out so I am trying to figure out how I can get a successful stats run on it. I would like to try reducing the sample size by changing from Auto to a small percentage of the table size. This is a generic 11.1.0.7 (straight install with no patches) on Solaris 64-bit Table MYSCHEMA.MYTABLE has 42 partitions, 15 gb across all partitions, largest partition is 1.75gb, but most are in the 300mb range. I have 64gb temp space defined for this database, and no one else is logged on. I have the table stats preferences configured like this: EXEC DBMS_STATS.set_table_prefs('MYSCHEMA', 'MYTABLE', 'INCREMENTAL', 'TRUE'); EXEC DBMS_STATS.set_table_prefs('MYSCHEMA', 'MYTABLE', 'GRANULARITY', 'AUTO'); EXEC DBMS_STATS.set_table_prefs('MYSCHEMA', 'MYTABLE', 'ESTIMATE_PERCENT', DBMS_STATS.AUTO_SAMPLE_SIZE); And then execute the following: EXEC DBMS_STATS.gather_table_stats('MYSCHEMA', 'MYTABLE',DEGREE=>4); The stats gathering chugs along and after about 45 minutes it fails with: ERROR at line 1: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP ORA-06512: at "SYS.DBMS_STATS", line 18408 ORA-06512: at "SYS.DBMS_STATS", line 18429 ORA-06512: at line 1 I am still a newbie on stats for partitioned tables... Seems odds that a 15gb table requires so much (64gb) of temp while gathering. Not sure if I am hitting a bug. Metalink searches sent me on some wild goose chases. Any suggestions before I request a swath of disk space for more TEMP files appreciated as I have to get this worked out before I move on to the larger tables in this schema (50gb+). -Dave -- Dave Mann www.brainio.us www.ba6.us - Database Stuff - http://www.ba6.us/rss.xml -- //www.freelists.org/webpage/oracle-l