Parameter change suggest after hardware change 
Author Message
 Parameter change suggest after hardware change
We wanna add extra 2 CPUs and 2G MEM for an exist Oracle database
which already had 2 CPUs and 2G MEM. Is there any suggestion about how
to change parameters in profile init<SID>.ora to fit into the new
hardware configuration?

Can we simply double all the memory in that file or is there a way to
calculate them?

Thanks for any comment.



Sat, 22 May 2004 16:03:46 GMT
 Parameter change suggest after hardware change

Quote:

>We wanna add extra 2 CPUs and 2G MEM for an exist Oracle database
>which already had 2 CPUs and 2G MEM. Is there any suggestion about how
>to change parameters in profile init<SID>.ora to fit into the new
>hardware configuration?

>Can we simply double all the memory in that file or is there a way to
>calculate them?

There are a number of parameters that default to some multiple of the
number of CPUs. If you've already set these explicitly, then they will
need to be adjusted, db_block_lru_latches is an example (relevant to 8i).

What to do with the extra memory is a more difficult question, and
largely depends on why you're buying more memory. If you want to support
more connections to the same server, then you need to balance the memory
between the server and spare for the connections. If you've just bought
the memory for additional performance on an existing workload, you
can put most of it straight into the block buffers (or library cache,
or sort area, or whatever you most need more RAM in).

--
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/



Sat, 22 May 2004 17:32:28 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Parameter change suggestion after hardware change

2. Suggested change to pgbench

3. Suggesting changes to 4gl

4. Suggested Changes to 4gl

5. Suggested Changes to 4gl

6. Suggested Changes to 4GL

7. Suggesting changes to 4gl

8. How to change parameter order in parameter collection

9. SQL Server 6.0 changing Hardware

10. Performance question re hardware change

11. PDOX 7 problems after changing hardware

12. Oracle Designer Suggested Hardware Configuration


 
Powered by phpBB® Forum Software