Re: PL/SQL: -- pkg runtime Size Limitations?

From: Karsten Farell <kfarrell_at_medimpact.com>
Date: Thu, 10 Oct 2002 20:03:15 GMT
Message-ID: <72lp9.2882$I52.169267409@newssvr14.news.prodigy.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. Received on Thu Oct 10 2002 - 15:03:15 CDT