-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|