S

Santosh's OraHow - Oracle DBA Articles And Database Tutorials

Advanced: Place to learn Database Tutorials which provides
configurations and monitoring scripts to troubleshoot
database issues and to fix performance bottleneck. We
provide database news and articles on Oracle, MySQL,
Postgresql, Big Data, Hadoop, Linux, Sybase, Teradata,
Goldengate, RAC, Replication, Backup and recovery.

Rated2.7/ 5
Updated 7 Years Ago

How to Flush a Single SQL Statement from the Shared Pool

Updated 7 Years Ago

It is advisable to flush single sql statement for a particular sql_id from the shared pool rather than flushing all the plan from the memory. Sometimes you need to fix the bad execution plan and to fix it you can use this method to kick out single sql plan.

S

Santosh's OraHow - Oracle DBA Articles And Database Tutorials

How to Flush a Single SQL Statement from the Shared Pool

TAGS