Re: Question regarding rollback segment

William D. Hankard (wdh_at_epsilon.com) wrote:
: Hello,
 

: We are running Oracle 7.1.6 on an HP 9000 T500 running
: HP-UX 9.04
 

: Here is the problem we are having; our rollback table
: space is 3.0Gbytes in size.
 

: Our initial extent is 5Mbytes
: Our next extent is 5Mbytes also.
: Our OPTIMAL parameter is set to 220Mbytes.
: Our MINEXTENTS is 2
: Our MAXEXTENTS is 505
: Our Pro*C program commits after every 100 updates
: A row size is less than 200Bytes
 

: After about 100000 updates which is a 1000 commits, I get the 1555
: Oracle error:
 

: 01555, 00000, "snapshot too old (rollback segment too small)"
 

:
: We have tried the following to fix the problem:
: a. commit after every row
: b. commit after every 50 rows
: c. rollback segment in a non-RAID device
: d. 20Mbyte extents.
: e. restarted Oracle (reboot etc)
: f. recreated rollback tablespace
 

: None of these things have helped. Any suggestions or insight into this would
: be of great help. Thanks in advance.
 

: --
: ==========================================================================
: William D. Hankard Epsilon Data Management
: 50 Cambridge Street Burlington MA. 01803-4692
: Voice:(617)273-0250 Ext. 6738 High Performance Computing
: Fax:(617)272-1760 wdh_at_epsilon.com
: ==========================================================================

I think you are on the right track. Enlarging the rollback segment should solve your problem, Provided that you are telling it what rollback segment to use(the large one in this case). Received on Tue Jul 18 1995 - 00:00:00 CEST