Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: LOCK_SGA on Oracle 8.1.7 (win2000) Date: Thu, 07 Jul 2005 06:54:52 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1120744521.401468@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <42cd2949$0$54426$edfadb0f@dread14.news.tele.dk> In-Reply-To: <42cd2949$0$54426$edfadb0f@dread14.news.tele.dk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 22 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246771 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@x.washington.edu (replace x with u to respond)