Oracle SQL Plan Management (SPM) is often overlooked and underused. This feature started in version 11.1 and has been enhanced with each new release. As of 19c this should be your goto method to help maintain well performing SQL statements.
Oracle SQL Plan Management (SPM) your imperative performance tool
Watch the full-length video
Premium Content: access is limited to Quest Corporate and Professional members.
Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.