Flush Shared Pool

To clear the whole shared pool, you would issue the following command from a privileged user.


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.

Leave a Comment