RE: Extents size.

[MacGregor, Ian A.]

This is very noticeable when you are debugging a problem and are seeing  "scattered 
read"  events.  The query against dba_EXTENTS  based on file_id, block_id and owner 
can take an inordinate amount of time.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, October 03, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L


Christopher,

Is the guideline 505 extents for the tablespace or each table in the tablespace?

Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Wednesday, October 03, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


LMT's have their own problems as well though.

Using LMT's, the bitmap on the tablespace is only used to manage free space,
used space is in the segment header of the segment which represents the
extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
headers (of all tables and indexes in the database) as well as all the
additional extent maps.  This can cause a very large amount of physical
reads in comparison to the dictionary-managed extents.

Although LMT's are great, they are not perfect and do have their share of
concerns.  And like Connor pointed out, for a 8K block size, it is highly
suggested to keep the extents to 505 which would only create a single block
for the segment header, anything further than that will create additional
blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
headers (be it one or two) as well as the extent maps.

The formula he used is (blocksize / 16)-7, which determine how many extents,
can fit in the segment header of a LMT tablespace.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Wong, Bing
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public 

RE: Extents size.

[Christopher Spence]

See post which is similar, but per segment, each partition in a partition
table is a different segment.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L

Does the 505 extent "limit" apply to the whole of a partitioned table
or to the number of extents per partition?

For example if I had a table wth 371 partitions (53 weeks per year *
7 years) to hold invoice data for tax purposes, do the number of
extents per partition need to be kept at 1 to avoid exceeding the
505 extent value on the table as a whole?

Christopher Spence wrote:
> 
> LMT's have their own problems as well though.
> 
> Using LMT's, the bitmap on the tablespace is only used to manage free
space,
> used space is in the segment header of the segment which represents the
> extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
> headers (of all tables and indexes in the database) as well as all the
> additional extent maps.  This can cause a very large amount of physical
> reads in comparison to the dictionary-managed extents.
> 
> Although LMT's are great, they are not perfect and do have their share of
> concerns.  And like Connor pointed out, for a 8K block size, it is highly
> suggested to keep the extents to 505 which would only create a single
block
> for the segment header, anything further than that will create additional
> blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
> headers (be it one or two) as well as the extent maps.
> 
> The formula he used is (blocksize / 16)-7, which determine how many
extents,
> can fit in the segment header of a LMT tablespace.
> 
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
> 
> 
> -Original Message-
> Sent: Tuesday, October 02, 2001 5:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> True - but we're all using LMT's now anyway aren't we
> ?
> 
> :-)
> 
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > well, only when you are deleting massive amounts of
> > data or truncating
> > with drop storage.. then there is an impact because
> > of the hits on the
> > dictionary tables.
> >
> > but basically yes... I've been told by various
> > Oracle employees that up
> > to 4096 extents cause no problem whatsoever.
> >
> >
> > --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > > That is completely a myth.  There is no notable
> > performance different
> > > with a
> > > table with 10,000 extents and one with 1.
> > >
> > > The only problem is when it comes to the bitmaps
> > when dealing with
> > > LMT and
> > > cluster when dealing with dictionary managed.
> > When you query the
> > > extent
> > > views, or do space management type processes.
> > >
> > > "Do not criticize someone until you walked a mile
> > in their shoes,
> > > that way
> > > when you criticize them, you are a mile a way and
> > have their shoes."
> > >
> > > Christopher R. Spence
> > > Oracle DBA
> > > Phone: (978) 322-5744
> > > Fax:(707) 885-2275
> > >
> > > Fuelspot
> > > 73 Princeton Street
> > > North, Chelmsford 01863
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 7:15 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > May be it is good practice to keep number of
> > extents to be less than
> > > 50, no
> > > matter what the size of extent.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 3:35 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hello,
> > >
> > > I'll do an reorganization of a database (about 140
> > gigs). Some people
> > > say
> > > that it'd be good to use 128K, 4M and 128M
> > extents. I saw somewhere
> > > it'd be
> > > 160K, 4M and 160M. Which size do you advice me ? I
> > have also many
> > > small
> > > indexes (less than 16K).
> > >
> > > Regards,
> > >
> > > Thanh-truc Nguyen
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Thanh-truc Nguyen
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing
> > > Lists
> > >
> >
> 
> > > 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,

RE: Extents size.

[Christopher Spence]

It depends on block size, but yes for each segment, which is for each index,
table, partition, etc.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Wednesday, October 03, 2001 11:25 AM
To: Multiple recipients of list ORACLE-L

Christopher,

Is the guideline 505 extents for the tablespace or each table in the
tablespace?

Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Wednesday, October 03, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


LMT's have their own problems as well though.

Using LMT's, the bitmap on the tablespace is only used to manage free space,
used space is in the segment header of the segment which represents the
extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
headers (of all tables and indexes in the database) as well as all the
additional extent maps.  This can cause a very large amount of physical
reads in comparison to the dictionary-managed extents.

Although LMT's are great, they are not perfect and do have their share of
concerns.  And like Connor pointed out, for a 8K block size, it is highly
suggested to keep the extents to 505 which would only create a single block
for the segment header, anything further than that will create additional
blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
headers (be it one or two) as well as the extent maps.

The formula he used is (blocksize / 16)-7, which determine how many extents,
can fit in the segment header of a LMT tablespace.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Wong, Bing
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City

Re: Extents size.

[Charlie Mengler]

Does the 505 extent "limit" apply to the whole of a partitioned table
or to the number of extents per partition?

For example if I had a table wth 371 partitions (53 weeks per year *
7 years) to hold invoice data for tax purposes, do the number of
extents per partition need to be kept at 1 to avoid exceeding the
505 extent value on the table as a whole?

