changing initialization parameters

From: Tonia Stakemire <g00s3874_at_campus.ru.ac.za>
Date: Sat, 23 Mar 2002 12:58:20 +0200
Message-ID: <1016880640.26669@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 Received on Sat Mar 23 2002 - 04:58:20 CST