 | | | DATAFILE?? | DATAFILE?? 2005-10-20 - By Kennedy, Jim
Interesting that they changed it. Looks like they changed it from 9i. Good to
know. Probably better they did.
Jim
-- --Original Message-- --
From: Niall Litchfield [mailto:niall.litchfield@(protected)]
Sent: Thu 10/20/2005 3:29 AM
To: Kennedy, Jim
Cc: cmarquez@(protected); Yavor_Ivanov@(protected); Oracle Mailing List;
oracle.tutorials@(protected)
Subject: Re: DATAFILE??
On 10/18/05, oracle-l-bounce@(protected) <oracle-l-bounce@(protected)>
wrote:
>
> The best way to find out is to try it. You will probably find that it
> depends. If you use a LMT and do uniform extents then it will do it by
> concatenation. (fill up the first file then move on to the 2nd etc.).
> If you create an LMT and do automatic extents then it is different. It
> does it by striping. The first extent goes in the first file, the 2nd
> in the 2nd file...
>
> You can see this by setting up a small test.
> Jim
Unfortunately, if you run the test you'll find that your assertion isn't
correct on 10gR1 :)
1 create tablespace demo
2 datafile 'c:\temp\demo01.dbf' size 10m,'c:\temp\demo02.dbf' size 10m
3* extent management local uniform size 128k
USER @ orcl>/
Tablespace created.
USER @ orcl>create table t1(c1 number);
create table t1(c1 number)
*
ERROR at line 1:
ORA-00955 (See ORA-00955.ora-code.com): name is already used by an existing object
USER @ orcl>create table demo(c1 number);
Table created.
USER @ orcl>drop table demo;
Table dropped.
USER @ orcl>create table demo(c1 number)
2 tablespace demo;
Table created.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>alter table demo allocate extent;
Table altered.
USER@ orcl>alter table demo allocate extent;
Table altered.
USER @ orcl>select file_id,count(*)
2 from dba_extents
3 where segment_name='DEMO'
4 group by file_id;
FILE_ID COUNT(*)
-- ---- -- -- ---- --
9 4
10 3
2 rows selected.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>RE: DATAFILE??</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Interesting that they changed it. Looks like they changed
it from 9i. Good to know. Probably better they did.<BR>
Jim<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: Niall Litchfield [<A HREF="mailto:niall.litchfield@(protected)">mailto
:niall.litchfield@(protected)</A>]<BR>
Sent: Thu 10/20/2005 3:29 AM<BR>
To: Kennedy, Jim<BR>
Cc: cmarquez@(protected); Yavor_Ivanov@(protected); Oracle Mailing List;
oracle.tutorials@(protected)<BR>
Subject: Re: DATAFILE??<BR>
<BR>
On 10/18/05, oracle-l-bounce@(protected) <oracle-l-bounce@(protected)>
;<BR>
wrote:<BR>
><BR>
> The best way to find out is to try it. You will probably find that it<BR>
> depends. If you use a LMT and do uniform extents then it will do it by<BR>
> concatenation. (fill up the first file then move on to the 2nd etc.).<BR>
> If you create an LMT and do automatic extents then it is different. It<BR>
> does it by striping. The first extent goes in the first file, the 2nd<BR>
> in the 2nd file...<BR>
><BR>
> You can see this by setting up a small test.<BR>
> Jim<BR>
<BR>
Unfortunately, if you run the test you'll find that your assertion isn't
<BR>
correct on 10gR1 :)<BR>
<BR>
<BR>
1 create tablespace demo<BR>
2 datafile 'c:\temp\demo01.dbf' size 10m,'c:\temp\demo02.dbf' size 10m<BR>
3* extent management local uniform size 128k<BR>
USER @ orcl>/<BR>
<BR>
Tablespace created.<BR>
<BR>
USER @ orcl>create table t1(c1 number);<BR>
create table t1(c1 number)<BR>
*<BR>
ERROR at line 1:<BR>
ORA-00955 (See ORA-00955.ora-code.com): name is already used by an existing object<BR>
<BR>
<BR>
USER @ orcl>create table demo(c1 number);<BR>
<BR>
Table created.<BR>
<BR>
USER @ orcl>drop table demo;<BR>
<BR>
Table dropped.<BR>
<BR>
USER @ orcl>create table demo(c1 number)<BR>
2 tablespace demo;<BR>
<BR>
Table created.<BR>
<BR>
USER @ orcl>alter table demo allocate extent;<BR>
<BR>
Table altered.<BR>
<BR>
USER @ orcl>alter table demo allocate extent;<BR>
<BR>
Table altered.<BR>
<BR>
USER @ orcl>alter table demo allocate extent;<BR>
<BR>
Table altered.<BR>
<BR>
USER @ orcl>alter table demo allocate extent;<BR>
<BR>
Table altered.<BR>
<BR>
USER @ orcl>alter table demo allocate extent;<BR>
<BR>
Table altered.<BR>
<BR>
USER@ orcl>alter table demo allocate extent;<BR>
<BR>
Table altered.<BR>
<BR>
USER @ orcl>select file_id,count(*)<BR>
2 from dba_extents<BR>
3 where segment_name='DEMO'<BR>
4 group by file_id;<BR>
<BR>
FILE_ID COUNT(*)<BR>
-- ---- -- -- ---- --<BR>
9 4<BR>
10 3<BR>
<BR>
2 rows selected.<BR>
<BR>
--<BR>
Niall Litchfield<BR>
Oracle DBA<BR>
<A HREF="http://www.niall.litchfield.dial.pipex.com">http://www.niall
.litchfield.dial.pipex.com</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
|
|
|