Christopher Spence wrote:
> 
> LMT's have their own problems as well though.
> 
> Using LMT's, the bitmap on the tablespace is only used to manage free space,
> used space is in the segment header of the segment which represents the
> extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
> headers (of all tables and indexes in the database) as well as all the
> additional extent maps.  This can cause a very large amount of physical
> reads in comparison to the dictionary-managed extents.
> 
> Although LMT's are great, they are not perfect and do have their share of
> concerns.  And like Connor pointed out, for a 8K block size, it is highly
> suggested to keep the extents to 505 which would only create a single block
> for the segment header, anything further than that will create additional
> blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
> headers (be it one or two) as well as the extent maps.
> 
> The formula he used is (blocksize / 16)-7, which determine how many extents,
> can fit in the segment header of a LMT tablespace.
> 
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
> 
> 
> -Original Message-
> Sent: Tuesday, October 02, 2001 5:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> True - but we're all using LMT's now anyway aren't we
> ?
> 
> :-)
> 
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > well, only when you are deleting massive amounts of
> > data or truncating
> > with drop storage.. then there is an impact because
> > of the hits on the
> > dictionary tables.
> >
> > but basically yes... I've been told by various
> > Oracle employees that up
> > to 4096 extents cause no problem whatsoever.
> >
> >
> > --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > > That is completely a myth.  There is no notable
> > performance different
> > > with a
> > > table with 10,000 extents and one with 1.
> > >
> > > The only problem is when it comes to the bitmaps
> > when dealing with
> > > LMT and
> > > cluster when dealing with dictionary managed.
> > When you query the
> > > extent
> > > views, or do space management type processes.
> > >
> > > "Do not criticize someone until you walked a mile
> > in their shoes,
> > > that way
> > > when you criticize them, you are a mile a way and
> > have their shoes."
> > >
> > > Christopher R. Spence
> > > Oracle DBA
> > > Phone: (978) 322-5744
> > > Fax:(707) 885-2275
> > >
> > > Fuelspot
> > > 73 Princeton Street
> > > North, Chelmsford 01863
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 7:15 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > May be it is good practice to keep number of
> > extents to be less than
> > > 50, no
> > > matter what the size of extent.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 3:35 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hello,
> > >
> > > I'll do an reorganization of a database (about 140
> > gigs). Some people
> > > say
> > > that it'd be good to use 128K, 4M and 128M
> > extents. I saw somewhere
> > > it'd be
> > > 160K, 4M and 160M. Which size do you advice me ? I
> > have also many
> > > small
> > > indexes (less than 16K).
> > >
> > > Regards,
> > >
> > > Thanh-truc Nguyen
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Thanh-truc Nguyen
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing
> > > Lists
> > >
> >
> 
> > > 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.com
> > > --
> > > Author: Wong, Bing
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / 

RE: Extents size.

[Terrian, Tom]

Christopher,

Is the guideline 505 extents for the tablespace or each table in the tablespace?

Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Wednesday, October 03, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


LMT's have their own problems as well though.

Using LMT's, the bitmap on the tablespace is only used to manage free space,
used space is in the segment header of the segment which represents the
extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
headers (of all tables and indexes in the database) as well as all the
additional extent maps.  This can cause a very large amount of physical
reads in comparison to the dictionary-managed extents.

Although LMT's are great, they are not perfect and do have their share of
concerns.  And like Connor pointed out, for a 8K block size, it is highly
suggested to keep the extents to 505 which would only create a single block
for the segment header, anything further than that will create additional
blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
headers (be it one or two) as well as the extent maps.

The formula he used is (blocksize / 16)-7, which determine how many extents,
can fit in the segment header of a LMT tablespace.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Wong, Bing
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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).  Yo

RE: Extents size.

[Christopher Spence]

LMT's have their own problems as well though.

Using LMT's, the bitmap on the tablespace is only used to manage free space,
used space is in the segment header of the segment which represents the
extents.  Therefore, to do a query of DBA_EXTENTS you can hit all segment
headers (of all tables and indexes in the database) as well as all the
additional extent maps.  This can cause a very large amount of physical
reads in comparison to the dictionary-managed extents.

Although LMT's are great, they are not perfect and do have their share of
concerns.  And like Connor pointed out, for a 8K block size, it is highly
suggested to keep the extents to 505 which would only create a single block
for the segment header, anything further than that will create additional
blocks for the segment.  Remember, DBA_EXTENTS has to hit all the segment
headers (be it one or two) as well as the extent maps.

The formula he used is (blocksize / 16)-7, which determine how many extents,
can fit in the segment header of a LMT tablespace.  

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:55 PM
To: Multiple recipients of list ORACLE-L

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Wong, Bing
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Christopher Spence
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FA

RE: Extents size.

[Christopher Spence]

I have put together a summary of this thread as a tip on my website:

http://www.vampired.net/forums/viewtopic.php?topic=47&forum=15&0

For those who are interested in this.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L

Thanks.You are right

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:10:30 -0800

Yes, that is very true.  That is why I mentioned the performance will be
noticeable at times when dealing with the extent bitmaps for LMT and the
dictionary for dictionary managed, wither it be ad-hoc or recursive sql.

Unless your doing a lot of truncates or drops, I would bear performance
changes on DML and not DDL.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L

Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


___

RE: Extents size.

[Connor McDonald]

The best "documentation" (and I use the term very
loosely) is:

1) SQL.BSQ ($ORACLE_HOME/rdbms/admin)
2) select view_name, text
   from dba_views
   where view_name like 'DBA%'
3) select * from v$fixed_view_definition

hth
connor

 --- [EMAIL PROTECTED] wrote: > This thread
