Home » RDBMS Server » Server Administration » memory
memory [message #53299] Wed, 11 September 2002 07:32 Go to next message
sai
Messages: 27
Registered: October 2001
Junior Member
I have 4 oracle instances on a W2k box.
There is a memory bottle neck. No CPU problems.
One instance has more db_block_buffer size.
Is there any parameters which will help me in sorting this out

I have changed
Parameters
shared_pool_size,processes,java_pool,large_pool_size

Works a little better.Is there any specific things I need to look

Appreciate the help
Sai

Report message to a moderator

Re: memory [message #53300 is a reply to message #53299] Wed, 11 September 2002 07:44 Go to previous message
Robert Kuhlmann
Messages: 35
Registered: March 2002
Member
look at V$sgastat for free memory

Report message to a moderator

Previous Topic: URGENT !! ora-04045 error for sys.cdc_create_ctable
Next Topic: Re: ora-00439: HERE'S THE ANSWER FOR LINUX
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 16:34:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.