| SGA AND PGA PARAMETER SETTINGS [message #533013] |
Sun, 27 November 2011 01:44  |
mrdb
Messages: 62
Registered: December 2009
Location: dubai
|
Member |
|
|
we are ruining oracle 9i in windows 2000 server, oracle is the only database running in the server. The RAM capacity is 4GB but the sga showing is as below
sga size
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
pga size
NAME VALUE
---------------------------------------------------------------- ----------
aggregate PGA auto target 0
global memory bound 0
total expected memory 0
total PGA inuse 19937280
total PGA allocated 31826944
maximum PGA allocated 31826944
total PGA used for auto workareas 0
maximum PGA used for auto workareas 0
total PGA used for manual workareas 0
maximum PGA used for manual workareas 0
estimated PGA memory for optimal 0
NAME VALUE
---------------------------------------------------------------- ----------
maximum PGA memory for optimal 0
estimated PGA memory for one-pass 0
maximum PGA memory for one-pass 0
kindly advice how can we using the 4gb RAM deducing 20% for OS
Sometimes users are complaining slow process.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SGA AND PGA PARAMETER SETTINGS [message #533018 is a reply to message #533016] |
Sun, 27 November 2011 02:49  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
What course did you do? If it was with Oracle Uni, you should re-read Administration Workshop 2, chapter 8: Managing Memory. If it wasn't Oracle Uni, then there must have been a similar topic that dealt with the instance parameters that control SGA memory usage. There will also have been a section on PGA.
Really, you question is too big to deal with as a forum query.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
