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: gather_stats_job died due to AUTO SGA error

Re: gather_stats_job died due to AUTO SGA error

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 11 Apr 2007 22:05:39 -0400
Message-ID: <9177895d0704111905k4f7e5019ge6834e6182b70958@mail.gmail.com> 





John,



you got the bug number handy? Since we create indexes with compute clause, I
just want to be careful. I haven't seen it yet, but a bug# would be great.



rjamya




On 4/11/07, John Darrah <darrah.john_at_gmail.com> wrote:

>




> There is a bug in 10.2.0.2 that presents as 4031 errors when rebuilding

> indexes with the compute statistics clause.  It causes state objects to be

> created in the shared pool that are never destroyed.



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


Received on Wed Apr 11 2007 - 21:05:39 CDT












Original text of this message













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