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