cancel
Showing results for 
Search instead for 
Did you mean: 

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