Re: db cache size in oracle 9ir2

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:3fbffb30$0$13680$afc38c87_at_news.optusnet.com.au...
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3fbfc43e$0$25662$cc9e4d1f_at_news.dial.pipex.com...
> > "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> > news:3fbe6b29$0$14031$afc38c87_at_news.optusnet.com.au...
> > >
> > > "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.
> >
> > How extraordinary. I'm sure that that checkbox wasn't there last time I
> > looked.
>
> Does that mean it was indeed there when you looked this time?? It will be
> under the File Locations tab, and is there even when you select to create
a
> database based on one of Oracle's templates.

Absolutely. I was just blind.

>
> >It would be nice if I could specify archivelog mode in standard
> > edition and get a valid log_archive_dest parameter though.
>
> This intrigued me, so I did what I haven't done for ages, and installed
9iR2
> Standard Edition. Then I ran dbca. There, under the 'Archive' tab, is a
> check box labelled 'Archive Log Mode'. Stick a tick in there, and the 'Log
> Archive Filename Format' field then becomes available to type any archive
> format string you care for. But, sure enough, the "wizard" (which in this
> case is surely a bug-ridden idiot) sets log_archive_dest_1 and not
> log_archive_dest... thereby causing an ORA-439 'Feature not enabled" error
> message when you attempt to proceed with the database creation.
>
> At which point, of course, you click 'Abort' a couple of times, followed
by
> 'Back', where you can then click the 'All Initialization Parameters...'
> button, and set the thing manually yourself.
>
> So yes, that's a nasty little bug that I wasn't aware of, and I hope it's
> been raised as an issue. But dbca can still do the necessary, if prompted
> hard enough.

To be honest I always choose to create the scripts so it isn't a big problem, just annoys me. As does the fact that if you choose to delete a database it also deletes said db creation scripts as well. Not exactly terrible news but irritating.

> On the other hand, it really isn't terribly sensible to create a database
in
> archivelog mode from the word go, is it? There's nothing worth archiving
at
> that point, for starters. Plus it makes the creation process take an
> absolute age!

Well I'd still like a valid archive destination, even if I'm not archiving yet. In addition if you specify archivelog mode it doesn't actually put it in archivelog mode until the very last stage (postdbcreation.sql just after creating the spfile) . This seems sensible to me.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************