i understand, but alot of people have posted here that its ok to have smaller extents 
anyway. 

who is correct? or am i missing something? 
> 
> From: "Richard Ji" <[EMAIL PROTECTED]>
> Date: 2003/06/20 Fri PM 02:00:11 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: oracle 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 of list ORACLE-L
> 
> 
> 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 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, but its indicative that its a segment
> thats doing something that was unforseen in the design
> phase..
> 
> hth
> connor
> 
>  --- [EMAIL PROTECTED] wrote: > I just read a .pdf by a
> couple of people at oracle
> > called Stop Fragmenting and start living where it
> > says not worry about the number of extents in a
> > tablespace. However in the administrators doc it
> > says the following:
> > 
> > Estimate Table Size and Set Storage Parameters
> > Estimating the sizes of tables before creating them
> > is useful for the following reasons: 
> > 
> > You can use the combined estimated size of tables,
> > along with estimates for indexes, rollback segments,
> > and redo log files, to determine the amount of disk
> > space that is required to hold an intended database.
> > From these estimates, you can make correct hardware
> > purchases and other decisions. 
> > 
> > You can use the estimated size of an individual
> > table to better manage the disk space that the table
> > will use. When a table is created, you can set
> > appropriate storage parameters and improve I/O
> > performance of applications that use the table. For
> > example, assume that you estimate the maximum size
> > of a table before creating it. If you then set the
> > storage parameters when you create the table, fewer
> > extents will be allocated for the table's data
> > segment, and all of the table's data will be stored
> > in a relatively contiguous section of disk space.
> > This decreases the time necessary for disk I/O
> > operations involving this table. 
> > 
> > this is at the following link: 
> > 
> >
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208
> 
> > 
> > am I reading this wrong or is Oracle stating that
> > you should have less extents in a table? I know
> > several people on here have posted that the number
> > of extents used by an object is almost irrelevant. 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net 
> > -- 
> > Author: <[EMAIL PROTECTED] 
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services    -- 858-538-5051
> > http://www.fatcity.com 
> > San Diego, California        -- Mailing list and web
> > hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing). 
> 
> =====
> Connor McDonald
> web: http://www.oracledba.co.uk 
> web: http://www.oaktable.net 
> email: [EMAIL PROTECTED] 
> 
> "GIVE a man a fish and he will eat for a day. But TEACH him how to
> fish, and...he will sit in a boat and drink beer all day"
> 
> ________________________________________________________________________
> Want to chat instantly with your online friends?  Get the FREE Yahoo!
> Messenger http://uk.messenger.yahoo.com/ 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Darrell Landrum
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Richard Ji
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to