| ORA-01562 & ORA-01628 errors [message #118451] |
Thu, 05 May 2005 06:31  |
aalessio
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Hi, I am using oracle 8.1.7 and I am getting crazy with the following errors: ORA-01562 & ORA-01628 errors
I 've seen other post but I did not found any solution to my problem.
I have the following error :
ORA-01562: failed to extend rollback segment number 2
ORA-01628: max # extents (121) reached for rollback segment RBS1 ORA-06512: at MYTABLESPACE.PURGE",", line 49
clues:
1)line 49 of the PURGE Procedure implements row deletion (DELETE FROM ...WHERE ....)
2)a transaction in involved
3)The Sql Procedure I use to create MYTABLESPACE is:
set term off
set echo off
set verify off
SELECT to_char(SYSDATE,'DD/MM/YYYY HH24:MI') AS DateTime FROM DUAL;
CREATE TABLESPACE MYTABLESPACE _tbs
DATAFILE '&1\MYTABLESPACE _tbs.dbf' SIZE 50M REUSE
DEFAULT STORAGE ( INITIAL 20K NEXT 10K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
ALTER DATABASE DATAFILE '&1\MYTABLESPACE _tbs.dbf' AUTOEXTEND ON;
quit
Does anyone may help me?
Thanks
|
|
|
|
|
|
| Re: ORA-01562 & ORA-01628 errors [message #118491 is a reply to message #118482] |
Thu, 05 May 2005 10:20  |
aalessio
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Hi Frank, thanks for your reply
Ok. I have to add something. I’ am developing an application (we call it my_appl) which needs oracle. My_appls has to be a part of a more complex application (we call it cpx_appl) which is developed on oracle. If I run your code on my environment what I get is:
SQL> SELECT segment_name, max_extents FROM dba_rollback_segs;
SEGMENT_NAME MAX_EXTENTS
------------------------------ -----------
SYSTEM 505
RBS0 4096
RBS1 4096
RBS2 4096
RBS3 4096
RBS4 4096
RBS5 4096
RBS6 4096
8 rows selected.
And I think this is fine and I do not have these errors on my_appl.
I encounter these errors sometimes when I integrate my_appl inside cpx_appl.
I think the problem is that I use public rollback segment (I have to check max_extents on cpx_appl, but I guess it is 121). Do you think I should create one or more rollback segment used only by my_appl?
thx
Alessio
|
|
|
|
| Re: ORA-01562 & ORA-01628 errors [message #118502 is a reply to message #118491] |
Thu, 05 May 2005 11:33 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Yes, creating one more large enough RBS just for the purpose of this transaction is a viable option.
You can create a new RBS for use of this transaction & then drop the same later once this transaction gets over.
Regds
Girish
|
|
|
|
| Re: ORA-01562 & ORA-01628 errors [message #119058 is a reply to message #118502] |
Tue, 10 May 2005 08:19 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Experts has already given solution to your problem but you can read below written things to know what oracle corporation say about the error that you had faced....
ORA-01562 failed to extend rollback segment number string
Cause: Failure occurred when trying to extend rollback segment.
Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use SELECT SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE SEGMENT_ID=string (where string is the segment number from the message) to determine the rollback segment name. Then use the ALTER ROLLBACK SEGMENT OFFLINE command to take the rollback segment offline
ORA-01628 max # extents (string) reached for rollback segment string
Cause: An attempt was made to extend a rollback segment that was already at the MAXEXENTS value.
Action: If the value of the MAXEXTENTS storage parameter is less than the maximum allowed by the system, raise this value.
From:-Sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
