Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!ngpeer.news.aol.com!news.stealth.net!news.stealth.net!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr14.news.prodigy.com.POSTED!34d3422d!not-for-mail From: Karsten Farell User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: PL/SQL: -- pkg runtime Size Limitations? References: <2e2fc08e.0210101032.75d082cf@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 15 Message-ID: <72lp9.2882$I52.169267409@newssvr14.news.prodigy.com> NNTP-Posting-Host: 67.117.210.172 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr14.news.prodigy.com 1034280195 ST000 67.117.210.172 (Thu, 10 Oct 2002 16:03:15 EDT) NNTP-Posting-Date: Thu, 10 Oct 2002 16:03:15 EDT Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: [[PA@SVDSZYMR]PXKROD]_\@VR]^@B@MCPWZKB]MPXHNDQUBLNTC@AWZWDXZXQ[K\FFSKCVM@F_N_DOBWVWG__LG@VVOIPLIGX\\BU_B@\P\PFX\B[APHTWAHDCKJF^NHD[YJAZMCY_CWG[SX\Y]^KC\HSZRWSWKGAY_PC[BQ[BXAS\F\\@DMTLFZFUE@\VL Date: Thu, 10 Oct 2002 20:03:15 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.server:163773 X-Received-Date: Thu, 10 Oct 2002 13:03:59 MST (news.easynews.com) Raghav Vinjamuri wrote: > Hi, > Is there a limit on the max size a PLSQL pkg can > takeup at runtime on the server? There is a *very old* note (1030030.6 from 1997) on MetaLink that might still hold true in current versions of Oracle. It was in answer to a specific question about a specific 3rd party app on a specific hardware platform. It has to do with not setting the SHMMAX and SHMSEG high enough so that users run out of shared memory. There's also a web site (http://home.clara.net/dwotton/dba/ora3113.htm) titled "Causes of ORA-3113's" that you might want to look at. Was the first hit when I typed 'ora-3113' in Google.