Re: 10G r2 Scheduler

On Fri, 30 Sep 2005 10:28:57 -0700, bdbafh wrote:

> I've seen postings indicating that extproc listener callouts can use
> large amounts of memory per session and they have frequently been a
> security issue.

In addition to that, Oracle cannot control PGA of the server processes using extproc. External listener is implemented as an external server, which communicates with the regular server process through Oracle*Net and can do whatever the underlying shared library does. If the external listener is pointing to extproc perl, there is no reason why you cannot execute thing like $a='A' x 1000000000; which will allocate approximately 1 GB of memory. More about exproc perl on:

http://www.smashing.org/extproc_perl/

-- 
http://www.mgogala.com