Re: rollback size question

Look at v$rollstat and check the high water mark size (HWMSIZE). If HWMSIZE is 10M, then I'd say that a 1M rbs is too small. How often does each rbs extend? Use v$rollstat to get an idea of your rbs usage.

HTH,
Brian

lyonard_at_my-deja.com wrote:
>
> I have a Oracle 7.0 Database on VMS5.5, lately having some Oracle
> performance issue. the server is a VAV 4500 running VMS 5.5 & Oracle 7.0
> We have 4 rbs, each 1 meg, is that sufficient.
>
> below is some info about the database
> we have a payroll application (usually 2 users with 3 or 4 others doing
> inquiries); we have a payroll batch cycle that runs Monday/Tuesday each
> week (extracts info from Oracle, processes sequential files, & merges
> the info back into Oracle; then a G/L interface that is written in
> PL/SQL); we have some users (average 25 users) - this usage is
> dropping as we move
> away from VMS.
> we have a number of small apps written in MS-Office that access VMS
> Oracle;
> low volume apps - one or two transactions per day.
> we have Payroll interface - this is written in MS-Access, lets the
> user input daily batches of labour & has a couple of reports that run
> for 15 to 20 minutes.
>
> Thanks
> Leonard
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 25 2000 - 09:48:26 CST