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: 250
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 messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
http://kerryosborne.oracle-guy.com/2008/09/flush-a-single-sql-statement/

Report message to a moderator

Re: Can we delete specific execution plan in the db buffer for a statement [message #668122 is a reply to message #665251] Thu, 08 February 2018 02:36 Go to previous message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
thanks for the solution.

Report message to a moderator

Previous Topic: Move unused partitioned from one tablespace to another tablespace.
Next Topic: How long lock should be in order to take snapshot of locks
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 01 01:09:19 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.