Friday, October 24, 2008

Pinning objects in the Database

How to ping required objects in the Database?

Solution:
Use following syntax

BEGIN
SYS.DBMS_SHARED_POOL.KEEP(''HR.QP_PRIC_RQUEST','P');
end;

HR - is the Owner of the object
QP_PRIC_RQUEST- Object to be pinned
P- Default parameter

Table to know pinning objects status

v$db_object_cache

No comments:

Enabling SSL or TLS in Oracle E-Business Suite Release 12.2

Enabling TLS in Oracle Apps R12.2 Here  we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...