Re: ORA-1555 on data dictionary query

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: paul.baumgartel@xxxxxxx
  • Date: Fri, 15 Oct 2010 07:00:22 +0200


quite strange... perhaps any dictionary managed tablespace?!


On 14 October 2010 17:43, <paul.baumgartel@xxxxxxx> wrote:

>  A developer came to me with an error message the other day--(Oracle 11gR2
> on Solaris)
> ORA-01555: snapshot too old: rollback segment number 16 with name
> "_SYSSMU16_3927122202$" too small
> The error was recorded in Grid Control, with the ID of the SQL that caused
> it.  To my surprise it was a query on ALL_IND_PARTITIONS.  I would have
> expected a query on the data dictionary to look for consistent-read blocks
> in the SYSTEM tablespace, as create/drop/alter index DDL would create undo
> there.  Am I wrong?  Has this changed in 11g?


Other related posts: