***************************************************************************************
* Description: Flushing a single SQL statement from library cache or whole shared pool
* Date: 03:55 PM EST, 07/16/2017
***************************************************************************************



<1> Flush whole shared pool within Oracle SGA:
     |
     |__ SQL> ALTER SYSTEM FLUSH SHARED_POOL;
	 
	 
	 
<2> Purge a single SQL statement out of library cache:
     |
     |__ o. SQL> select address, hash_value from v$sqlarea where sql_id='7x56nmhc9vrjf';
     |    
     |                ADDRESS          HASH_VALUE
     |                ---------------- ----------
     |                00000005D30231A8  412999214	 
     |
     |__ o. SQL> exec dbms_shared_pool.purge('00000005D30231A8, 412999214', 'C');