Re: Triggers and shared pool

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Fri, 29 Jul 2005 17:17:38 +0300
Message-ID: <d6f0def505072907172f42a41f@mail.gmail.com>

> Do triggers use shared pool

NO !!!!! Triggers use TRIGGER POOL :)

PS Sorry for that

On 7/29/05, Schauss, Peter <peter.schauss_at_ngc.com> wrote:
> Oracle 8.1.7 (AIX 5.2)
>
> Do triggers use shared pool and, if so, what happens when a trigger is
> supposed to execute but cannot get a large enough block of the
> shared_pool? Does the event which was supposed to execute the trigger
> (e.g. a delete) fail?
>
> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jurijs
+371 9268222 (+3 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 29 2005 - 09:22:35 CDT