Re: extents question on LMT

[Jared . Still]

1) No, you can't compress into a single extent if the TBS is
LMT with uniform extent size, and the size of the index is 
> extent size.  Don't know about auto extent size feature.

2)  Why would you want to compress into a single extent?
There's no benefit to doing so.

Jared






"Guang Mei" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/28/2003 12:06 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:extents question on LMT


Hi:

Oracle 8173 on Sun 2.8.

When we had tablespace created as DMT, I used to occuasionally find all 
indexes in a schema which have multiple extents and run a script to 
compress 
each of them into one single extent (maybe this is not necessary, but 
that's 
another topic). But I find lately that with LMT, I can not simply do that. 

Oracle will decide how many extents it allocates depending on the storage 
parameters I pass in:

ALTER INDEX  ID_IG_PK REBUILD TABLESPACE INDEXES STORAGE (INITIAL 5M NEXT 
5M 
pctincrease 0) nologging;

Does this mean I just can not "compress" some large index into a single 
extent in a LMT?

Example:

SQL> ALTER INDEX MT.ID_IG_PK REBUILD TABLESPACE INDEXES STORAGE (INITIAL 
50K 
NEXT 50K pctincrease 0) nologging;

Index altered.

SQL>  select BYTES,EXTENTS,blocks, INITIAL_EXTENT,NEXT_EXTENT
  2   from dba_segments where owner='MT' and segment_name='ID_IG_PK';

 BYTESEXTENTS BLOCKS INITIAL_EXTENT NEXT_EXTENT
-- -- -- -- ---
516096  1 63  57344  516096


SQL> ALTER INDEX MT.ID_IG_PK REBUILD TABLESPACE INDEXES STORAGE (INITIAL 
5M 
NEXT 5M  pctincrease 0) nologging;

Index altered.

SQL> select BYTES,EXTENTS,blocks, INITIAL_EXTENT,NEXT_EXTENT
  2  from dba_segments where owner='MT' and segment_name='ID_IG_PK';

 BYTESEXTENTS BLOCKS INITIAL_EXTENT NEXT_EXTENT
-- -- -- -- ---
   5677056 116935242880  516096

TIA.

Guang


_
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail

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

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




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

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

Re: extents allocation in parallel load

[Gurelei]

Tim,

Thanks for all your help. I will check the
LAST_DDL_TIME field (although I didn't know what
INITIAL parameter can be modified) and will let you
know if something comes out of it.

Gene
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> Well!  I'm out of ideas.  The only other thing I can
> think of is a recent
> ALTER TABLE which changed the INITIAL on the table
> since the load, but
> that's grasping (gasping?).  Still, could you look
> at LAST_DDL_TIME on
> DBA_OBJECTS for the table, just to grasp that last
> straw?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, May 15, 2002 8:13 AM
> 
> 
> > Tim,
> >
> > The tablespace is dictionary managed.
> > --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > I was hoping to see "*" column values from
> > DBA_TABLESPACES, not just
> > the
> > "default storage" column values.  This would show
> > whether the
> > tablespace in
> > question was locally-managed (and SYSTEM or
> UNIFORM,
> > if so) as well...
> >
> >
> > __
> > Do You Yahoo!?
> > LAUNCH - Your Yahoo! Music Experience
> > http://launch.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Gurelei
> >   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: Tim Gorman
>   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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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 allocation in parallel load

[Tim Gorman]

Well!  I'm out of ideas.  The only other thing I can think of is a recent
ALTER TABLE which changed the INITIAL on the table since the load, but
that's grasping (gasping?).  Still, could you look at LAST_DDL_TIME on
DBA_OBJECTS for the table, just to grasp that last straw?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 15, 2002 8:13 AM


> Tim,
>
> The tablespace is dictionary managed.
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> I was hoping to see "*" column values from
> DBA_TABLESPACES, not just
> the
> "default storage" column values.  This would show
> whether the
> tablespace in
> question was locally-managed (and SYSTEM or UNIFORM,
> if so) as well...
>
>
> __
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gurelei
>   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: Tim Gorman
  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 allocation in parallel load