has been very interesting and causing me
> to learn and go read
> some more.  Which leads me to my next question. 
> Does anyone have any good
> papers or urls that will discuss and explain all of
> the base data dictionary
> tables: fet$, uet$, etc.? Or anyone have a data
> model of how all of the
> tables relate.  I've only been in this long enough
> to feel comfortable with
> the data dictionary tables and v$views and have
> never delved into learning
> about the base tables, maybe it's time I do some
> serious studying. If anyone
> can point me into the right direction as far as
> learning this topic, I'd
> really appreciate it. Thanks. Ivan
> 
> -Original Message-
> Sent: Tuesday, October 02, 2001 6:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> As far as DDL is concerned ,Yes. I have seen
> Dataware House application(not 
> a good design) that dropping/truncating tables with
> lot of extents takes 
> longer time because of extent management. Such code
> must take into account 
> no of extents of such objects. If those objects are
> created with proper 
> sizing then it will perform better for any DDL.
> Regards
> 
> 
> MOHAMMAD RAFIQ
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Date: Tue, 02 Oct 2001 13:15:30 -0800
> 
> Why is that?  And would that only count for an
> object in a dictionary
> managed tablespace?  Would the time/speed it takes
> for drops and truncates
> really matter as far as performance is concerned?
> What I mean is who would
> set storage specs for objects with the speed it
> takes for truncates and
> drops of that object in mind?  It would seem to me
> that if an object is
> getting dropped or truncated that often that speed
> should be an issue, there
> are bigger problems at hand. Guru's correct me if
> I'm wrong please. Later,
> Ivan
> 
> -Original Message-
> Sent: Tuesday, October 02, 2001 3:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Any DDL like drop table and truncate table
> definately take longer with
> 10,000 extents than 1 extent. Try it. There was a
> test result 1 year back by
> 
> a list member on that.
> 
> Regards
> 
> MOHAMMAD RAFIQ
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Date: Tue, 02 Oct 2001 07:55:28 -0800
> 
> That is completely a myth.  There is no notable
> performance different with a
> table with 10,000 extents and one with 1.
> 
> The only problem is when it comes to the bitmaps
> when dealing with LMT and
> cluster when dealing with dictionary managed.  When
> you query the extent
> views, or do space management type processes.
> 
> "Do not criticize someone until you walked a mile in
> their shoes, that way
> when you criticize them, you are a mile a way and
> have their shoes."
> 
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
> 
> 
> 
> -Original Message-
> Sent: Monday, October 01, 2001 7:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> May be it is good practice to keep number of extents
> to be less than 50, no
> matter what the size of extent.
> 
> 
> 
> -Original Message-
> Sent: Monday, October 01, 2001 3:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello,
> 
> I'll do an reorganization of a database (about 140
> gigs). Some people say
> that it'd be good to use 128K, 4M and 128M extents.
> I saw somewhere it'd be
> 160K, 4M and 160M. Which size do you advice me ? I
> have also many small
> indexes (less than 16K).
> 
> Regards,
> 
> Thanh-truc Nguyen
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Thanh-truc Nguyen
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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.com
> --
> Author: Wong, Bing
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>
--

Re: Extents size.

[Paul Drake]

> Of course, if you're using LMT's, this exercise is a waste
> of time.  :)

that's because they learned to stop defragmenting and start living :)

paul

Jared Still wrote:
> 
> First I've heard from Ferenc for awhile, even if
> it is 2 years old.
> 
> Using extreme cases like this really doesn't make
> for a good example.  I know an instructor that
> dropped/recreated/imported and entire database
> because the 'drop table' ran for 2 days with no
> end in sight.
> 
> Extents were 300,000+.
> 
> I suspect that that the graph of time vs. number of
> extents in data dictionary operations has a rather
> steep curve on the right side.  It would be interesting
> to see where the curve breaks, as it's not likely
> a linear rise.
> 
> Of course, if you're using LMT's, this exercise is a waste
> of time.  :)
> 
> Jared
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: Extents size.

[Jared Still]

First I've heard from Ferenc for awhile, even if
it is 2 years old.

Using extreme cases like this really doesn't make 
for a good example.  I know an instructor that
dropped/recreated/imported and entire database 
because the 'drop table' ran for 2 days with no
end in sight.

Extents were 300,000+.

I suspect that that the graph of time vs. number of
extents in data dictionary operations has a rather
steep curve on the right side.  It would be interesting
to see where the curve breaks, as it's not likely
a linear rise.

Of course, if you're using LMT's, this exercise is a waste
of time.  :)

Jared


On Tuesday 02 October 2001 15:16, Mohammad Rafiq wrote:
> Further to my previous message, I am reproudcing an email of a list member
> on this subject. It is really interesting to read it..
>
>
> Reply-To: Ferenc Mantfeld <[EMAIL PROTECTED]>
> To: "oracle list" <[EMAIL PROTECTED]>
> Date: Tue, 20 Jul 1999 16:25:15 -0500
>
> Hi all
>
> We know that Oracle often gives us enough rope to hang
> ourselves with. In
> Kevin Loney's presentation at IOUG this year, he brought up
> an interesting
> point about unlimited extents being one of the more
> boneheaded idea Oracle
> came up with, so I decided to conduct my own experiment :
>
> Environment :
> HP V2500, 16 CPU's running at 450 Mhz, 8 GB Ram, 2.5 GBPS
> fiber channel port
> connection, running Oracle 7.3.4.4 on HP-UX 11.0.
> DB_BLOCK_SIZE=8192
> In other words, one real kick-ass machine
>
> One table :
>
> 1,2 million rows in a single extent of 120 MB.
>
> Export this table.
> Set timing on
> Drop it : 3.5 seconds.
>
> Recreate the table as follows :
> Create table my_tab ( ..) storage (initial 16 k next 8 k
> pctincrease 0
> minextetns 1 maxextents 3 ) pctfree 5
> tablespace my_own_persoanl_ts ;
> Make a note of the datafile numbers for your tablespace, you
> will need this
> to determine how far you are from being done :
>
> import your old table  (ignore=y, indexes=no), check your
> alert log , when
> you see :
>   ORA-1631: max # extents 3 reached in table/cluster
> DBA_USER.S_ORG_PROD
> then ps_ef | grep -i imp
> and kill the process.
>
> Now you have a 30,000 extent table.
> First turn on tracing for tkprof :
> SQL > alter session set sql_trace true ;
> session altered
> SQL >
>
> Now drop the table :
> SBPRD-DBA_USER> drop table s_org_prod;
>
> table dropped
> Elapsed: 01:53:42.89
>
> SQL >
>
> In the meantime, from another session, logged in as SYS
> You know that this is the only table that lives in your
> particular datafile
> , so :
> SQL > select count (*) from uet$ where file#=5 ;
>
>COUNT(*)
> --
>   26638
> SBPRD-DBA_USER> /
>
>COUNT(*)
> --
>   26254
>
> (so you can see the allocated user extent table decreasing).
>
> Bottom line is that from the recursive DML being done on uet$
> and fet$, the
> process has slowed down from 3.5 seconds to almost two hours,
> and we are not
> talking a Mickey Mouse machine here.
>
> Just another reminder that good database design ALWAYS pays
> off, and we are
> to look at new "benefits" that the rdbms offers us, with
> optimistic
> skepticism .
>
> Hope this benchmark is of use to someone out there. If you
> like, I can mail
> the output result of the tkprof (sys=yes) to you.
>
> Regards :
>
> Ferenc Mantfeld
> Oracle DBA
>
>
>
>
> MOHAMMAD RAFIQ
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Tue, 02 Oct 2001 13:15:30 -0800
>
> Why is that?  And would that only count for an object in a dictionary
> managed tablespace?  Would the time/speed it takes for drops and truncates
> really matter as far as performance is concerned? What I mean is who would
> set storage specs for objects with the speed it takes for truncates and
> drops of that object in mind?  It would seem to me that if an object is
> getting dropped or truncated that often that speed should be an issue,
> there are bigger problems at hand. Guru's correct me if I'm wrong please.
> Later, Ivan
>
> -Original Message-
> Sent: Tuesday, October 02, 2001 3:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Any DDL like drop table and truncate table definately take longer with
> 10,000 extents than 1 extent. Try it. There was a test result 1 year back
> by
>
> a list member on that.
>
> Regards
>
> MOHAMMAD RAFIQ
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Tue, 02 Oct 2001 07:55:28 -0800
>
> That is completely a myth.  There is no notable performance different with
> a table with 10,000 extents and one with 1.
>
> The only problem is when it comes to the bitmaps when dealing with LMT and
> cluster when dealing with dictionary managed.  When you query the extent
> views, or do space management type processes.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
>

