Re: Triggers and shared pool

  • From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
  • Date: Fri, 29 Jul 2005 17:17:38 +0300

> Do triggers use shared pool
NO !!!!! Triggers use TRIGGER POOL :)

PS Sorry for that

On 7/29/05, Schauss, Peter <peter.schauss@xxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
> 


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

Other related posts: