Databases Reference
In-Depth Information
In step 2, we query the
V$DB_OBJECT_CACHE
dynamic performance view, in order to inspect
what database objects are actually cached in the Shared Pool. The output of this query is
shown in the following screenshot:
This query can help us decide what objects to keep in memory, based on the memory
requirement (the
SHARABLE_MEM
column). We can also query the
EXECUTIONS
column
to see objects that are used most often.
In step 3, we use the
DBMS_SHARED_POOL
package to keep the
SYS.DBMS_SCHEDULER
package in the Shared Pool. There is no public synonym to this package, so you have to
reference it with the
SYS
schema. The pinned package has to be fully qualified—as in our
example
SYS.DBMS_SCHEDULER
.
If the
DBMS_SHARED_POOL
was not created during the
installation, the
$ORACLE_HOME/rdbms/admin/dbmspool.
sql
script—executed as
SYSDBA
—will create it.