devxlogo

Caching Packages on Database Startup

Caching Packages on Database Startup

Oracle8i has introduced database-level and system-level triggers. They can track events in the database such as logon/logoff from a schema, startup and shutdown of a database, and response to a server error. We will use these triggers to cache the frequently used packages in the memory during database startup.

Before Oracle8i, you had to set up a script to run after the database started. Now you can use the STARTUP trigger to load the packages into the shared memory. The following is a very simple code to do so:

 create or replace trigger load_package	after startup on database	begin		DBMS_SHARED_POOL.KEEP(
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist