RE: Autoextend Data files - Pros & Cons

> What are the advantages and disadvantages on giving Autoextend for
> Datafiles?

I had a customer "crash" the other day because he didn't keep his disk clean. It went for the autoextend and the disk was "full". Boom...

I don't mind it as a stop-gap, but like to manually extend as I see the need. Then I know that's not going to be a problem. If it was "my" system, I could take care of it, but as a "remote" DBA, they have a tendency to change things as they see fit. If I extend, then I can know the success and/or failure when I'm online and sort of "in control." Then, if it doesn't work, I can try to work around or notify the company.

It seems to be working okay on 8, but I had a 7.3.3 customer that it choked on. It did the autoextend, then died trying to write to unmapped tablespace. I think the extend took longer than it wanted to give it. When the database came up, it was extended and happy with the new allocation... so I think it was just a matter of timing between the extending and the wanting to write data to the new extent.

When I resize, I also try to do it during a "more idle" time.

Michael Kline
ThinkSpark Received on Thu Jun 08 2000 - 08:35:31 CDT