Re: Extents - Reducing Number Of

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 02 Dec 2000 11:52:41 GMT
Message-ID: <3a28e0af.3187009@news-server>

On Sat, 02 Dec 2000 10:57:03 GMT, sboucher_at_my-deja.com wrote:

>Is Export/Import the only or preferred method for reducing the number
>of extents. I think in mainfrmae DB2 there is a utility called reorg
>and I was wondering if oracle had something similar to create fewer but
>larger extent sizes.
>

ORACLE doesn't. But I think there are third party utils that do that. TSReorg was one of them,, IIRC. But large number of extents is not the problem it used to be at all since 8.0. And it wasn't before that either, provided database was tuned correctly.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Dec 02 2000 - 05:52:41 CST