Home » RDBMS Server » Server Administration » RAM USAGE ON WINDOWS
RAM USAGE ON WINDOWS [message #253680] Tue, 24 July 2007 10:40 Go to next message
Messages: 294
Registered: February 2006
Senior Member

This was one of the interview question,
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.


[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 Go to previous message
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?
Previous Topic: Drop TEMPORARY tablespace
Next Topic: Transportable tablespace Windows to Linux
Goto Forum:

Current Time: Wed Aug 16 08:09:45 CDT 2017

Total time taken to generate the page: 0.05221 seconds