1752353 Members
5609 Online
108787 Solutions
New Discussion

SGA lock question

 
George_Dodds
Honored Contributor

SGA lock question

OS: 11.23

DB: Oracle 9i

 

 

Below are our current sga settings, I just need to confirm something.

If lock_sga is set to FALSE even if dba MLOCK is set in privgroup, does that mean that the Oracle memory is not ring fenced, ie it's being shared with the OS, or is the memory thats allocated to Oracle dedicated with those settings.

 

 

lock_sga                             boolean
FALSE

 

 

:/etc # cat privgroup
dba MLOCK

 

 

Cheers

 

George