Re: ORA-1650 error

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 9 Aug 2002 17:41:12 +1000
Message-ID: <3d5371e1@dnews.tpgi.com.au>

"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0208082007.7a6a3add_at_posting.google.com...
> If you have sufficient space in the file system, Set the AUTO EXTEND
> property
> of the datafile's in the tablespace's to ON.

Autoextension of data files should be considered a big no-no, performance-wise. So I can't agree that this bit of advice is sound.

> ex- ALTER TABLESPACE DATAFILE 'xxxxxx' AUTOEXTEND ON MAXSIZE xxxx;
> Hope your rollback segments are all in the same tablespace;
>
> I would prefer to set a specific ROLLBACK SEGMENT for the big
> transaction and set only that tablespaces datafiles to AUTOEXTEND.
>
> By the way are all the ROLLBACK tablespaces spread across different
> disks or are they on one single disk ?
> If you have all of them on one disk, i would prefer to have a single
> ROLLBACK tablespace instead of 4.

This makes sense.

Regards
HJR Received on Fri Aug 09 2002 - 02:41:12 CDT