Home » Other » General » Rollback segment error
Rollback segment error [message #102705] |
Wed, 04 September 2002 23:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Nova Bhojwani
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
I am getting the following error.....please anyone tell me the solution....
/* Error at Line #3896 S1000: [[Oracle]][[ODBC]][[Ora]]ORA-01562: failed to extend rollback segment number 4
ORA-01628: max # extents (121) reached for rollback segment PER1ROLLBACK
*/
|
|
|
Re: Rollback segment error [message #102717 is a reply to message #102705] |
Mon, 09 September 2002 01:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
bhuvan
Messages: 9 Registered: January 2002
|
Junior Member |
|
|
Hi,
One possible cause is that you are doing a large transaction that it cannot be fit into the rollback segment.
And when the segment tries to extend itself to accommodate the transaction, it fails. May be because the autoextend is OFF or a max size is specified for the rollback segment.
Solutions
1. Try to reduce the size of data added/deleted in one transaction.
2. Try to increase the size of the rollback segment
3. Try to set autoextend parameter to ON so that it can extend itself.
4. Specify a higher MAXSIZE parameter and give more physical storage space for it.
HTH,
bhuvan.
|
|
|
Re: Rollback segment error [message #103247 is a reply to message #102705] |
Thu, 20 March 2003 23:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
smaranika Mishra
Messages: 1 Registered: March 2003
|
Junior Member |
|
|
Hi,
We require your help on Oracle Rollback segments. We have 10 rollback segments. R1, R2,.....,R10. Detailed of these segments are available in the
rbs_info.log file and datafile information is available in datafiles_info.log given below.
Out of 10 segments, two segments (R7 and R10) are misbehaving. Their sizes are not extending. They have already reached at their maximum extents.
What will be the cause. This is happening specifically in one machine. We are using Oracle 7.3 on Solaris 2.5.
Due to the above problem we are getting following error.
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 6
ORA-01628: max # extents (121) reached for rollback segment R7
Please help us.
Expecting the best from you.
Regards,
-Smaranika
<rbs_info.log >
************************************************************************
* Rollback Info and Statisitics
************************************************************************
Segment Owner Tablespace Ini (K) Next (K) Min Max
--------------- ---------- ---------- -------- -------- ----- -----
Status RSize (K) Extents ActTR OptSize (K) HWM (K) Shrinks Wraps
------- --------- ------- ----- ----------- -------- -------- --------
R1 SYS ROLLBACKSE 1,024 1,024 2 121
GEMENTS
ONLINE 20,598 20 0 20,480 39,138 4 409
R10 SYS CONFIG 10 1,024 2 121
ONLINE 498 121 0 20,480 498 0 78,922
R2 SYS ROLLBACKSE 1,024 4 2 121
GEMENTS
ONLINE 9,716 121 0 20,480 9,716 0 4,472
R3 SYS SYSTEM 10 1,024 2 121
ONLINE 20,608 21 0 20,480 31,938 2 422
R4 SYS SYSTEM 10 1,024 2 121
ONLINE 20,608 21 0 20,480 20,608 0 395
R5 SYS ROLLBACKSE 10 1,024 2 121
GEMENTS
ONLINE 20,608 21 0 20,480 35,028 6 475
R6 SYS ROLLBACKSE 10 1,024 2 121
GEMENTS
ONLINE 20,608 21 0 20,480 35,028 2 361
R7 SYS DATA 10 1,024 2 121
ONLINE 520 121 0 20,480 520 0 75,997
R8 SYS DATA 10 1,024 2 121
ONLINE 20,608 21 0 20,480 35,028 2 454
R9 SYS CONFIG 10 1,024 2 121
ONLINE 20,608 21 0 20,480 35,028 2 447
SYSTEM SYS SYSTEM 50 50 2 121
ONLINE 748 15 0 748 0 0
R0 SYS SYSTEM 16 16 2 20
OFFLINE
************************************************************************
Legend:
************************************************************************
Segment ...... segment name
Owner ........ owner
Tablespace ... tablespace
Ini (K) ...... size of initial extent in K
Next (K) ..... size of the next extent in K
Min .......... minimum number of extents
Max .......... maximum number of extents
Status ....... status
RSize (K) .... size of rollback segments in K
Extents ...... number of extents in rollback segment
ActTR ........ number of active transactions
OptSize (K) .. optimal size of rollback segment
HWM (K) ...... high water mark of rollback segment size
Shrinks ...... number of shrinks
Wraps ........ number of wraps
<datafiles_info.log>
FILE# STATUS ENABLED CHECKPOINT_CHANGE# BYTES CREATE_BYTES
---------- ------- ---------- ------------------ ---------- ------------
NAME
--------------------------------------------------------------------------------
1 SYSTEM READ WRITE 148943459 157286400 157286400
/opt/oracle/NMS/data/thuraya/datafiles/system01.dbf
2 ONLINE READ WRITE 148943459 41943040 41943040
/opt/oracle/NMS/data/thuraya/rollbackseg/rollbackseg01.dbf
3 ONLINE READ WRITE 148943459 41943040 41943040
/opt/oracle/NMS/data/thuraya/rollbackseg/rollbackseg02.dbf
4 ONLINE READ WRITE 148943459 41943040 41943040
/opt/oracle/NMS/data/thuraya/rollbackseg/rollbackseg03.dbf
5 ONLINE READ WRITE 148943459 2146435072 1048576
/opt/oracle/NMS/data/thuraya/datafiles/data01.dbf
6 ONLINE READ WRITE 148943459 1048576 1048576
/opt/oracle/NMS/data/thuraya/datafiles/dataindexes01.dbf
7 ONLINE READ WRITE 148943459 1048576 1048576
FILE# STATUS ENABLED CHECKPOINT_CHANGE# BYTES CREATE_BYTES
---------- ------- ---------- ------------------ ---------- ------------
NAME
--------------------------------------------------------------------------------
/opt/oracle/NMS/data/thuraya/datafiles/logs01.dbf
8 ONLINE READ WRITE 148943459 1048576 1048576
/opt/oracle/NMS/data/thuraya/datafiles/logindexes01.dbf
9 ONLINE READ WRITE 148943459 104857600 1048576
/opt/oracle/NMS/data/thuraya/datafiles/temp01.dbf
10 ONLINE READ WRITE 148943459 1048576 1048576
/opt/oracle/NMS/data/thuraya/datafiles/tools01.dbf
11 ONLINE READ WRITE 148943459 104857600 5242880
/opt/oracle/NMS/data/thuraya/datafiles/config01.dbf
12 ONLINE READ WRITE 148943459 8388608 8388608
/opt/oracle/NMS/data/thuraya/datafiles/stats01.dbf
13 ONLINE READ WRITE 148943459 7340032 7340032
/opt/oracle/NMS/data/thuraya/datafiles/events01.dbf
FILE# STATUS ENABLED CHECKPOINT_CHANGE# BYTES CREATE_BYTES
---------- ------- ---------- ------------------ ---------- ------------
NAME
--------------------------------------------------------------------------------
14 ONLINE READ WRITE 148943459 52428800 52428800
/opt/oracle/NMS/data/thuraya/datafiles/data02.dbf
15 ONLINE READ WRITE 148943459 419430400 419430400
/opt/oracle/NMS/data/thuraya/datafiles/config02.dbf
16 ONLINE READ WRITE 148943459 419430400 419430400
/opt/oracle/NMS/data/thuraya/datafiles/data03.dbf
17 ONLINE READ WRITE 148943459 209715200 209715200
/opt/oracle/NMS/data/thuraya/rollbackseg/rollbackseg04.dbf
18 SYSTEM READ WRITE 148943459 838860800 838860800
/opt/oracle/NMS/data/thuraya/datafiles/system02.dbf
19 ONLINE READ WRITE 148943459 460800 460800
/volA1/opt/oracle/NMS/data/thuraya/datafiles/data04.dbf
FILE# STATUS ENABLED CHECKPOINT_CHANGE# BYTES CREATE_BYTES
---------- ------- ---------- ------------------ ---------- ------------
NAME
--------------------------------------------------------------------------------
20 ONLINE READ WRITE 148943459 471859200 471859200
/volA1/opt/oracle/NMS/data/thuraya/datafiles/data05.dbf
21 ONLINE READ WRITE 148943459 524288000 524288000
/volA2/oracle/datafiles/data06.dbf
22 SYSTEM READ WRITE 148943459 23068672 23068672
/opt/oracle/NMS/data/thuraya/datafiles/system03.dbf
23 SYSTEM READ WRITE 148943459 31457280 31457280
/opt/oracle/NMS/data/thuraya/datafiles/system04.dbf
23 rows selected.
|
|
|
Goto Forum:
Current Time: Sun Aug 25 01:56:42 CDT 2024
|