Automating the Shared Pool Flush
Under some operational conditions (when very
little reusable SQL is used) the shared pool can become full of
non-reusable SQL. The Remote DBA can either monitor this situation manually
and periodically issue the ALTER SYSTEM FLUSH SHARED_POOL command,
or, the Remote DBA can automate the task. The actual procedure, called
flush_it, is excerpted from the DBMS_REVEALNET package of functions
and procedures and is shown in Figure 3.