Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: changing initialization parameters
"Tonia Stakemire" <g00s3874_at_campus.ru.ac.za> wrote in message
news:1016880640.26669_at_turtle.ru.ac.za...
> Hello Everyone
>
> I have oracle 9 installed on windows 2000. I am trying to change the
> settings of the database such as block_size and the sizes of different
pools
> and caches that make up the SGA.
>
> I know that you can't change the block size once the database has been
> created but it said that you can create tablespaces of different block
size.
> It won't allow me to do that or to set the db_nK_cache_size.
>
> It also said that the SGA size and size of the pools such as buffer cache
> can be changed dynamically during a session but it won't allow me to do
this
> either.
>
> At the moment the SGA is set at 77.769516MB and the sort area size is
512KB.
> I have 1Gig of Ram.
>
> Please help. What am I not doing that I should?
> Thank you
> Tonia
>
>
I confess to precious little detailed knowledge of 9i (as yet; soon to be
remedied), but just a thought: have you checked the compatibility parameter?
Paul Received on Sat Mar 23 2002 - 11:53:12 CST