Re: Auto Datafile Creation - How to aktivate ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 21 Aug 2006 08:45:30 -0700
Message-ID: <1156175129.644257@bubbleator.drizzle.com>

Eagle Fan wrote:
> oracle noob wrote:

>> I want to create a new data file automatical, not extend an old one.
>>
>> This is the DDL sql, we use
>>
>> ALTER TABLESPACE "USERS" ADD DATAFILE '/oradata/xyz/users01.dbf' SIZE
>> 4194304K REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 4096M
>>
>>
>> The Datafile have to be smaler than 4,4 Gbyte.

>
> You can add a cron job to check the tablespace status for every 5 or 15
> minutes.
>
> You need to check the freespace of the tablespace, the free extent
> fragmentation if you are using DMT, the max next extent size and
> something else you concerned
>
> If you find the tablespace is "FULL" ( you define the "FULL" ), you can
> automatically add DATAFILES to the tablespace

I think it inappropriate to use a cron job for something that can and should be done entirely within the database and will work the same no matter the operating system and shell.

DBMS_JOB or DBMS_SCHEDULER can easily be used to run a procedure to monitor usage and take the appropriate actions when required including notifying the DBA what actions were taken and keeping a log of run results in a queryable table.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Aug 21 2006 - 10:45:30 CDT