Home » RDBMS Server » Performance Tuning » Can we delete specific execution plan in the db buffer for a statement (12.1.0.2 DB Linux 64 Bit)
Can we delete specific execution plan in the db buffer for a statement [message #665249] Mon, 28 August 2017 01:46 Go to next message
juniordbanewbie
Messages: 169
Registered: April 2014
Senior Member
Dear all,

Can we delete specific execution plan for a statement?

https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL658

as far I as I know, the above will only delete from the sql baseline, it will not delete from the database cache.

from https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4092356300346664639

alter system flush buffer_cache;
SQL> alter system flush shared_pool;

alter system flush shared_pool;

the above flushes the whole database buffer not a specific sql.

Can we delete specific execution plan in the db buffer for a statement

thanks a lot!

[Updated on: Mon, 28 August 2017 01:47]

Report message to a moderator

Re: Can we delete specific execution plan in the db buffer for a statement [message #665251 is a reply to message #665249] Mon, 28 August 2017 02:09 Go to previous message
Roachcoach
Messages: 1498
Registered: May 2010
Location: UK
Senior Member
http://kerryosborne.oracle-guy.com/2008/09/flush-a-single-sql-statement/
Previous Topic: Join on index and adding default_where
Next Topic: sql need tuning - high cpu_time and buffer gets
Goto Forum:
  


Current Time: Mon Nov 20 20:46:40 CST 2017

Total time taken to generate the page: 0.08882 seconds