1752426 Members
5699 Online
108788 Solutions
New Discussion юеВ

Attention Dragan Krnic

 
Alexander M. Ermes
Honored Contributor

Attention Dragan Krnic

Hi Dragan.
Pinning means to load the mostly used packages into the SGA.
If you need more info let me know.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
4 REPLIES 4
Alexander M. Ermes
Honored Contributor

Re: Attention Dragan Krnic

Hi Dragan.
Attached a sample for a file to pin packages.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Alexander M. Ermes
Honored Contributor

Re: Attention Dragan Krnic

Hi Dragan.
Another hint :
ask Oracle for a sql that checks the loads and execs of objects.
In Applications this scripts is named ADXCKPIN.sql.
Rgds
Alexander M: Ermes

.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Dragan Krnic_2
Advisor

Re: Attention Dragan Krnic

Thank you Alexander. To keep packages in shared memory as if one pinned them. I never came across the term.
no quote
Alexander M. Ermes
Honored Contributor

Re: Attention Dragan Krnic

Case dismissed
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"