Re: ORA-01555

From: ddf <oratune_at_msn.com>
Date: Wed, 13 Oct 2010 15:37:09 -0700 (PDT)
Message-ID: <11439d69-7ed6-42d8-963f-c0ba0039c071_at_d17g2000yqm.googlegroups.com>

On Oct 13, 6:26 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Wed, 13 Oct 2010 21:18:37 +0000, Mladen Gogala wrote:
> > BTW, I am re-running now with the entire tablespace being turned to read
> > only. If I get ORA-01555, I will start drinking.
>
> DB is 64bit oracle 10.2.0.5 on RH Linux 5.5
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
> PL/SQL Release 10.2.0.5.0 - Production
> CORE    10.2.0.5.0      Production
> TNS for Linux: Version 10.2.0.5.0 - Production
> NLSRTL Version 10.2.0.5.0 - Production
>
> Elapsed: 00:00:00.11
>
> --http://mgogala.byethost5.com

Have you considered the possibility of delayed block cleanout?

David Fitzjarrell Received on Wed Oct 13 2010 - 17:37:09 CDT