Re: LOCK_SGA on Oracle 8.1.7 (win2000)

Heini Nolsøe wrote:
> I am having alot of trouble making LOCK_SGA work on my Oracle 8.1.7 running windows 2000, and am really looking for somebody with experience at this specific task.
>
> I am aware of that LOCK_SGA is buggy until Oracle 9.2, but the guys at Oracle Metalink are saying that there is a workaround. My problem is that the official workaround at Metalink does not work, and it seems more or less impossible to get any real help via the Metalink supporters - they more or less just copy/paste Metalink documents back at me.
>
> In desperation I have tried to install an Oracle 10G database, but even on this version of the database LOCK_SGA does not seem to work at all.
>
> I have really been searching allover for info on this subject, but there really is not much to be found. I have read all available docs on Metalink and am running out of ideas.
>
> In short ..... HELP !!!!

My understanding is that LOCK_SGA is not supported by the Win2K operating system.

Source: http://www.orafaq.com/cgi-bin/search/query?q=lock_sga

Can anyone confirm this?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)