Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
May 16, 2000

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(
Jayanta Sengupta
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap