sql performance

Dec 20, 2021 5:50AM

Hi Experts,

Our DB version 12.1

We have one sql for which external team recommended below solution. We didnt understand how did they come to a conclusion.

Enter value for sqlid: 45bdu0t5kdhqj

old 1: select * from table(dbms_xplan.display_cursor('&sqlid'))

new 1: select * from table(dbms_xplan.display_cursor('45bdu0t5kdhqj'))

PLAN_TABLE_OUTPUT

-------------------------------------------------------------------------------------------------------------------

SQL_ID 45bdu0t5kdhqj, child number 0

-------------------------------------

(select T1.darshan_date, T1.avail from (select darshan_Date,

SUM(no_Of_darshans) as avail FROM darshan_availability where

darshan_Date BETWEEN to_date(to_char(CURRENT_TIMESTAMP+(:1

)/(24*60),'dd-mon-yyyy'),'dd-mon-yyyy')+1 and to_date(:2

Database Tuning (MOSC)