As the following code snippet shows, flushing the shared pool is very simple, yet the effect is indeed significant.

One of the easiest, most powerful, and most appropriate shared pool latching solutions is to simply add subpools, which will also add shared pool latches. The process is detailed in the earlier "From Hashing to Subpools" section.

This particular solution is very clean in that it requires minimal effort and we are not gaming Oracle's shared pool LRU algorithm. However, keep in mind that more subpools may require more shared pool memory, an instance restart is required for the instance parameter change to take affect, and Oracle reserves the right to not respect your recommendation.