Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pre requisite for disabling datafile autoextend status

BalajidbaJul 26 2016 — edited Jul 26 2016

Hi,

There are datafiles in the database whose autoextend status is on.

My question here is

1. Is it worth turning datafile autoextend status to off?

2. What are the pre requisite steps required to turn off datafile autoextend off?

Could someone please comment on above questions?

Oracle versions involved --

11.2.0.4.0

11.2.0.4.0

10.2.0.4.0

10.2.0.4.0

10.2.0.4.0

10.2.0.4.0

10.2.0.4.0

10.2.0.4.0

10.2.0.4.0

10.2.0.2.0

10.2.0.2.0

10.2.0.4.0

11.2.0.4.0

10.2.0.4.0

OS -- Unix

Environment involved --  Prod/Development/Test/Quality

Regards,

Bala

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2016
Added on Jul 26 2016
11 comments
403 views