Re: db_cache_size setting

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 26 May 2004 15:21:40 -0400
Message-ID: <028a01c44356$ac28cce0$2501a8c0@dazasoftware.com>

Hi from my paper
1.1.1 Adding more physical memory to the server There is point when excessive data in memory start to decrease performance, because excesive logical reads (reads from data in memory) consume CUP and latches.

Blocks in memory are not only stored in memory instead of disk, they are other process that registers and keeps tracks of them.

Here is an excellent artilce from hotsos, the registration is free.

http://www.hotsos.com/downloads/registered/00000006.pdf

First you should optimize reads from memory (LIOs logical read call) and then, you should start to optimize reads from disk (PIOs physical read call)

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 26 2004 - 14:22:47 CDT