Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unhappy Unanswered: Package question

    I have a question about package.
    Package are loaded in memory when one of this function is called.

    I want to load the package when the database is starting because we have a web site and the first time we connect to the site it takes long time because oracle loads the package in memory (the page calls a function of the package).
    So to speed up the first page I want to load package at the database's startup.

    Can anyone help me and give me an answer ?

    Thank's

    Glenn Prigent

    PS: sorry for my poor english i hope you'll understand what i have wrote.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    exec dbms_shared_pool.keep('SCHEMA.PACKAGE_NAME');

    This will pin the object in memory. There is a way to do this at startup but I can't remember.

    I'll try to find it.

    Rgs,
    Breen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •