DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oerr ora-1555

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    oerr ora-1555

    Iam getting below error . database is 9.2.0.3 running on bundo_management =manual

    ORA-01555 caused by SQL statement below (SCN:
    prdmon|0x02f1.9907a7f6): 2004 04 06 03:49:52|ORA-01555 caused by SQL
    prdmon|statement below (SCN: 0x02f1.9907b232): 2004 04 06
    prdmon|03:58:46|ORA-01555 caused by SQL statement below (SCN:
    prdmon|0x02f1.9907beb8): 2004 04 06 04:01:09|ORA-01555 caused by SQL
    prdmon|statement below (SCN: 0x02f1.9907c902):



    Below is my rollback segment details
    SQL> select SEGMENT_NAME,TABLESPACE_NAME,INITIAL_EXTENT,MIN_EXTENTS,MAX_EXTENTS,
    STATUS from dba_rollback_segs;

    SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
    ------------------------------ ------------------------------ --------------
    MIN_EXTENTS MAX_EXTENTS STATUS
    ----------- ----------- ----------------
    SYSTEM SYSTEM 57344
    2 505 ONLINE

    R01 ROLLBACK 1048576
    2 99 ONLINE

    R02 ROLLBACK 1048576
    2 99 ONLINE


    SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
    ------------------------------ ------------------------------ --------------
    MIN_EXTENTS MAX_EXTENTS STATUS
    ----------- ----------- ----------------
    R03 ROLLBACK 1048576
    2 99 ONLINE
    SQL> select usn,extents,rssize,optsize,hwmsize from v$rollstat;

    USN EXTENTS RSSIZE OPTSIZE HWMSIZE
    ---------- ---------- ---------- ---------- ----------
    0 37 3022848 3022848
    2 2 2121728 2097152 8511488
    3 2 2121728 2097152 3186688
    4 2 2121728 2097152 7446528
    J Gangadhar

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why arent you using undo tablespaces? are your rollback segments sized big enough for that job.

    IS your code crap (i.e. commiting in the loop you are selecting from )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width