Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle/Windows question

RE: Oracle/Windows question

From: Leandro Guimaraes Faria C. Dutra <>
Date: Fri, 12 Aug 2005 17:28:56 -0300
Message-ID: <> gravou em 2005-08-12 17:06:34:

> A few more questions: Would the size of the data set being operated on
> have any bearing on the memory usage?

        Yes, within the bounds of the configuration you did.

        That is, with less memory there'll be less cache, less buffers, and consequently more disk accesses.

> I saw on Metalink Note:271072.1 that the init.ora processes has no
> impact on this situation because it doesn't take in any resources.
> Agreed?

        Actually, this note is about listeners. init.ora configures the server. So you can allocate enough in init.ora that you won't get all the listeners you want.

> If my best immediate solution is to reduce the size of the SGA and I
> have these values set (I inherited this db so can't address why values
> where changed):

> shared_pool_size = 300000000 #previous value: 40000000
> shared_pool_reserved_size = 3000000 #previous value: 2000000
> log_buffer = 1048576 #previous value: 163840

> any idea where I might get the most "bang for the buck"?

        You must monitor for your specific situation... but the biggest influence in SGA is db_cache_size.

Leandro Guimarães Faria Corcete DUTRA
Administrador de Bases de Dados      +55 (11) 4390 5383
Toyota do Brasil Ltda    
São Bernardo do Campo, SP                        BRASIL

This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference.
Received on Fri Aug 12 2005 - 15:35:10 CDT

Original text of this message