tag:blogger.com,1999:blog-1163678196539162625.post7378258946385316290..comments2024-03-08T15:06:35.814+05:30Comments on Oracle Database: How to purge/flush a single SQL PLAN from shared pool in OracleAmit Rathhttp://www.blogger.com/profile/12035057610921327769noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-1163678196539162625.post-48696851964089481572022-05-25T03:15:01.794+05:302022-05-25T03:15:01.794+05:30It worked for me in 19c.
I copied the plan from pr...It worked for me in 19c.<br />I copied the plan from prod in 11204 into test in 19cRamakrishna Bhttps://www.blogger.com/profile/04432940314045903823noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-4859675005976230852021-07-05T17:05:31.333+05:302021-07-05T17:05:31.333+05:30I tried these in 19c database, it's not workin...I tried these in 19c database, it's not working. Is there any change in 19c ?Dasarathhttps://www.blogger.com/profile/01956279611666303581noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-13466059546581029592020-07-16T22:38:20.784+05:302020-07-16T22:38:20.784+05:30Thank you!Thank you!Ramhttps://www.blogger.com/profile/14442839731393208246noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-2233000396628511542020-07-16T22:38:04.805+05:302020-07-16T22:38:04.805+05:30Thank you!
Thank you!<br />Ramhttps://www.blogger.com/profile/14442839731393208246noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-90283612610522141512019-07-25T18:30:44.205+05:302019-07-25T18:30:44.205+05:30I have read your article. It is very good. Can you...I have read your article. It is very good. Can you please share the document to force the sql hash to the sqlid.santoshhttps://www.blogger.com/profile/08440803266870343719noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-87576914830906172502019-05-29T01:16:09.658+05:302019-05-29T01:16:09.658+05:30Definitely did. Thanks so muchDefinitely did. Thanks so muchkcigirihttps://www.blogger.com/profile/00409840042968342379noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-56227019047611060052018-12-21T16:57:56.547+05:302018-12-21T16:57:56.547+05:30Its better not to flush all SQL_ID out of shared p...Its better not to flush all <a href="https://orahow.com/how-to-flush-a-single-sql-statement-from-the-shared-pool/" rel="nofollow">SQL_ID</a> out of shared pool queries. Great article.Santoshhttps://www.blogger.com/profile/00046033033360527381noreply@blogger.comtag:blogger.com,1999:blog-1163678196539162625.post-15470835037788647592018-10-27T22:24:45.030+05:302018-10-27T22:24:45.030+05:30Thank you!Thank you!Ramakrishna Bhttps://www.blogger.com/profile/04432940314045903823noreply@blogger.com