Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson Consulting

RAM fencing in IBM AIX

The lock_sga init.ora parameter will lock the entire SGA into physical RAM memory, making it ineligible for swapping. The lock_sga parameter does not work for Windows-NT or AIX and the setting for lock_sga will be ignored. For AIX 4.3.3 and above you can set the SHM_PIN parameter to keep the SGA in RAM, and you can details from your AIX documentation.

The above is an excerpt from the "Oracle UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA