Pinned Code (ORCL)

Go Up to Data, Schema, and Miscellaneous Utilities

For Oracle, DBArtisan now offers a Pinned Code Utility that lets you pin or unpin code objects in memory. This ensures that frequently accessed database stored procedures, triggers, functions, etc., are available in memory, which improves their overall execution performance.

Note: To create the DBMS_SHARED_POOL package log on as SYS and run the DBMSPOOL.SQL script that is found in the ORACLE_HOME\RDBMS\ADMIN directory.

Opening the Pin Code Dialog Box

1. On the Utilities menu, select Pinned Code.

   DBArtisan opens the Pin Code dialog.

The table below describes the options and functionality on Pin Code dialog.

Option	Description
User	Lets you select the object user.
Pin Button	To pin an object, select the target object, and then click the Pin button.
UnPin Button	To unpin an object, select the target object, and then click the UnPin button.
Flush SGA Button	Click to flush the Oracle shared pool to remove fragmentation and any unwanted code objects from memory.

You must install the SYS.DBMS_SHARED_POOL package on your Oracle server to use this utility.

Confirm Shared Pool Flush

The Confirmed Shared Pool Flush dialog lets you confirm that you want to flush the Shared Pool. Flushing the Shared Pool causes all non-pinned code objects to be removed. After you flush the Shared Pool, all non-pinned objects are parsed and reloaded back into the pool on the next execution. This can extend first-time execution response times.