| Memory [message #56155] |
Sun, 09 March 2003 23:53  |
Dik
Messages: 27
Registered: June 2002
|
Junior Member |
|
|
Hello,
How can I know if I have enough RAM, swap?
Can I have any problem if i increase RAM from 512M to 1G on server.
Can I have problem if I add another processor?
Is there any changes need to be done when I am doing such operations? (instance,SGA ...?)
Any help welcome!
|
|
|
|
| Re: Memory [message #56161 is a reply to message #56155] |
Mon, 10 March 2003 11:47  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Log into the system and type 'show sga' which gives the total SGA like this:
SQL> show sga
Total System Global Area 194394236 bytes
Fixed Size 116860 bytes
Variable Size 110120960 bytes
Database Buffers 83886080 bytes
Redo Buffers 270336 bytes
SQL> exit
This is the amount of physical memory used. (~190 MB). So moving from 512 MB to 1 GB may be a good idea. If you have enough memory, then chances of swap is less.
Adding a processor is adding more resource. I do not see any problems by just adding another CPU.
Most likely in your case is, just by adding another 512MB in the system will do the job. When you do have 1 GB, then maybe you would wanna make the SGA a little larger as you can afford to do so.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