[Gurelei]

Tim,

The tablespace is dictionary managed.
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
I was hoping to see "*" column values from
DBA_TABLESPACES, not just 
the
"default storage" column values.  This would show
whether the 
tablespace in
question was locally-managed (and SYSTEM or UNIFORM,
if so) as well...


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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 allocation in parallel load

[Tim Gorman]

I was hoping to see "*" column values from DBA_TABLESPACES, not just the
"default storage" column values.  This would show whether the tablespace in
question was locally-managed (and SYSTEM or UNIFORM, if so) as well...

You don't need to include the temporary tablespace -- it's not relevant.
TEMPORARY segments can be created in any tablespace, especially during
direct-path operations...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 3:18 PM


> Tim,
>
> SQL> select TABLESPACE_NAME, INITIAL_EXTENT/1024,
> NEXT_EXTENT/1024, PCT_INCREASE
>   2  from dba_tablespaces
>   3  where tablespace_name like 'TEMP%'
>   4  or tablespace_name = 'TREPD01';
>
> TABLESPACE_NAMEINITIAL_EXTENT/1024
> NEXT_EXTENT/1024 PCT_INCREASE
> -- ---
>  
> TREPD01 40
>   400
> TEMP011024
> 10240
>
> TREPD01 is where the tables are located, TTEMP01 is
> the temp tablespace.
>
> Gene
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > What does "SELECT * FROM DBA_TABLESPACES" show for
> > the tablespace involved?
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 14, 2002 12:53 PM
> >
> >
> > > Tim,
> > >
> > > Thanks for the explanation. The table I'm looking
> > at
> > > has an initial size 32K while the new extents are
> > all
> > > 16K. Why would this happen?
> > >
> > > thanks
> > >
> > > Gene
> > > --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > > > SQL*Loader in direct-parallel mode (i.e.
> > > > DIRECT=TRUE, PARALLEL=TRUE) first
> > > > loads into a TEMPORARY segment.  After the load
> > > > completes, then the
> > > > TEMPORARY segment is "merged" with the table
> > > > segment.  All of the "direct"
> > > > (a.k.a. "append") operations work this way when
> > > > executed in parallel (i.e.
> > > > INSERT /*+ APPEND PARALLEL */, CREATE INDEX ...
> > > > PARALLEL, CREATE TABLE ...
> > > > PARALLEL ... AS SELECT, etc)...
> > > >
> > > > Only SQL*Loader's direct-nonparallel mode (i.e.
> > > > DIRECT=TRUE, PARALLEL=FALSE)
> > > > loads into space on the table segment above the
> > > > current "high-water mark".
> > > > That expected scenario is probably the reason
> > why
> > > > you expect all new extents
> > > > to be sized according to NEXT...
> > > >
> > > > So, the newly added extents were probably
> > "INITIAL"
> > > > extents for the original
> > > > TEMPORARY segments, before they were merged into
> > the
> > > > table segment, perhaps?
> > > >
> > > > - Original Message -
> > > > To: "Multiple recipients of list ORACLE-L"
> > > > <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, May 14, 2002 10:33 AM
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > > I'm confused by the way some of my extents are
> > > > > allocated in Oracle. I've talked to Oracle
> > reps, I
> > > > > thing I've posted here before and jsut when I
> > > > thought
> > > > > I got an understanring - ooops, everything is
> > > > gone. So
> > > > > I'll give it another try. I have a table with
> > > > initial
> > > > > set to 32K and next set to 1M. This table is
> > being
> > > > > loaded on a daily basis via Ab initio. The
> > load is
> > > > > done by SQL*loader in direct mode in parallel
> > (I
> > > > > believe it is 8 ways). Now all the segments
> > that
> > > > have
> > > > > been created for this table (besides the 1st
> > one)
> > > > are
> > > > > 16K. Where does this size come from? I thought
> > it
> > > > > should use the NEXT parameter for the new
> > extents,
> > > > but
> > > > > it doesn't. Can someone give me some pointers?
> > > > >
> > > > > thanks
> > > > >
> > > > > Gene
> > > > >
> > > > >
> > __
> > > > > Do You Yahoo!?
> > > > > LAUNCH - Your Yahoo! Music Experience
> > > > > http://launch.yahoo.com
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > --
> > > > > Author: Gurelei
> > > > >   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:
> >

