Re: LOCK_SGA on Oracle 8.1.7 (win2000)

Hi,

Yes, in principal LOCK_SGA scheme in not supported on Windows 2000 rather i should say Windows platform. doesn't matter which SP you are on.

lock_sga and pre_page_sga are meant generally for UNIX where we have much better and stable control over memory and some kernel parameters that govern memory management.

Yet, there is an optimisation method that is well described here,

Oracle9i Database and Client Release Notes Release 2 (9.2.0.2.1) for 64-Bit Windows Part Number B10694-01

I don't think this will work for Oracle 8i, so you have to try it for Oracle 9i or 10g. I don't know if it will work on 10g because i don't see these instructions in the 10g Release Notes. Yet, you could try it since you have already installed 10g.

Are you referring to Metalink Note: 274092.1? Refer it, if you haven't yet.

Check it and let me know if that works.

Just curious, what are you trying to accomplish? why would you want to use LOCK_SGA on Win2k?

windows memory managment is so horrible that you are lucky that it actually recognises 8GB or 16GB of RAM, let alone manage it.

you might as well just add 512MB of RAM which is less of an headache than getting lock_sga to work on Win2K.

ski Received on Fri Jul 08 2005 - 05:07:42 CDT