Re: Newbie DBA Question: ORA-01658

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 31 Oct 2001 10:25:33 +0100
Message-ID: <omgvttska3knsa1mkufadn80t3206lqjop@4ax.com>

On 31 Oct 2001 01:03:18 -0800, allanwtham_at_yahoo.com (godmann) wrote:

>Howard,
>
> Is letting the datafiles grow dynamically (autoextend on) a good
>practice? I am just wondering it may grow unbound if let unnoticed. What
>is the best practice if you do set it autoextend on
>
>Allan W. Tham
>DBA
Generally speaking for me autoextend on *without* upper limit means I loose control. It means that when disaster strikes (all my disks are full) I can't do anything to resolve it. I know of situations where the maximum size of tablespaces is negotiated in Service Level Agreements. In those situations it takes at least *14* days to get approval to extend the space allocated to it.
You don't want to have end up in a fix with such a SLA.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 31 2001 - 03:25:33 CST