Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollbacks - ORA-1555
Hello All,
I changed the rollback segments, and here are the results. I'm now at 20 segments, 1 meg each, minextents 20, optimal 20. Here are the results after running the process within the application with auto-commits turned off...
data requests
2969079
CLASS COUNT ------------------ --------- system undo header 0 system undo block 0 undo header 1 undo block 0 USN NAME AVEACTIVE OPTSIZE WAITS WRAPS EXTENDS SHRINKS AVESHRINK ---- ---------- --------- --------- ----- ----- ------- --------- --------- 0 SYSTEM 0 0 0 0 0 0 2 SV_ROLL0 106086 20971520 0 1 0 0 0 3 SV_ROLL1 106086 20971520 0 1 0 0 0 4 SV_ROLL2 106086 20971520 0 1 0 0 0 5 SV_ROLL3 106086 20971520 0 1 0 0 0 6 SV_ROLL4 0 20971520 0 0 0 0 0 7 SV_ROLL5 106086 20971520 0 1 0 0 0 8 SV_ROLL6 106086 20971520 0 1 0 0 0 9 SV_ROLL7 106086 20971520 0 1 0 0 0 10 SV_ROLL8 106086 20971520 0 1 0 0 0 11 SV_ROLL9 106086 20971520 0 1 0 0 0 12 SV_ROLL10 201973 20971520 1 2 0 0 0 13 SV_ROLL11 0 20971520 0 0 0 0 0 14 SV_ROLL12 106086 20971520 0 1 0 0 0 15 SV_ROLL13 106086 20971520 0 1 0 0 0 16 SV_ROLL14 106086 20971520 0 1 0 0 0 17 SV_ROLL15 106086 20971520 0 1 0 0 0 18 SV_ROLL16 201973 20971520 0 2 0 0 0 19 SV_ROLL17 106086 20971520 0 1 0 0 0 20 SV_ROLL18 106086 20971520 0 1 0 0 0 21 SV_ROLL19 106086 20971520 0 1 0 0 0
21 rows selected.
TSPACE TOTAL USED FREE --------------- --------- --------- --------- SV_ROLL_TSP 800 407 394 This doesn't look real good to me....am I correct??? I will try processing without the optimal being set to see what happens, while I await other response.
thanks!
Christine
-----Original Message-----
Thapliyal
Sent: Tuesday, December 04, 2001 5:12 PM
To: Multiple recipients of list ORACLE-L
Hi Christine,
Your rollback segments look large to me based on the description you have given for your application. One way of eliminating header waits is to increase the number of rbs .. try this and post if this helps your stats..
meaning that each rbs will have 20 extents initially and size of each rbs will be 20M initially. since you have 20 such rbs, total rbs used is 20 * 20M = 400M
if you observe, the above structure uses smaller sized large number of rollback segments as from your description below, it looks like you have a oltp system with large number of transactions
tell me if this helps ..
Deepak
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: deepakthapliyal_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christine Turner INET: christine.turner_at_ips-sendero.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Dec 05 2001 - 10:59:38 CST
![]() |
![]() |