Re: Extents size.

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