Re: ORA 0600 on histgrm$ after computed statistics on database

From: claudio cutelli <c_cutelli_at_hotmail.com>
Date: Tue, 11 Dec 2001 10:15:17 -0800
Message-ID: <F001.003DA195.20011211100444@fatcity.com>

Hi, I think you should not analyze sys
schema.
 
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A href="mailto:ASAURY_at_recherche.loreal.com" title=ASAURY_at_recherche.loreal.com>SAURY Alain To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Tuesday, December 11, 2001 6:10 PM Subject: ORA 0600 on histgrm$ after computed statistics on database

  Hello,
  I keep getting numerous ORA 600 since I have   launched:
  dbms_utility.analyze_database <FONT
  face=Arial size=2>and <FONT face=Arial   size=2>dbms_stats.gather_database_stats   Has anybody run into this type of problem ?   

  PS: get ORA 600 on : <FONT face=Arial

  size=2>select /*+ rule */ bucket, endpoint, col#, epvalue <FONT 
  face=Arial size=2>from histgrm$ where 
  obj#=:1 and intcol#=:2 <FONT 
  face=Arial size=2>and row#=:3 order by 

  bucket
  Alain Saury <FONT
  color=#0000ff face=Arial size=2>L'Oréal - Informatique RAD Clichy   Tel: 147 56 84 29   

  This message and any attachments are confidential   and intended solely for the addressees. If you receive this message in error,   please delete it and immediately notify the sender. If the reader of this   message is not the intended recipient, you are hereby notified that any   unauthorized use, copying or dissemination is prohibited. E-mails are   susceptible to alteration. Neither L'OREAL nor any of its subsidiaries or   affiliates shall be liable for the message if altered, changed or   falsified. Received on Tue Dec 11 2001 - 12:15:17 CST