Re: extents allocation in parallel load

[Gurelei]

Tim, 

SQL> select TABLESPACE_NAME, INITIAL_EXTENT/1024,
NEXT_EXTENT/1024, PCT_INCREASE
  2  from dba_tablespaces
  3  where tablespace_name like 'TEMP%'
  4  or tablespace_name = 'TREPD01';

TABLESPACE_NAMEINITIAL_EXTENT/1024
NEXT_EXTENT/1024 PCT_INCREASE
-- ---
 
TREPD01 40
  400
TEMP011024
10240

TREPD01 is where the tables are located, TTEMP01 is
the temp tablespace.

Gene
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> What does "SELECT * FROM DBA_TABLESPACES" show for
> the tablespace involved?
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, May 14, 2002 12:53 PM
> 
> 
> > Tim,
> > 
> > Thanks for the explanation. The table I'm looking
> at
> > has an initial size 32K while the new extents are
> all
> > 16K. Why would this happen?
> > 
> > thanks
> > 
> > Gene
> > --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > > SQL*Loader in direct-parallel mode (i.e.
> > > DIRECT=TRUE, PARALLEL=TRUE) first
> > > loads into a TEMPORARY segment.  After the load
> > > completes, then the
> > > TEMPORARY segment is "merged" with the table
> > > segment.  All of the "direct"
> > > (a.k.a. "append") operations work this way when
> > > executed in parallel (i.e.
> > > INSERT /*+ APPEND PARALLEL */, CREATE INDEX ...
> > > PARALLEL, CREATE TABLE ...
> > > PARALLEL ... AS SELECT, etc)...
> > > 
> > > Only SQL*Loader's direct-nonparallel mode (i.e.
> > > DIRECT=TRUE, PARALLEL=FALSE)
> > > loads into space on the table segment above the
> > > current "high-water mark".
> > > That expected scenario is probably the reason
> why
> > > you expect all new extents
> > > to be sized according to NEXT...
> > > 
> > > So, the newly added extents were probably
> "INITIAL"
> > > extents for the original
> > > TEMPORARY segments, before they were merged into
> the
> > > table segment, perhaps?
> > > 
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L"
> > > <[EMAIL PROTECTED]>
> > > Sent: Tuesday, May 14, 2002 10:33 AM
> > > 
> > > 
> > > > Hi,
> > > >
> > > > I'm confused by the way some of my extents are
> > > > allocated in Oracle. I've talked to Oracle
> reps, I
> > > > thing I've posted here before and jsut when I
> > > thought
> > > > I got an understanring - ooops, everything is
> > > gone. So
> > > > I'll give it another try. I have a table with
> > > initial
> > > > set to 32K and next set to 1M. This table is
> being
> > > > loaded on a daily basis via Ab initio. The
> load is
> > > > done by SQL*loader in direct mode in parallel
> (I
> > > > believe it is 8 ways). Now all the segments
> that
> > > have
> > > > been created for this table (besides the 1st
> one)
> > > are
> > > > 16K. Where does this size come from? I thought
> it
> > > > should use the NEXT parameter for the new
> extents,
> > > but
> > > > it doesn't. Can someone give me some pointers?
> > > >
> > > > thanks
> > > >
> > > > Gene
> > > >
> > > >
> __
> > > > Do You Yahoo!?
> > > > LAUNCH - Your Yahoo! Music Experience
> > > > http://launch.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: Gurelei
> > > >   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: Tim Gorman
> > >   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 allocation in parallel load

[Tim Gorman]

What does "SELECT * FROM DBA_TABLESPACES" show for the tablespace involved?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 12:53 PM


