RE: AutoExtend / Locally Managed

From: <mkline1_at_comcast.net>
Date: Wed, 28 Apr 2004 15:16:54 +0000
Message-Id: <042820041516.24676.408FCAE6000BC82B000060642200750744FFCE9A91969394@comcast.net>

I've had to do this pretty heavy where I am at now.

CREATE TABLESPACE "RXV_IRO_M1"
NOLOGGING

    DATAFILE '/PFPRD_p016/oradata/PFPRD/rxv_iro_m1_01.dbf' SIZE 
    4001M REUSE, '/PFPRD_p016/oradata/PFPRD/rxv_iro_m1_02.dbf' SIZE 
    4001M REUSE, '/PFPRD_p016/oradata/PFPRD/rxv_iro_m1_03.dbf' SIZE

5601M REUSE AUTOEXTEND
ON NEXT 100M MAXSIZE 6001M, '/PFPRD_p017/oradata/PFPRD/

    rxv_iro_m1_04.dbf' SIZE 4001M REUSE, '/PFPRD_p017/oradata/PFPRD/
    rxv_iro_m1_05.dbf' SIZE 4001M REUSE, '/PFPRD_p017/oradata/PFPRD/
    rxv_iro_m1_06.dbf' SIZE 4001M REUSE, '/PFPRD_p017/oradata/PFPRD/
    rxv_iro_m1_07.dbf' SIZE 4001M REUSE, '/PFPRD_p017/oradata/PFPRD/
    rxv_iro_m1_08.dbf' SIZE 5501M REUSE AUTOEXTEND

ON NEXT 100M MAXSIZE 6001M, '/PFPRD_p017/oradata/PFPRD/ rxv_iro_m1_09.dbf' SIZE 4001M REUSE, '/PFPRD_p017/oradata/PFPRD/ rxv_iro_m1_10.dbf' SIZE 5501M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 5505M, '/PFPRD_p018/oradata/PFPRD/ rxv_iro_m1_11.dbf' SIZE 7101M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 10005M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240K I think have a spreadsheet. The 2nd section is the "bdf", the third reads the amount of autoextend left.

On the front page I keep track of:

"As of 04/27 Disk"
"Meg Left" - the free on the bdf
"Promised for expan" - how much is in auto extend

Made it? what's left
Comments
10% I need to keep - 10% of the total disk size to keep free. "Meg Left" - how my "promised" stacks up to the 10%

/PFRPT_p001 12,476 4,248 8,228 disk_1 3,277 4,951

Helps me stay ahead of many disks and datafiles, and what's in auto extend.

--
Michael Kline, Principle Consultant
Business To Business Solutions
13308 Thornridge Ct
Midlothian, VA  23112
804-744-1545


> There are those things that you "have to" do and then there are those =

> things you "HAVE TO" do.  This one lands in the latter pile. That is, =

> unless you want to "pay the piper later".

> 

> Dick Goulet

> Senior Oracle DBA

> Oracle Certified 8i DBA

> 

> -----Original Message-----

> From: Richard Foote [mailto:richard.foote_at_bigpond.com]

> Sent: Wednesday, April 28, 2004 9:47 AM

> To: oracle-l_at_freelists.org

> Subject: Re: AutoExtend / Locally Managed

> 

> 

> 

> ----- Original Message -----

> From: "Goulet, Dick" <DGoulet_at_vicr.com>

> To: <oracle-l_at_freelists.org>

> Sent: Wednesday, April 28, 2004 11:15 PM

> Subject: RE: AutoExtend / Locally Managed

> 

> 

> You can have autoextend on, but you've got to tell Oracle how much & by =

> =3D

> how much.

> 

> 

> 

> Hi Dick,

> 

> No, you don't "have to" tell Oracle. You "should" tell Oracle but if =

> not,

> Oracle will happily keep extending one block at a time until nada is =

> left.

> 

> Cheers

> 

> Richard

> 

> 

> ----------------------------------------------------------------




> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> ----------------------------------------------------------------

> To unsubscribe send email to:  oracle-l-request_at_freelists.org

> put 'unsubscribe' in the subject line.

> --

> Archives are at http://www.freelists.org/archives/oracle-l/

> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> -----------------------------------------------------------------

> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> ----------------------------------------------------------------

> To unsubscribe send email to:  oracle-l-request_at_freelists.org

> put 'unsubscribe' in the subject line.

> --

> Archives are at http://www.freelists.org/archives/oracle-l/

> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> -----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 28 2004 - 10:14:09 CDT