It is the old argument that was made to justify one or only a few
extents. Empirically the idea does not hold up. This idea is now
classified as a myth but the Oracle docs have not caught up yet.
Allan
-Original Message-
Sent: Friday, June 20, 2003 11:20 AM
To: Multiple recipients of
Two reasons:
a) if you go into extent map blocks then you will
suffer an overhead of at least 1 billionth of a
percent :-)
b) more seriously, its generally easier to pick up a
rogue table if its run into thousands of extents and
you had not intended it to. Its not a performance
problem per se,
My favorite part is
and all of the table's data will be stored in a relatively contiguous
section of disk space.
Is this even reasonable to believe, especially with any kind of
striping implemented?
[EMAIL PROTECTED] 06/20/03 12:00PM
Two reasons:
a) if you go into extent map blocks then you
Even without stripping you can't gaurantee it will be a contiguous
section of disk space. The file could be scattered across
the file system.
Richard Ji
-Original Message-
Sent: Friday, June 20, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L
My favorite part is
and all of the
Does this mean that if I dd the file onto a raw partition, it will be
scattered around the raw partition? Even though the dd-ing process is
unaware of the characteristics of the raw partition?
-Original Message-
Even without stripping you can't gaurantee it will be a contiguous
or reasonable to WANT? if I'm running a data warehouse, maybe. If an
OLTP system, orders and customers etc then I'm not likely to WANT the
next block of data on disk for my transaction
--- Darrell Landrum [EMAIL PROTECTED] wrote:
My favorite part is
and all of the table's data will be stored
docs do say # of extents effect performance
Even without stripping you can't gaurantee it will be a contiguous
section of disk space. The file could be scattered across
the file system.
Richard Ji
-Original Message-
Sent: Friday, June 20, 2003 1:12 PM
To: Multiple recipients
PROTECTED]
Subject: Re: oracle docs do say # of extents effect performance
or reasonable to WANT? if I'm running a data warehouse, maybe. If an
OLTP system, orders and customers etc then I'm not likely to WANT the
next block of data on disk for my transaction
--- Darrell Landrum [EMAIL PROTECTED
of extents in a table be considered in table
design? there are alot of .pdfs and people on this listserv that say it is
irrelevant?
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/06/20 Fri PM 02:44:52 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: oracle docs do say
No, I was talking about on file system only.
-Original Message-
Sent: Friday, June 20, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Does this mean that if I dd the file onto a raw partition, it will be
scattered around the raw partition? Even though the dd-ing process is
10 matches
Mail list logo