> Tim,
> 
> Thanks for the explanation. The table I'm looking at
> has an initial size 32K while the new extents are all
> 16K. Why would this happen?
> 
> thanks
> 
> Gene
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > SQL*Loader in direct-parallel mode (i.e.
> > DIRECT=TRUE, PARALLEL=TRUE) first
> > loads into a TEMPORARY segment.  After the load
> > completes, then the
> > TEMPORARY segment is "merged" with the table
> > segment.  All of the "direct"
> > (a.k.a. "append") operations work this way when
> > executed in parallel (i.e.
> > INSERT /*+ APPEND PARALLEL */, CREATE INDEX ...
> > PARALLEL, CREATE TABLE ...
> > PARALLEL ... AS SELECT, etc)...
> > 
> > Only SQL*Loader's direct-nonparallel mode (i.e.
> > DIRECT=TRUE, PARALLEL=FALSE)
> > loads into space on the table segment above the
> > current "high-water mark".
> > That expected scenario is probably the reason why
> > you expect all new extents
> > to be sized according to NEXT...
> > 
> > So, the newly added extents were probably "INITIAL"
> > extents for the original
> > TEMPORARY segments, before they were merged into the
> > table segment, perhaps?
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 14, 2002 10:33 AM
> > 
> > 
> > > Hi,
> > >
> > > I'm confused by the way some of my extents are
> > > allocated in Oracle. I've talked to Oracle reps, I
> > > thing I've posted here before and jsut when I
> > thought
> > > I got an understanring - ooops, everything is
> > gone. So
> > > I'll give it another try. I have a table with
> > initial
> > > set to 32K and next set to 1M. This table is being
> > > loaded on a daily basis via Ab initio. The load is
> > > done by SQL*loader in direct mode in parallel (I
> > > believe it is 8 ways). Now all the segments that
> > have
> > > been created for this table (besides the 1st one)
> > are
> > > 16K. Where does this size come from? I thought it
> > > should use the NEXT parameter for the new extents,
> > but
> > > it doesn't. Can someone give me some pointers?
> > >
> > > thanks
> > >
> > > Gene
> > >
> > > __
> > > Do You Yahoo!?
> > > LAUNCH - Your Yahoo! Music Experience
> > > http://launch.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Gurelei
> > >   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: Tim Gorman
> >   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!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Gurelei
>   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: Tim Gorman
  INET: [EMAIL PROTECTED]

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

Re: extents allocation in parallel load

[Gurelei]

Tim,

Thanks for the explanation. The table I'm looking at
has an initial size 32K while the new extents are all
16K. Why would this happen?

thanks

Gene
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> SQL*Loader in direct-parallel mode (i.e.
> DIRECT=TRUE, PARALLEL=TRUE) first
> loads into a TEMPORARY segment.  After the load
> completes, then the
> TEMPORARY segment is "merged" with the table
> segment.  All of the "direct"
> (a.k.a. "append") operations work this way when
> executed in parallel (i.e.
> INSERT /*+ APPEND PARALLEL */, CREATE INDEX ...
> PARALLEL, CREATE TABLE ...
> PARALLEL ... AS SELECT, etc)...
> 
> Only SQL*Loader's direct-nonparallel mode (i.e.
> DIRECT=TRUE, PARALLEL=FALSE)
> loads into space on the table segment above the
> current "high-water mark".
> That expected scenario is probably the reason why
> you expect all new extents
> to be sized according to NEXT...
> 
> So, the newly added extents were probably "INITIAL"
> extents for the original
> TEMPORARY segments, before they were merged into the
> table segment, perhaps?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, May 14, 2002 10:33 AM
> 
> 
> > Hi,
> >
> > I'm confused by the way some of my extents are
> > allocated in Oracle. I've talked to Oracle reps, I
> > thing I've posted here before and jsut when I
> thought
> > I got an understanring - ooops, everything is
> gone. So
> > I'll give it another try. I have a table with
> initial
> > set to 32K and next set to 1M. This table is being
> > loaded on a daily basis via Ab initio. The load is
> > done by SQL*loader in direct mode in parallel (I
> > believe it is 8 ways). Now all the segments that
> have
> > been created for this table (besides the 1st one)
> are
> > 16K. Where does this size come from? I thought it
> > should use the NEXT parameter for the new extents,
> but
> > it doesn't. Can someone give me some pointers?
> >
> > thanks
> >
> > Gene
> >
> > __
> > Do You Yahoo!?
> > LAUNCH - Your Yahoo! Music Experience
> > http://launch.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Gurelei
> >   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: Tim Gorman
>   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!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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 allocation in parallel load

