Re: db cache size in oracle 9ir2

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 21 Nov 2003 11:08:49 -0000
Message-ID: <3fbdf242$0$9385$ed9e5944@reading.news.pipex.net>

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:dlfqrvgp24dmqhuo3evcb91tgnshrsns5v_at_4ax.c
> <niall.litchfield_at_dial.pipex.com> wrote:
>
> >Not if you are not using an spfile.
>
> If you create the database using the database creation assistant you
> HAVE a spfile. In the end you will feel more or less forced by Oracle
> to use the spfile as the disadvantages are big.

True. There are a number of reasons why you might not use the dbca though, for example you might want dictionary managed tablespaces for some apps, you might be using std edition and want a valid archive log destination set.

As far as disadvantages of init.ora over spfile are concerned I'm not really clear what they are (outside of a RAC environment).

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri Nov 21 2003 - 05:08:49 CST