Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Triggers and shared pool

Triggers and shared pool

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Fri, 29 Jul 2005 09:39:44 -0400
Message-ID: <6591F529444E9748A546718B3D1A67015CD150@xcgv2605.northgrum.com>


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
Received on Fri Jul 29 2005 - 08:41:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US