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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Startup Trigger is not pinning all packages

RE: Database Startup Trigger is not pinning all packages

From: Elliott, Patrick <Patrick.Elliott_at_bestbuy.com>
Date: Tue, 13 Feb 2001 11:37:48 -0800
Message-ID: <F001.002B2E46.20010213112207@fatcity.com>

That is correct. In 8.0 the package does not need to be in memory to pin it.

> -----Original Message-----
> From: Ray Feighery [SMTP:ray_at_jobnet.com.au]
> Sent: Monday, February 12, 2001 4:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Database Startup Trigger is not pinning all packages
>
> I believe this restriction has been lifted.
> It is no longer necessary to call the packages before loading them.
>
> Ray
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, February 13, 2001 6:00 AM
>
>
> > I would need to double-check on your error, but the usual problem
> > with pinning packages at startup is that they haven't been loaded
> > into memory (standard and some of SYS's other packages load
> > almost at the initial moment of startup). Try to put some code into
> > the trigger to call the packages first, then load them. One approach
> > is to put in dummy function in the user packages that returns null
> > and call that function, thus pulling the package into memory.
> >
> > Regards,
> > Chris Gait
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: cjgait_at_earthlink.net
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Feighery
> INET: ray_at_jobnet.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Elliott, Patrick
  INET: Patrick.Elliott_at_bestbuy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Feb 13 2001 - 13:37:48 CST

Original text of this message

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