Re: dbms_stats result ora-600

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 23 May 2006 22:32:37 -0400
Message-Id: <1148437957l.5875l.0l@medo.noip.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 23 2006 - 21:32:37 CDT