RE: Extents size.

[Jacques Kilchoer]

Title: RE: Extents size.





There might be a document somewhere that explains them, but the way I've learned about those tables is to look at the source code for the dba_ views. Go through those views one by one, and look at the tables behind the views.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]


This thread has been very interesting and causing me to learn and go read some more.  Which leads me to my next question.  Does anyone have any good papers or urls that will discuss and explain all of the base data dictionary tables: fet$, uet$, etc.? Or anyone have a data model of how all of the tables relate.  I've only been in this long enough to feel comfortable with the data dictionary tables and v$views and have never delved into learning about the base tables, maybe it's time I do some serious studying. If anyone can point me into the right direction as far as learning this topic, I'd really appreciate it. Thanks. Ivan

RE: RE: Extents size.

[Jack C. Applewhite]

Multiple extents a good thing?  YES!

I'm *depending* on many multiple extents of an interMedia index segment (the
DR$<>$I segment) to distribute I/O for full text indexing and queries.  I
plan to distribute the datafiles of the tablespace holding the DR$<>$I
segment across multiple drives and set the uniform extent size to 1MB.
Since Oracle8i distributes new extents for a table or index in a round-robin
fashion, I'll get even distribution of that big token table across several
spindles.  (...and with a couple gig more RAM on a new Win2k box we're
getting, I'll be able to cache all 900MB of the DR$<>$X index - YAY!)8^)

BTW, the largest of our out-of-line CLOB segments have nearly 30,000 extents
(1MB per extent) with no performance problems at all.  However, I am going
to implement 100MB extents for those CLOB segments on the new box, to keep
the LMT bitmaps within an 8KB block.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, October 02, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L


Back in the V6 days it was a desired characteristic to have every thing in
the
first extent of an object for performance reasons.  Thankfully those days
are
gone and it really does not matter how many extents there are.  Rachel has a
presentation on Oracle Myths where she actually portrays having multiple
extents
as a good thing from an IO perspective (Rachel, correct me if I got this
wrong).
 Although I can't give you exact examples, take a look and
v$filestat.  I've found that tablespaces where there are more than one
extent in
the objects have a lower average io wait time that those where everything is
in
the first extent.

The only real good reason I have found for re-organizing a tablespace is to
get
all of the used extents at one end and all of the free extents (you know
those
little bitty ones that individually aren't worth the trouble, but
together!!) at
the other end.

Dick Goulet

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[Ivan_Rivera]

Title: RE: Extents size.





This thread has been very interesting and causing me to learn and go read some more.  Which leads me to my next question.  Does anyone have any good papers or urls that will discuss and explain all of the base data dictionary tables: fet$, uet$, etc.? Or anyone have a data model of how all of the tables relate.  I've only been in this long enough to feel comfortable with the data dictionary tables and v$views and have never delved into learning about the base tables, maybe it's time I do some serious studying. If anyone can point me into the right direction as far as learning this topic, I'd really appreciate it. Thanks. Ivan

-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 6:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Extents size.



As far as DDL is concerned ,Yes. I have seen Dataware House application(not 
a good design) that dropping/truncating tables with lot of extents takes 
longer time because of extent management. Such code must take into account 
no of extents of such objects. If those objects are created with proper 
sizing then it will perform better for any DDL.
Regards



MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:15:30 -0800


Why is that?  And would that only count for an object in a dictionary
managed tablespace?  Would the time/speed it takes for drops and truncates
really matter as far as performance is concerned? What I mean is who would
set storage specs for objects with the speed it takes for truncates and
drops of that object in mind?  It would seem to me that if an object is
getting dropped or truncated that often that speed should be an issue, there
are bigger problems at hand. Guru's correct me if I'm wrong please. Later,
Ivan


-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L



Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by


a list member on that.


Regards


MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800


That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.


The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L


May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.




-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L



Hello,


I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).


Regards,


Thanh-truc Nguyen


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
    INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
    INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.orafa

RE: Extents size.

[Mohammad Rafiq]

