oracle pinning [message #7478] |
Tue, 17 June 2003 01:26 |
Jayasri
Messages: 28 Registered: July 2000
|
Junior Member |
|
|
Hi,
what is oracle pinning. Is it storing the procedures and functions of a package in memory ?
what are the advantages of pinning ?
Regards
Jayasri.
|
|
|
Re: oracle pinning [message #7480 is a reply to message #7478] |
Tue, 17 June 2003 01:52 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
Pinning is nothing but making the frequently used storedprocedures,packages or functions reside permanently in the SQL and PL/PLSQL memory areas[[library cache]], they do not need to be loaded and parsed from the database, which saves considerable time.
Pinning objects in the shared pool can provide a tremendous increase in database performance
The pl/sql command to pin a package
SQL> execute dbms_shared_pool.keep(package name);
|
|
|
|
Re: oracle pinning [message #7529 is a reply to message #7480] |
Thu, 19 June 2003 06:04 |
Nalaneelan
Messages: 12 Registered: June 2003
|
Junior Member |
|
|
Can a Single Procedure or Function be pinned instead of a package.
The below proc requires another parameter i.e., 'P' for Package,'R' for trigger etc..
execute dbms_shared_pool.keep(package name,'P');
|
|
|
Re: oracle pinning [message #7533 is a reply to message #7529] |
Thu, 19 June 2003 06:56 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
Default parameter is P
so no need to give second param incase of package
Yes we can pin functions and procedures
value Kind of Object to keep
-- ----- ----------------------
P package/procedure/function
Q sequence
R trigger
T type
JS java source
JC java class
JR java resource
JD java shared data
C cursor
|
|
|
|