Package when ? [message #39989] |
Mon, 02 September 2002 02:29 |
Tita
Messages: 1 Registered: September 2002
|
Junior Member |
|
|
In what circumstance we can go for a package?.
If we pin a package in SHPool what will happen internally,Whether the rows that fecthed using some functions or procedure will remain in Shared pool area.?
Pls send ur answer for the above questions.
Tita
|
|
|
Re: Package when ? [message #39996 is a reply to message #39989] |
Tue, 03 September 2002 00:46 |
K.K. Raj kumar
Messages: 33 Registered: July 2002
|
Member |
|
|
If You Pin a Package / Procedure in Shared pool only the Oracle statements used in the Package / Procedure remains in the Library. The data that is accessed or affected by these Packages / Procedures will not be pinned and hence they will be following the same path and will be replaced using the Least Used Logarithm.
|
|
|