[Tim Gorman]

SQL*Loader in direct-parallel mode (i.e. DIRECT=TRUE, PARALLEL=TRUE) first
loads into a TEMPORARY segment.  After the load completes, then the
TEMPORARY segment is "merged" with the table segment.  All of the "direct"
(a.k.a. "append") operations work this way when executed in parallel (i.e.
INSERT /*+ APPEND PARALLEL */, CREATE INDEX ... PARALLEL, CREATE TABLE ...
PARALLEL ... AS SELECT, etc)...

Only SQL*Loader's direct-nonparallel mode (i.e. DIRECT=TRUE, PARALLEL=FALSE)
loads into space on the table segment above the current "high-water mark".
That expected scenario is probably the reason why you expect all new extents
to be sized according to NEXT...

So, the newly added extents were probably "INITIAL" extents for the original
TEMPORARY segments, before they were merged into the table segment, perhaps?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 10:33 AM


> Hi,
>
> I'm confused by the way some of my extents are
> allocated in Oracle. I've talked to Oracle reps, I
> thing I've posted here before and jsut when I thought
> I got an understanring - ooops, everything is gone. So
> I'll give it another try. I have a table with initial
> set to 32K and next set to 1M. This table is being
> loaded on a daily basis via Ab initio. The load is
> done by SQL*loader in direct mode in parallel (I
> believe it is 8 ways). Now all the segments that have
> been created for this table (besides the 1st one) are
> 16K. Where does this size come from? I thought it
> should use the NEXT parameter for the new extents, but
> it doesn't. Can someone give me some pointers?
>
> thanks
>
> Gene
>
> __
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gurelei
>   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: Tim Gorman
  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?

[Rachel Carmichael]

yowch! that tickles

--- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote:
> >-someone shoot me
> 
> Bang!!  As the dart with the suction cup firmly attaches to Rachel's
> forehead.
> 
> ;o)
> 
> -Original Message-
> Sent: Monday, March 04, 2002 8:23 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> sigh...
> 
> someone shoot me. I am spending WAY too much time being unemployed
> these days. 
> 
> extents are made up of blocks. 
> 
> now I'll shut up before I embarrass myself anymore :)
> 
> Rachel
> 
> 
> --- [EMAIL PROTECTED] wrote:
> > > and I was off as well, if your extent size is less than the
> > blocksize
> > > then you can have more than one extent in a block (divide the
> block
> > > size by the extent size and round DOWN)
> > 
> > Huh?
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > Rachel Carmichael <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 03/04/02 12:13 PM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:RE: EXTENTS?
> > 
> > 
> > nick, you're thinking segments not extents.
> > 
> > and I was off as well, if your extent size is less than the
> blocksize
> > then you can have more than one extent in a block (divide the block
> > size by the extent size and round DOWN)
> > 
> > in general though, extents are not usually sized as small as the
> > database block size
> > 
> > 
> > --- Nick Wagner <[EMAIL PROTECTED]> wrote:
> > > I'm going to say 1. I don't think you can have multiple tables in
> > the
> > > same
> > > DB block. 
> > > 
> > > -Original Message-
> > > Sent: Monday, March 04, 2002 10:19 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hi
> > > If DB block size is 8k then how many extents in one db block?
> > > Thanks
> > > -Seema
> > > 
> > > 
> > > 
> > > _
> > > Join the world's largest e-mail service with MSN Hotmail. 
> > > http://www.hotmail.com
> > > 
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > -- 
> > > Author: Seema Singh
> > >   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!?
> > Yahoo! Sports - sign up for Fantasy Baseball
> > http://sports.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).
> > 
> > 
> > 
> > -- 
> > 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
> >
> -

RE: EXTENTS?

[Farnsworth, Dave]

>-someone shoot me

Bang!!  As the dart with the suction cup firmly attaches to Rachel's forehead.

