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
- Ivan_Rivera_at_doh.state.fl.us 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: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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: truc_at_nguyen.as
>
> 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: ListGuru_at_fatcity.com (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: bing.wong_at_IngramMicro.com
>
> 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: ListGuru_at_fatcity.com (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: cspence_at_FuelSpot.com
>
> 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: ListGuru_at_fatcity.com (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: rafiq9857_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Tue Oct 02 2001 - 15:58:35 CDT