As far as DDL is concerned ,Yes. I have seen Dataware House application(not 
a good design) that dropping/truncating tables with lot of extents takes 
longer time because of extent management. Such code must take into account 
no of extents of such objects. If those objects are created with proper 
sizing then it will perform better for any DDL.
Regards


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:15:30 -0800

Why is that?  And would that only count for an object in a dictionary
managed tablespace?  Would the time/speed it takes for drops and truncates
really matter as far as performance is concerned? What I mean is who would
set storage specs for objects with the speed it takes for truncates and
drops of that object in mind?  It would seem to me that if an object is
getting dropped or truncated that often that speed should be an issue, there
are bigger problems at hand. Guru's correct me if I'm wrong please. Later,
Ivan

-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- 

RE: Extents size.

[Connor McDonald]

Its not a problem with LMT's - thats for sure:

SQL> create table blah ( x number) tablespace users
storage ( minextents 1000 );

Table created.

SQL> select count(*) from dba_extents where
segment_name = 'BLAH';

  COUNT(*)
--
  1000

SQL> set timing on
SQL> drop table blah;

Table dropped.

Elapsed: 00:00:00.08

 --- [EMAIL PROTECTED] wrote: > Why is that?
 And would that only count for an
> object in a dictionary
> managed tablespace?  Would the time/speed it takes
> for drops and truncates
> really matter as far as performance is concerned?
> What I mean is who would
> set storage specs for objects with the speed it
> takes for truncates and
> drops of that object in mind?  It would seem to me
> that if an object is
> getting dropped or truncated that often that speed
> should be an issue, there
> are bigger problems at hand. Guru's correct me if
> I'm wrong please. Later,
> Ivan 
> 
> -Original Message-
> Sent: Tuesday, October 02, 2001 3:56 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Any DDL like drop table and truncate table
> definately take longer with 
> 10,000 extents than 1 extent. Try it. There was a
> test result 1 year back by
> 
> a list member on that.
> 
> Regards
> 
> MOHAMMAD RAFIQ
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Date: Tue, 02 Oct 2001 07:55:28 -0800
> 
> That is completely a myth.  There is no notable
> performance different with a
> table with 10,000 extents and one with 1.
> 
> The only problem is when it comes to the bitmaps
> when dealing with LMT and
> cluster when dealing with dictionary managed.  When
> you query the extent
> views, or do space management type processes.
> 
> "Do not criticize someone until you walked a mile in
> their shoes, that way
> when you criticize them, you are a mile a way and
> have their shoes."
> 
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
> 
> 
> 
> -Original Message-
> Sent: Monday, October 01, 2001 7:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> May be it is good practice to keep number of extents
> to be less than 50, no
> matter what the size of extent.
> 
> 
> 
> -Original Message-
> Sent: Monday, October 01, 2001 3:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello,
> 
> I'll do an reorganization of a database (about 140
> gigs). Some people say
> that it'd be good to use 128K, 4M and 128M extents.
> I saw somewhere it'd be
> 160K, 4M and 160M. Which size do you advice me ? I
> have also many small
> indexes (less than 16K).
> 
> Regards,
> 
> Thanh-truc Nguyen
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Thanh-truc Nguyen
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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.com
> --
> Author: Wong, Bing
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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.com
> --
> Author: Christopher Spence
>INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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).
> 
> 
>
_
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
> 
> -- 
> Please see the official 

RE: Extents size.

[Holman, Rodney]

Think of something like a temporary load table.  If you have a large load
process that is generating thousands of extents the clearing of the temp
table before the loads will kill you.  During the truncate or delete SMON
clears all the extent info out of SYS.UET$ and adds them to SYS.FET$.  With
very large numbers of extents this time is considerable.  We once had a
temporary tablespace that was created as permanent.  When we went to drop
that tablespace (8GB) and change it to temporary it took us about 18 hours.
The whole system hung up while SMON was working.

For a load table, like mentioned in my first line, you would want to create
it as large as you calculate the load to be and then make it one huge
extent.  Truncating before the load will be significantly faster.

Rodd Holman

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/2/01 4:15 PM

Why is that?  And would that only count for an object in a dictionary
managed tablespace?  Would the time/speed it takes for drops and
truncates really matter as far as performance is concerned? What I mean
is who would set storage specs for objects with the speed it takes for
truncates and drops of that object in mind?  It would seem to me that if
an object is getting dropped or truncated that often that speed should
be an issue, there are bigger problems at hand. Guru's correct me if I'm
wrong please. Later, Ivan 

-Original Message- 
 ] 
Sent: Tuesday, October 02, 2001 3:56 PM 
To: Multiple recipients of list ORACLE-L 


Any DDL like drop table and truncate table definately take longer with 
10,000 extents than 1 extent. Try it. There was a test result 1 year
back by 
a list member on that. 

Regards 

MOHAMMAD RAFIQ 



Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
Date: Tue, 02 Oct 2001 07:55:28 -0800 

That is completely a myth.  There is no notable performance different
with a 
table with 10,000 extents and one with 1. 

The only problem is when it comes to the bitmaps when dealing with LMT
and 
cluster when dealing with dictionary managed.  When you query the extent

views, or do space management type processes. 