;o)

-Original Message-
Sent: Monday, March 04, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L


sigh...

someone shoot me. I am spending WAY too much time being unemployed
these days. 

extents are made up of blocks. 

now I'll shut up before I embarrass myself anymore :)

Rachel


--- [EMAIL PROTECTED] wrote:
> > and I was off as well, if your extent size is less than the
> blocksize
> > then you can have more than one extent in a block (divide the block
> > size by the extent size and round DOWN)
> 
> Huh?
> 
> Jared
> 
> 
> 
> 
> 
> Rachel Carmichael <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 03/04/02 12:13 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: EXTENTS?
> 
> 
> nick, you're thinking segments not extents.
> 
> and I was off as well, if your extent size is less than the blocksize
> then you can have more than one extent in a block (divide the block
> size by the extent size and round DOWN)
> 
> in general though, extents are not usually sized as small as the
> database block size
> 
> 
> --- Nick Wagner <[EMAIL PROTECTED]> wrote:
> > I'm going to say 1. I don't think you can have multiple tables in
> the
> > same
> > DB block. 
> > 
> > -Original Message-
> > Sent: Monday, March 04, 2002 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi
> > If DB block size is 8k then how many extents in one db block?
> > Thanks
> > -Seema
> > 
> > 
> > 
> > _
> > Join the world's largest e-mail service with MSN Hotmail. 
> > http://www.hotmail.com
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Seema Singh
> >   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!?
> Yahoo! Sports - sign up for Fantasy Baseball
> http://sports.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).
> 
> 
> 
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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

RE: EXTENTS?

[Rachel Carmichael]

sigh...

someone shoot me. I am spending WAY too much time being unemployed
these days. 

extents are made up of blocks. 

now I'll shut up before I embarrass myself anymore :)

Rachel


--- [EMAIL PROTECTED] wrote:
> > and I was off as well, if your extent size is less than the
> blocksize
> > then you can have more than one extent in a block (divide the block
> > size by the extent size and round DOWN)
> 
> Huh?
> 
> Jared
> 
> 
> 
> 
> 
> Rachel Carmichael <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 03/04/02 12:13 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: EXTENTS?
> 
> 
> nick, you're thinking segments not extents.
> 
> and I was off as well, if your extent size is less than the blocksize
> then you can have more than one extent in a block (divide the block
> size by the extent size and round DOWN)
> 
> in general though, extents are not usually sized as small as the
> database block size
> 
> 
> --- Nick Wagner <[EMAIL PROTECTED]> wrote:
> > I'm going to say 1. I don't think you can have multiple tables in
> the
> > same
> > DB block. 
> > 
> > -Original Message-
> > Sent: Monday, March 04, 2002 10:19 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi
> > If DB block size is 8k then how many extents in one db block?
> > Thanks
> > -Seema
> > 
> > 
> > 
> > _
> > Join the world's largest e-mail service with MSN Hotmail. 
> > http://www.hotmail.com
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Seema Singh
> >   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!?
> Yahoo! Sports - sign up for Fantasy Baseball
> http://sports.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).
> 
> 
> 
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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?

[Rachel Carmichael]

> you create the db (although I heard that different tablespaces can
> have
> different Db Block sizes in 9i - correct anybody?)

yep I've even tested it :)


--- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote:
> Seema,
> 
> You got it backwards.
> 
> If Db Block Size is 8k, and you create a table with it's initial
> extent of
> 32k, the you have 4 db blocks making up the extent.
> 
> An Extent is composed of one or more Db Blocks.  A Db Block is
> defined when
> you create the db (although I heard that different tablespaces can
> have
> different Db Block sizes in 9i - correct anybody?)
> 
> Hope this helps.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 1:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   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: Mercadante, Thomas F
>   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!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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?

[Jared . Still]

> and I was off as well, if your extent size is less than the blocksize
> then you can have more than one extent in a block (divide the block
> size by the extent size and round DOWN)

Huh?

Jared





Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 12:13 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
        Subject:RE: EXTENTS?


nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> I'm going to say 1. I don't think you can have multiple tables in the
> same
> DB block. 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   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!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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).



-- 
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?

[Jack C. Applewhite]

Yes, this one will get a lot of traffic, I'll bet.

I just looked in the 8.1.7 docs (SQL Reference - Storage Clause) and it says
that the minimum INITIAL is 2 DB blocks for non-bitmapped segments, 3 for
bitmapped segments.  The minimum for NEXT is 1 DB block.

Unlesss it's a new 9i feature, a DB block can belong to one and only one
Extent.

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: Monday, March 04, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L



I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.

Raj




-- 
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?

[Rajesh . Rao]

I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.

Raj




   
 
Rachel 
 
Carmichael   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
   Subject:     RE: EXTENTS? 
 
Sent by:   
 
root@fatcity.  
 
com
 
   
 
   
 
March 04,  
 
2002 03:13 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> I'm going to say 1. I don't think you can have multiple tables in the
> same
> DB block.
>
> -Original Message-
> Sent: Monday, March 04, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
>
>
>
> _
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   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!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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).




-- 
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?

[bill thater]

[EMAIL PROTECTED] wrote:

>
>
>in general though, extents are not usually sized as small as the
>database block size
>
should extents be multiples of block size?


-- 
--
Bill "Shrek" Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

God is real, unless declared integer.






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  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?

[Rachel Carmichael]

nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner <[EMAIL PROTECTED]> wrote:
> I'm going to say 1. I don't think you can have multiple tables in the
> same
> DB block.  
> 
> -Original Message-
> Sent: Monday, March 04, 2002 10:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   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!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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?

[Mercadante, Thomas F]

Seema,

You got it backwards.

If Db Block Size is 8k, and you create a table with it's initial extent of
32k, the you have 4 db blocks making up the extent.

An Extent is composed of one or more Db Blocks.  A Db Block is defined when
you create the db (although I heard that different tablespaces can have
different Db Block sizes in 9i - correct anybody?)

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Mercadante, Thomas F
  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?

[Rahul Dandekar]

Isn't the minimum extent size something like 5 times the DB_BLOCK_SIZE?

If that's true then maximum .2 extents in DB block.

Or you are looking for this info?

   db_block_size  Max Extents 
   -- --- 
2K121 
4K249 
8K505 
   16K   1017 
   32K   2041


+Rahul

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:28 PM


> Depends on your extent size 
> 
> -Original Message-
> Sent: Monday, March 04, 2002 12:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
>   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: Kevin Lange
>   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: Rahul Dandekar
  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?

[Godlewski, Melissa]

Title: RE: EXTENTS?





The Server Concepts manual Chapter on Data Blocks, Extents, and Segments would be a helpful Chapter to read.


-Original Message-
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: EXTENTS?



Depends on your extent size    


-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Kevin Lange
  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?

[Jared . Still]

None.

The lowest level of granularity of storage in Oracle is a block.

block->extent->segment

Time to hit the books, the Concepts manual in this case.

Jared






"Seema Singh" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 10:18 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:EXTENTS?


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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?

[Nick Wagner]

Title: RE: EXTENTS?





I'm going to say 1. I don't think you can have multiple tables in the same DB block.  


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: EXTENTS?



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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?

[Rachel Carmichael]

you have it backwards... extents don't fit into blocks, blocks fit into
extents

and extent size is dependent on tablespace storage parameters and
objectg storage parameters


--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
> -Seema
> 
> 
> 
> _
> Join the world’s largest e-mail service with MSN Hotmail. 
> http://www.hotmail.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Seema Singh
>   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!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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?

[Kevin Lange]

Depends on your extent size    

-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Kevin Lange
  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?

[Igor Neyman]

Depends on the size of the extent.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:18 PM


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: Igor Neyman
  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?

[Nelson Flores]

Title: RE: EXTENTS?





it´s the other way around... how many db blocks in an extent.
an extent is a number of contiguous data blocks ...



-Mensaje original-
De: Seema Singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 04 de Marzo de 2002 15:19
Para: Multiple recipients of list ORACLE-L
Asunto: EXTENTS?



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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.

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