Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to select which plan is efficient among Multiple Plans for the same SQLID

JhilMar 10 2025

Team,

How do we conclude the Best Execution Plan When an SQL_ID Has Multiple Plans?

elapsed_time, cpu_time, buffer_gets, and disk_reads - are these enough with lower values ?

Thanks & Regards,

Thiyagu G

Comments
Post Details
Added on Mar 10 2025
0 comments
93 views