On 05/23/2006 10:02:34 PM, fairlie rego wrote: > Hi, > > From the information you have provided it appears to be bug 2252824 > but I might be able to confirm if you send me the trace file. > Set _enable_type_dep_selectivity to true and see if it helps. > > Regards, > Fairlie Fairlie, I know you hare experienced guy and I'm already used to your magic, but I need a bit of explanation for this. For the bug you listed Metalink says the following: Click here for details of sections in this note. Bug 2252824 ANALYZE TABLE with COLUMN STATISTICS may OERI:16515 or not collect statistics This note gives a brief overview of bug 2252824. Affects: Product (Component) Oracle Server (RDBMS) Range of versions believed to be affected Versions < 10G Versions confirmed as being affected * 8.1.7.4 * 9.0.1.3 * 9.2.0.1 Platforms affected Generic (all / most platforms affected) Fixed: This issue is fixed in * 9.0.1.4 (Server Patch Set) * 9.2.0.2 (Server Patch Set) * 10G Production Base Release Symptoms: * Internal Error may occur (ORA-600) * ORA-600 [16515] Related To: * Optimizer Description Analyzing a table already having column statistics can signal an ORA-600 [16515] or silently generate no statistics Workaround: Delete previous statistics and run analyze again. What is the parameter you mention and why do you think it might help? -- Mladen Gogala http://www.mgogala.com -- //www.freelists.org/webpage/oracle-l