Re: ORA-1555 on data dictionary query

Hi,

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


Ste

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?
>
>


-- 
http://www.stefanocislaghi.eu

Other related posts: