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

Home -> Community -> Usenet -> c.d.o.server -> Re: Where is the executable code of a trigger stored in the DBMS?

Re: Where is the executable code of a trigger stored in the DBMS?

From: <jbmorla_at_gmail.com>
Date: 12 Nov 2005 05:46:18 -0800
Message-ID: <1131803178.599845.152070@g14g2000cwa.googlegroups.com>


I think in the shared pool as long as there is room, but if u have a lot of pl/sql code, some might get paginated back on the drive, that's why u have to pin some packages if they are often needed. Some isv provide interfaces that tell you which is actually loaded in memory. Received on Sat Nov 12 2005 - 07:46:18 CST

Original text of this message

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