Re: db cache size in oracle 9ir2

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3fbdf242$0$9385$ed9e5944_at_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).

Also Veritas Cluster software version 3.5 does not support spfiles...

Ralph Received on Fri Nov 21 2003 - 08:29:26 CST