"Do not criticize someone until you walked a mile in their shoes, that
way 
when you criticize them, you are a mile a way and have their shoes." 

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:(707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 



-Original Message- 
Sent: Monday, October 01, 2001 7:15 PM 
To: Multiple recipients of list ORACLE-L 

May be it is good practice to keep number of extents to be less than 50,
no 
matter what the size of extent. 



-Original Message- 
Sent: Monday, October 01, 2001 3:35 PM 
To: Multiple recipients of list ORACLE-L 


Hello, 

I'll do an reorganization of a database (about 140 gigs). Some people
say 
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd
be 
160K, 4M and 160M. Which size do you advice me ? I have also many small 
indexes (less than 16K). 

Regards, 

Thanh-truc Nguyen 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Thanh-truc Nguyen 
   INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
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.com
  
-- 
Author: Wong, Bing 
   INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
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.com
  
-- 
Author: Christopher Spence 
   INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

RE: Extents size.

[Mohammad Rafiq]

Further to my previous message, I am reproudcing an email of a list member 
on this subject. It is really interesting to read it..


Reply-To: Ferenc Mantfeld <[EMAIL PROTECTED]>
To: "oracle list" <[EMAIL PROTECTED]>
Date: Tue, 20 Jul 1999 16:25:15 -0500

Hi all

We know that Oracle often gives us enough rope to hang
ourselves with. In
Kevin Loney's presentation at IOUG this year, he brought up
an interesting
point about unlimited extents being one of the more
boneheaded idea Oracle
came up with, so I decided to conduct my own experiment :

Environment :
HP V2500, 16 CPU's running at 450 Mhz, 8 GB Ram, 2.5 GBPS
fiber channel port
connection, running Oracle 7.3.4.4 on HP-UX 11.0.
DB_BLOCK_SIZE=8192
In other words, one real kick-ass machine

One table :

1,2 million rows in a single extent of 120 MB.

Export this table.
Set timing on
Drop it : 3.5 seconds.

Recreate the table as follows :
Create table my_tab ( ..) storage (initial 16 k next 8 k
pctincrease 0
minextetns 1 maxextents 3 ) pctfree 5
tablespace my_own_persoanl_ts ;
Make a note of the datafile numbers for your tablespace, you
will need this
to determine how far you are from being done :

import your old table  (ignore=y, indexes=no), check your
alert log , when
you see :
  ORA-1631: max # extents 3 reached in table/cluster
DBA_USER.S_ORG_PROD
then ps_ef | grep -i imp
and kill the process.

Now you have a 30,000 extent table.
First turn on tracing for tkprof :
SQL > alter session set sql_trace true ;
session altered
SQL >

Now drop the table :
SBPRD-DBA_USER> drop table s_org_prod;

table dropped
Elapsed: 01:53:42.89

SQL >

In the meantime, from another session, logged in as SYS
You know that this is the only table that lives in your
particular datafile
, so :
SQL > select count (*) from uet$ where file#=5 ;

   COUNT(*)
--
  26638
SBPRD-DBA_USER> /

   COUNT(*)
--
  26254

(so you can see the allocated user extent table decreasing).

Bottom line is that from the recursive DML being done on uet$
and fet$, the
process has slowed down from 3.5 seconds to almost two hours,
and we are not
talking a Mickey Mouse machine here.

Just another reminder that good database design ALWAYS pays
off, and we are
to look at new "benefits" that the rdbms offers us, with
optimistic
skepticism .

Hope this benchmark is of use to someone out there. If you
like, I can mail
the output result of the tkprof (sys=yes) to you.

Regards :

Ferenc Mantfeld
Oracle DBA




MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:15:30 -0800

Why is that?  And would that only count for an object in a dictionary
managed tablespace?  Would the time/speed it takes for drops and truncates
really matter as far as performance is concerned? What I mean is who would
set storage specs for objects with the speed it takes for truncates and
drops of that object in mind?  It would seem to me that if an object is
getting dropped or truncated that often that speed should be an issue, there
are bigger problems at hand. Guru's correct me if I'm wrong please. Later,
Ivan

-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, Cal

Re: Extents size.

[Connor McDonald]

You could probably mount a argument about more than
505 extents (for an 8k block) not being able to fit in
the segment header block - but unless you're
clobbering dba_extents and the like with queries, I
doubt you'd ever see a difference.

hth
connor

 --- Steve Smith <[EMAIL PROTECTED]> wrote: > Yea - I keep
hearing and seeing tests that show that
> the number of extents
> had no bearing on performance (up to a point).  It
> just 'bothers' me to see
> a 500 or 1200 or 2000 extents on a table.. 
> 
> Here is a question - is there any situation that
> having only 1 big extent
> would reduce performance?
> 
> Steve
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, October 02, 2001 10:30 AM
> 
> 
> > well, only when you are deleting massive amounts
> of data or truncating
> > with drop storage.. then there is an impact
> because of the hits on the
> > dictionary tables.
> >
> > but basically yes... I've been told by various
> Oracle employees that up
> > to 4096 extents cause no problem whatsoever.
> >
> >
> > --- Christopher Spence <[EMAIL PROTECTED]>
> wrote:
> > > That is completely a myth.  There is no notable
> performance different
> > > with a
> > > table with 10,000 extents and one with 1.
> > >
> > > The only problem is when it comes to the bitmaps
> when dealing with
> > > LMT and
> > > cluster when dealing with dictionary managed. 
> When you query the
> > > extent
> > > views, or do space management type processes.
> > >
> > > "Do not criticize someone until you walked a
> mile in their shoes,
> > > that way
> > > when you criticize them, you are a mile a way
> and have their shoes."
> > >
> > > Christopher R. Spence
> > > Oracle DBA
> > > Phone: (978) 322-5744
> > > Fax:(707) 885-2275
> > >
> > > Fuelspot
> > > 73 Princeton Street
> > > North, Chelmsford 01863
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 7:15 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > May be it is good practice to keep number of
> extents to be less than
> > > 50, no
> > > matter what the size of extent.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Monday, October 01, 2001 3:35 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hello,
> > >
> > > I'll do an reorganization of a database (about
> 140 gigs). Some people
> > > say
> > > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > > it'd be
> > > 160K, 4M and 160M. Which size do you advice me ?
> I have also many
> > > small
> > > indexes (less than 16K).
> > >
> > > Regards,
> > >
> > > Thanh-truc Nguyen
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: Thanh-truc Nguyen
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> access / Mailing
> > > Lists
> > >
>

> > > 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.com
> > > --
> > > Author: Wong, Bing
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> access / Mailing
> > > Lists
> > >
>

> > > 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.com
> > > --
> > > Author: Christopher Spence
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> access / Mailing
> > > Lists
> > >
>

> > > 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).
> >
> >
> > __

RE: Extents size.

[Mohammad Rafiq]

