Pinning PL/SQL Code in the SGA
One database tuning technique that isn’t used often enough even though it can yield significant improvements is Oracle’s ability to pin PL/SQL code within the SGA memory. After the PL/SQL code has been pinned, it cannot be aged out of the SGA memory for any reason. For PL/SQL code that is heavily referenced, this can yield substantial results. The problem is that the method to accomplish this is called to PL/SQL packages provided by Oracle, and not SQL commands. So many DBAs have yet to discover this simple yet powerful tuning technique. TOAD provides a screen that makes this process both simple and quick.
TOAD’s Pinned Code screen is shown in Figure 6.37 and is accessible from the main menu at DBA|Pinned Code. ...
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
