Re: Autoextend or not?
From: Jack van Zanen <jack_at_vanzanen.com>
Date: Mon, 13 Apr 2009 21:19:06 +1000
Message-ID: <77a615a70904130419j61c61efcmec7509fddda0421c_at_mail.gmail.com>
I tend to lean towards dba managed filesizes but it is not a hard rule. I do not like a runaway loading/batch proces filling up a filesystem, however I do not like to get a call in the middle of the night that the batch job is going to run out of space either.
Date: Mon, 13 Apr 2009 21:19:06 +1000
Message-ID: <77a615a70904130419j61c61efcmec7509fddda0421c_at_mail.gmail.com>
I tend to lean towards dba managed filesizes but it is not a hard rule. I do not like a runaway loading/batch proces filling up a filesystem, however I do not like to get a call in the middle of the night that the batch job is going to run out of space either.
Most of our databases are DBA managed filesystems and warnings are send out in sufficient time so far.
Jack
2009/4/13 Guillermo Alan Bort <cicciuxdba_at_gmail.com>
> So,
>
> We have a debate going on about allowing databases with datafiles
> with autoextend on... anybody has any input on this? any experience?
>
> My side: I don't like autoextend, I can't trust the unix team to do
> their job and I can't allow for a datafile to fill up the FS. Then
> again, I can't trust monitoring tools to do their job, so autoextend
> *could* save the day.
>
> thanks, and kind regards to all!
> Alan Bort
> Oracle Certified Professional
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Jack van Zanen ------------------------- This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 13 2009 - 06:19:06 CDT