To clear the whole shared pool, you would issue the following command from a privileged user.
SQL>ALTER SYSTEM FLUSH SHARED_POOL;Is flushing shared pool is good hobbit?
Flush Shared pool meaning flushing cached execution plan and SQL Queries from memory. Flush buffer cache meaning flushing cached data from memory.
Database bounce/restart which internally flush both shared pool and buffer cache. Flushing the data buffer cache & Shared pool are not recommended on Production Database.
Flushing shared pool may lead to increase the performance overhead, especially on RAC databases and Flush buffer cache may lead to disk I/0 overhead.