Oracle flush shared pool why

In case of Oracle RAC ,it has to be executed on all the nodes. Why pinning objects into the shared pool? How to turn on the SQL trace, event in Oracle database and trcsess, tkprof utility. Top Useful scripts for Oracle Database for Monitoring purpose. Share this: Email. Print Pocket. Leave a Reply Cancel reply. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam.

Learn how your comment data is processed. Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email Address never made public. After the flush there is likely to be an interim spike in performance as the act of flushing may remove sharable SQL from the shared pool but does nothing to improve shared pool fragmentation. To clear the shared pool, issue the following:. Real-time scenario. Performance of the DB was OK at the beginning of the day and by late of the day performance was totally unacceptable.

Investigation showed that application was generating ad hoc SQL without using bind variables.