Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_stats result ora-600

Re: dbms_stats result ora-600

From: Ujang Jaenudin <ujang_jaenudin_at_yahoo.com.sg>
Date: Fri, 26 May 2006 08:20:47 +0700
Message-ID: <001b01c68062$a6f0b120$ad556e0a@jpcid.com>


hi fairle,

according to metalink advice, they said to apply patchset 9.2.0.7. but i know the latest is 9.2.0.8, do u know why ?

regards
--J

  Hi Malden,

  Since this is a published bug all you have to enter the bug number in the box   (Knowledge Base, Forum, or Bug ID) and click on bugs and you should be able to view the bug report.   The workaround is mentioned in the bug report.

  No magic...

  HTH,
  Fairlie

  Mladen Gogala <gogala_at_sbcglobal.net> wrote:

    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

    Platforms affected Generic (all / most platforms affected)

    Fixed:

    This issue is fixed in

    Symptoms:

    Related To:

    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

  Fairlie Rego
  Senior Oracle Consultant
  Optus Telecommunications
  www.optus.com.au



  Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone. Get Yahoo! Messenger with Voice

Send instant messages to your online friends http://asia.messenger.yahoo.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 25 2006 - 20:20:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US