On Sun, Jan 27, 2019 at 08:43:15AM +0000, Bhupathi, Kaushik (CORP) wrote: > 2) Is there anyway to know the historical execution plan details of a > particular SQL ? Per my understanding so far since there is no concept of > shared pool unlike Oracle every execution demands a new hard parse. However > wanted to check with experts to know if any extension available on this?
There's also autoexplain, althought I think that's typically configured to only output plans for queries which longer than a minimum duration. Justin
