Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news-hub.siol.net!newsfeeder1.noc.eunet-ag.at!news.eunet.at!feed.news.tiscali.de!news.belwue.de!news.uni-stuttgart.de!carbon.eu.sun.com!btnet-feed5!btnet!news.btopenworld.com!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: How much data can you put in v$session_longops Date: Tue, 26 Apr 2005 15:49:17 +0000 (UTC) Organization: BT Openworld Lines: 45 Message-ID: References: <830861d2.0504250621.3687749b@posting.google.com> <1114443275.84420@yasure> <830861d2.0504252333.2e379f0c@posting.google.com> NNTP-Posting-Host: host217-43-123-177.range217-43.btcentralplus.com X-Trace: nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com 1114530557 16513 217.43.123.177 (26 Apr 2005 15:49:17 GMT) X-Complaints-To: news-complaints@lists.btinternet.com NNTP-Posting-Date: Tue, 26 Apr 2005 15:49:17 +0000 (UTC) X-RFC2646: Format=Flowed; Original X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MSMail-Priority: Normal X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:241271 "Pratap" wrote in message news:830861d2.0504252333.2e379f0c@posting.google.com... > Thanks a lot, will try to stress test and come up with the answer. But > I am a bit paranoid about messing up anything in the dictionary > because of the stress test. > > > DA Morgan wrote in message > >> I can't answer when it is purged but there is no limit of which I am >> aware as to the number of entries that can be made. In that version of Oracle (8.1.7), I think there is a limit on the structure which is either 2 x sessions or 1 x sessions. A single session can use up the whole list, though - and sometimes does because the code is a little buggy and uses a new row instead of updating an existing one. When the list is full, I think nothing more can go into it until a session holding some rows exits - and I don't think there is any explicit 'release entry' call in the package that helps. Nothing gets blocked if the list if full, though. Warning - it's a long time since I looked at it, so I may be out of date; and I won't make any guarantees about 9i. -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated April 5th 2005