| What is Pinning [message #38741] |
Thu, 09 May 2002 22:01  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
|
What is 'pinning' code in the SGA? I understand it is done to prevent it from being aged out. How does this happen? How does it help in performance of pl/sql stored procedures?
|
|
|
|
| Re: What is Pinning [message #38744 is a reply to message #38741] |
Fri, 10 May 2002 01:50  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
Oracle keeps recent sql in library cache automatically and removes when space needed for other sql. however, if u want to keep code in cache without being aged out then u can pin most accessed procedure,packages into memory. use dbms_sared_pool.keep procedure to do that.
For more info: look at dbms_shared_pool package documentation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