Thanks.You are right

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 13:10:30 -0800

Yes, that is very true.  That is why I mentioned the performance will be
noticeable at times when dealing with the extent bitmaps for LMT and the
dictionary for dictionary managed, wither it be ad-hoc or recursive sql.

Unless your doing a lot of truncates or drops, I would bear performance
changes on DML and not DDL.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L

Any DDL like drop table and truncate table definately take longer with
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BOD

RE: Extents size.

[Connor McDonald]

True - but we're all using LMT's now anyway aren't we
?

:-)

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> well, only when you are deleting massive amounts of
> data or truncating
> with drop storage.. then there is an impact because
> of the hits on the
> dictionary tables.
> 
> but basically yes... I've been told by various
> Oracle employees that up
> to 4096 extents cause no problem whatsoever.
> 
> 
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable
> performance different
> > with a
> > table with 10,000 extents and one with 1. 
> > 
> > The only problem is when it comes to the bitmaps
> when dealing with
> > LMT and
> > cluster when dealing with dictionary managed. 
> When you query the
> > extent
> > views, or do space management type processes.
> > 
> > "Do not criticize someone until you walked a mile
> in their shoes,
> > that way
> > when you criticize them, you are a mile a way and
> have their shoes."
> > 
> > Christopher R. Spence 
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> > 
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >  
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > May be it is good practice to keep number of
> extents to be less than
> > 50, no
> > matter what the size of extent.
> > 
> > 
> > 
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello,
> > 
> > I'll do an reorganization of a database (about 140
> gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M
> extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I
> have also many
> > small
> > indexes (less than 16K).
> > 
> > Regards,
> > 
> > Thanh-truc Nguyen
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > -- 
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Wong, Bing
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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.com
> > -- 
> > Author: Christopher Spence
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing
> > Lists
> >
>

> > 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).
> 
> 
> __
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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
http://

RE: Extents size.

[Ivan_Rivera]

Title: RE: Extents size.





Why is that?  And would that only count for an object in a dictionary managed tablespace?  Would the time/speed it takes for drops and truncates really matter as far as performance is concerned? What I mean is who would set storage specs for objects with the speed it takes for truncates and drops of that object in mind?  It would seem to me that if an object is getting dropped or truncated that often that speed should be an issue, there are bigger problems at hand. Guru's correct me if I'm wrong please. Later, Ivan 

-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Extents size.



Any DDL like drop table and truncate table definately take longer with 
10,000 extents than 1 extent. Try it. There was a test result 1 year back by 
a list member on that.


Regards


MOHAMMAD RAFIQ




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800


That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.


The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L


May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.




-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L



Hello,


I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).


Regards,


Thanh-truc Nguyen


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
   INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
   INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
--
Author: Christopher Spence
   INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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).



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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 ORACL

RE: Extents size.

[Christopher Spence]

Yes, that is very true.  That is why I mentioned the performance will be
noticeable at times when dealing with the extent bitmaps for LMT and the
dictionary for dictionary managed, wither it be ad-hoc or recursive sql.

Unless your doing a lot of truncates or drops, I would bear performance
changes on DML and not DDL.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L

Any DDL like drop table and truncate table definately take longer with 
10,000 extents than 1 extent. Try it. There was a test result 1 year back by

a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Christopher Spence
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 sub

RE: Extents size.

[Mohammad Rafiq]

Any DDL like drop table and truncate table definately take longer with 
10,000 extents than 1 extent. Try it. There was a test result 1 year back by 
a list member on that.

Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 02 Oct 2001 07:55:28 -0800

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1.

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Christopher Spence
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: Extents size.

[Jared . Still]

Yes.  If you need to do parallel query, multiple
extents may help you out a bit.

Jared




   
 
"Steve Smith"  
 
<[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
>cc:   
 
Sent by:     Subject: Re: Extents size.
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
10/02/01 10:37 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Yea - I keep hearing and seeing tests that show that the number of extents
had no bearing on performance (up to a point).  It just 'bothers' me to see
a 500 or 1200 or 2000 extents on a table.. 

Here is a question - is there any situation that having only 1 big extent
would reduce performance?

Steve

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 10:30 AM


> well, only when you are deleting massive amounts of data or truncating
> with drop storage.. then there is an impact because of the hits on the
> dictionary tables.
>
> but basically yes... I've been told by various Oracle employees that up
> to 4096 extents cause no problem whatsoever.
>
>
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable performance different
> > with a
> > table with 10,000 extents and one with 1.
> >
> > The only problem is when it comes to the bitmaps when dealing with
> > LMT and
> > cluster when dealing with dictionary managed.  When you query the
> > extent
> > views, or do space management type processes.
> >
> > "Do not criticize someone until you walked a mile in their shoes,
> > that way
> > when you criticize them, you are a mile a way and have their shoes."
> >
> > Christopher R. Spence
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> >
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >
> >
> >
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > May be it is good practice to keep number of extents to be less than
> > 50, no
> > matter what the size of extent.
> >
> >
> >
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello,
> >
> > I'll do an reorganization of a database (about 140 gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I have also many
> > small
> > indexes (less than 16K).
> >
> > Regards,
> >
> > Thanh-truc Nguyen
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail

Re: Extents size.

[Steve Smith]

Yea - I keep hearing and seeing tests that show that the number of extents
had no bearing on performance (up to a point).  It just 'bothers' me to see
a 500 or 1200 or 2000 extents on a table.. 

Here is a question - is there any situation that having only 1 big extent
would reduce performance?

Steve

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 10:30 AM


> well, only when you are deleting massive amounts of data or truncating
> with drop storage.. then there is an impact because of the hits on the
> dictionary tables.
>
> but basically yes... I've been told by various Oracle employees that up
> to 4096 extents cause no problem whatsoever.
>
>
> --- Christopher Spence <[EMAIL PROTECTED]> wrote:
> > That is completely a myth.  There is no notable performance different
> > with a
> > table with 10,000 extents and one with 1.
> >
> > The only problem is when it comes to the bitmaps when dealing with
> > LMT and
> > cluster when dealing with dictionary managed.  When you query the
> > extent
> > views, or do space management type processes.
> >
> > "Do not criticize someone until you walked a mile in their shoes,
> > that way
> > when you criticize them, you are a mile a way and have their shoes."
> >
> > Christopher R. Spence
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> >
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> >
> >
> >
> > -Original Message-
> > Sent: Monday, October 01, 2001 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > May be it is good practice to keep number of extents to be less than
> > 50, no
> > matter what the size of extent.
> >
> >
> >
> > -Original Message-
> > Sent: Monday, October 01, 2001 3:35 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello,
> >
> > I'll do an reorganization of a database (about 140 gigs). Some people
> > say
> > that it'd be good to use 128K, 4M and 128M extents. I saw somewhere
> > it'd be
> > 160K, 4M and 160M. Which size do you advice me ? I have also many
> > small
> > indexes (less than 16K).
> >
> > Regards,
> >
> > Thanh-truc Nguyen
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Thanh-truc Nguyen
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > 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.com
> > --
> > Author: Wong, Bing
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > 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.com
> > --
> > Author: Christopher Spence
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > 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).
>
>
> __
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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 con

RE: Extents size.

[Rachel Carmichael]

well, only when you are deleting massive amounts of data or truncating
with drop storage.. then there is an impact because of the hits on the
dictionary tables.

but basically yes... I've been told by various Oracle employees that up
to 4096 extents cause no problem whatsoever.


--- Christopher Spence <[EMAIL PROTECTED]> wrote:
> That is completely a myth.  There is no notable performance different
> with a
> table with 10,000 extents and one with 1. 
> 
> The only problem is when it comes to the bitmaps when dealing with
> LMT and
> cluster when dealing with dictionary managed.  When you query the
> extent
> views, or do space management type processes.
> 
> "Do not criticize someone until you walked a mile in their shoes,
> that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> -Original Message-
> Sent: Monday, October 01, 2001 7:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> May be it is good practice to keep number of extents to be less than
> 50, no
> matter what the size of extent.
> 
> 
> 
> -Original Message-
> Sent: Monday, October 01, 2001 3:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello,
> 
> I'll do an reorganization of a database (about 140 gigs). Some people
> say
> that it'd be good to use 128K, 4M and 128M extents. I saw somewhere
> it'd be
> 160K, 4M and 160M. Which size do you advice me ? I have also many
> small
> indexes (less than 16K).
> 
> Regards,
> 
> Thanh-truc Nguyen
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thanh-truc Nguyen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Wong, Bing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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).


__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[Christopher Spence]

That is completely a myth.  There is no notable performance different with a
table with 10,000 extents and one with 1. 

The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed.  When you query the extent
views, or do space management type processes.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, October 01, 2001 7:15 PM
To: Multiple recipients of list ORACLE-L

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thanh-truc Nguyen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Re: Extents size.

[Jared Still]

Ramon,

Why use an extent size of 5.16 meg when you are 
already using 4 meg?

Jared

On Tuesday 02 October 2001 07:40, Ramon Estevez wrote:
> I did the same reorganization two weeks ago, not the same amount of data,
> but
> I used 128k for index tablespaces, 4m for the most activity TS (Sales) and
> 5160k for the others.
>
> I am very, very, very happy with the performance.
>
>
> I read two articles that some folks from the list sent me.
>
> Good luck!!!
>
> Ramon E. Estevez
> [EMAIL PROTECTED] 
> 809-565-3121
>
>
> -Mensaje original-
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Thanh-truc
> Nguyen
> Enviado el: Monday, 01 October, 2001 5:35 PM
> Para: Multiple recipients of list ORACLE-L
> Asunto: Extents size.
>
>
> Hello,
>
> I'll do an reorganization of a database (about 140 gigs). Some people say
> that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
> 160K, 4M and 160M. Which size do you advice me ? I have also many small
> indexes (less than 16K).
>
> Regards,
>
> Thanh-truc Nguyen
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Thanh-truc Nguyen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[Ramon Estevez]

I did the same reorganization two weeks ago, not the same amount of data,
but
I used 128k for index tablespaces, 4m for the most activity TS (Sales) and
5160k for the others.

I am very, very, very happy with the performance.


I read two articles that some folks from the list sent me.

Good luck!!!

Ramon E. Estevez
[EMAIL PROTECTED] 
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Thanh-truc
Nguyen
Enviado el: Monday, 01 October, 2001 5:35 PM
Para: Multiple recipients of list ORACLE-L
Asunto: Extents size.


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Ramon Estevez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[Jared . Still]

Why?




   

"Wong, Bing"   


Micro.com>  cc:

Sent by:Subject:     RE: Extents size. 

[EMAIL PROTECTED]   

   

   

10/01/01 04:15 PM  

Please respond to  

ORACLE-L   

   

   





May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thanh-truc Nguyen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[Wong, Bing]

May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.



-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thanh-truc Nguyen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[DENNIS WILLIAMS]

Thanh - I believe the 128k / 4m / 128m comes from the paper "Stop
defragmenting and start living" (I hope I am recalling the name of the
article correctly), which is posted on Oracle's Web site. It references the
fact that it bases those sizes on Oracle8i, and mentions that Oracle is
recommending the 160k / 4m / 160m for Oracle9i. 
Anyway, I would advise you to locate that paper and read it
carefully before laying out your new reorganization. Better to clear up any
misconceptions now. I don't think the exact sizes you pick are as important
as understanding and  following the philosopy. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]




-Original Message-
Sent: Monday, October 01, 2001 5:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thanh-truc Nguyen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Extents size.

[DENNIS WILLIAMS]

"How to Stop Defragmenting and Start Living" can be found at:
http://technet.oracle.com/deploy/availability/pdf/defrag.pdf

-Original Message-
Sent: Monday, October 01, 2001 5:35 PM
To: Multiple recipients of list ORACLE-L


Hello,

I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).

Regards,

Thanh-truc Nguyen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thanh-truc Nguyen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).