| RAM USAGE ON WINDOWS [message #253680] |
Tue, 24 July 2007 10:40  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi,
This was one of the interview question,
| Quote: | Is there is any way to determine through Oracle (DBAs do not have admin access to Windows servers on DB) whether the 3GB of SGA assigned has made 3GB of RAM addressable by Oracle
|
Any answer or suggested topic on this.
Thanks
[Updated on: Tue, 24 July 2007 11:11] by Moderator Report message to a moderator |
|
|
|
| Re: RAM USAGE ON WINDOWS [message #253725 is a reply to message #253680] |
Tue, 24 July 2007 13:33  |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
|
You can set parameter lock_sga=true to make Oracle SGA to be placed permanent in the RAM(not on swap). If this parameter are not set or set to false, then, by Oracle(without admin right on server), you cannot see where are you SGA. Did I understand correct the question?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
