| Memory [message #56137] |
Fri, 07 March 2003 07:28  |
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 process need to be done when I am doing such operations? (instance,SGA ...?)
Any help welcome!
|
|
|
|
| Re: Memory [message #56167 is a reply to message #56137] |
Mon, 10 March 2003 16:59  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
#1. Check it out:
vmstat 2
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s6 s7 s8 in sy cs us sy id
0 0 5 582912 329744 158 171 59 567 100 0 359 23 0 1 1 564 375 349 0 9 91
0 0 15 731488 455240 2 4 0 0 0 0 0 0 0 0 1 430 86 62 0 2 98
0 0 15 731488 455240 0 0 0 0 0 0 0 0 0 0 1 431 142 63 0 1 99
#2. No. More RAM is never a problem. Of course you have to put it in use, by increasing your SGA, otherwise what'e the point.
#3. No. Unless you consider your server processing data faster a problem.
#4. Shutdown your database, take a cold backup, validate it, then let the Sys Admins do the changes. Then start tuning the SGA and parallel clauses.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
