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.

Have you tried changing the DisablePagingExecutive registry entry to 1? That'll make Windows page to memory rather than disk, which might solve your problem, assuming you're trying to stop disk-swapping.

-- 
Preston.