We know how to flash all shared pool by :
SQL>alter system flush shared_pool;
Sometime, we only want to flush certain objects, like a cursor for testing purpose to want the cursor to have different execution plan.
Subscribe to get access
Read more of this content when you subscribe today.