3 decode(a.type,'PACKAGE','PKG','PACKAGE BODY','PBDY','FUNCTION','FNC','PROCEDURE','PRC') typex,

Figure 7-14. Shown is the OSM script dboc.sql, which is used to quickly identify large and/or frequently executed shared pool objects. This example was run soon after the instance restarted.

To keep a cursor in the shared pool, gather both its address and hash value from a v$sql, v$sqlarea, or perhaps v$open_cursor script. Notice that in the following code snippet the address (6877c238) and hash value (1356456286) are concatenated together with a comma between them. The second parameter is a C, since we are keeping a cursor. For keeping triggers the parameter is T; for sequences, use Q; and for packages, procedures, and functions, the parameter is P.