Oracle/Windows question 2005-08-12 - By Leandro Guimaraes Faria C. Dutra
oracle-l-bounce@(protected) 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 ldutra@(protected)
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.
--
http://www.freelists.org/webpage/oracle-l
|
|
