RE: AutoExtend / Locally Managed
- From: mkline1@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Apr 2004 15:16:54 +0000
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@xxxxxxxxxxx]
> Sent: Wednesday, April 28, 2004 9:47 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: AutoExtend / Locally Managed
>
>
>
> ----- Original Message -----
> From: "Goulet, Dick" <DGoulet@xxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
