Re: db cache size in oracle 9ir2

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:dlfqrvgp24dmqhuo3evcb91tgnshrsns5v_at_4ax.com...
> On Thu, 20 Nov 2003 21:02:22 -0000, "Niall Litchfield"
> <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.

Totally untrue.

If you create a database using dbca, you have the *option* to use an spfile if you wish, and that option is definitiely on by default. But it is clearly not the case that "if created with dbca ... then you have an spfile".

Not without a "...and you don't know how to use dbca to make your database work the way you want it to work..." clause in there at any rate.

>In the end you will feel more or less forced by Oracle
> to use the spfile as the disadvantages are big.

Such as?

The spfile is still, in 9iR2, totally optional; has a bug when trying to set the dispatchers parameter with 'alter system...scope=spfile' syntax; confuses the hell out of everyone because it doesn't necessarily *replace* the init.ora but merely takes precedence over it; fails to validate attempts to set illegal values (such as shared_pool_size=0); and adds nothing that the init.ora can't give you in terms of managing multiple instances with just the one file. Never mind that you can't edit it directly at the command line.

The init.ora has just one disadvantage: it can't reside on a raw partition in a RAC.

The spfile has just one thing going for it: it is compulsory if you want to use Data Guard.

HJR Received on Fri Nov 21 2003 - 13:42:58 CST