Re: How can be executed a scripts after startup?

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Fri, 12 Nov 1999 15:08:15 GMT
Message-ID: <01bf2d2f$872c3f40$a504fa80@mndnet>

Hi,

On UNIX, this is the way you do it in your startup bourne shell script via a HERE documnet:

svrmgrl mode=line << HERE > /tmp/pin_packages.log

        connect internal
        /* Pin often used Oracle supplied Packages */
        execute dbms_shared_pool.keep('DBMS_STANDARD');
        execute dbms_shared_pool.keep('DBMS_SHARED_POOL');
        execute dbms_shared_pool.keep('DBMS_DESCRIBE');
        execute dbms_shared_pool.keep('DBMS_OUTPUT');
        execute dbms_shared_pool.keep('STANDARD');
        execute dbms_shared_pool.keep('DBMS_UTILITY');
 
        /* User created packages need to be referenced before pinning */
        alter package OPS$PL.PKG_GENERAL compile;
        execute dbms_shared_pool.keep('OPS$PL.PKG_GENERAL');

HERE Marco De Benedetto <dibe_at_galliera.it> wrote in article <382AA825.4A9113BA_at_galliera.it>...
> I would like to pin objects whenever Oracle starts,
> how can I execute a script automatically after startup?
>
> Thanks
>
Received on Fri Nov 12 1999 - 09:08:15 CST