Re: BaanIV and rollback segments

What is your largest possible transaction and how many transactions will be running at once? That is how much space you need to allocate for your rollback segments. There is probably a number of tx that require full table updates or significant portions thereof and likely as part of a complex query you are reading large rows; very few vendors code SQL efficiently so I would not be surprised if Baan uses a brute-force approach at times.

hth -

Regards,
jh

Han Brinkman (hbrinkman_at_profuse.nl) wrote:
: We are running an Oracle 7.3.3 database with BaanIV b2. The db is about 9Gb
: large. Rollback segments were 20 * 30Mb which have been changed last week to
: 10 * 60Mb. Still we sometimes get the 1555 error. Is there someone who can
: tell me the size of their rollback segments in combination with Baan? As you
: probably know within Baan it's not possible to specifiy specific rollback
: segments which it has to use.

: Thanks in advance,
: Han Brinkman

--

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **