Re: DB takes forever to load

From: Howard J. Rogers <howardjr_at_iprimus.com>
Date: Sat, 2 Sep 2000 18:44:37 +1100
Message-ID: <39b0afa7@news.iprimus.com.au>

"wegorz" <wegorz_at_winuel.com.pl> wrote in message news:8ono0d$5gd$1_at_news.tpi.pl...
> Check status of temporary tablespace. If it is 'permanent', change it to
> 'temporary', but I strongly recommend to set extents in this tablespace
> realy big - for example 1M or even more.
>

If he's not careful, that's just a recipe for wasting space. Extent sizes for temporary tablespaces should be the same size as your sort_area_size, or multiples thereof.

Regards
HJR
> During starting up Oracle is doing some strange things on temporary
> tablespaces (coalescing and so on), so if there is many extents, it takes
> forever to finish it. Once on Compaq DS20 I had to wait 6 (six!) hours to
> finish opening process.
>
> --
> Andrew Rajczakowski
> DBA, Winuel SA, Poland
>
>
Received on Sat Sep 02 2000 - 02:44:37 CDT