Re: ORA-1650 error

Well, the info. is self-explanatory. Your rollback tablespaces are too small. So make 'em bigger.

The real issue, of course, is why your rollback segments feel the need to extend in the first place, because them doing so is bad for performance, and if they were properly sized to begin with, they wouldn't need to do so.

Somebody somewhere is (a) doing a massive piece of DML or (b) leaving a piece of DML uncommitted (a blocking transaction).

You need to keep your eye on v$transaction to see the size of transactions hitting your rollback segments. Adjust the size of the tablespaces to accomodate what that tells you.

Not everyone will agree, but disk space is cheap, Seagate hard disks are the best, and I find myself tempted these days to just throw an entire hard disk at the rollback issue ('course, I'm using auto-undo in 9i, but the same principles apply). It seems madness to me to stint on rollback tablespace space if it induces these kinds of errors.

Regards
HJR "xo55ox" <xo55ox_at_hotmail.com> wrote in message news:abbcb3d7.0208071633.4a44cdf6_at_posting.google.com...
> Hi,
>
> I have encountered ORA-1650: unable to extend rollback segment R12 by
> 128 in tablespace PSRBS04. I have 4 tablespaces set up for rollback
> segment. Each tablespace's size is 500M. The init. and next ext. are
> 1024K, min. ext. 20. I also set the Opt. size to 50000k.
>
> But I still have the ora-1650 error on random rollback segment.
>
> Can someone provide me info on how to fix this?
>
> Thanks in advance.
Received on Wed Aug 07 2002 - 19:40:58 CDT