Re: db cache size in oracle 9ir2

On Sat, 22 Nov 2003 06:42:58 +1100, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>
>"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
>

Howard,

Just to diverge a bit -- I have just put up my first 9i database (in fact, it just went live to production within the last hour). It supports a purchased package, and was created by a vendor's script, so I really had no hand in that - had to just take what was handed me. So . . . now, how can I tell for sure if they are using an spfile? (Some time ago I had already decided I preferred to stick with init.ora files). I tried to dig it out of their creation scripts but they are difficult/impossible to read, buried under several layers of complex ksh scripts and at least one jar file, and I'm still a relative novice on unix. Received on Fri Nov 21 2003 - 14:53:45 CST