Hi All,
We have oracle 18 on Aix.
One of the sql is slow. The sql plan hash value has many sql id when executing from sql developer.
cusror_sharing value is exact in the db.
1,Due to many sql id id, difficult to find which one is right one. Just compared elapsed_time in v$sql.Is ir right approach?
2,I am new to tuning especially large sql statement ( it has 400 lines ). i don't know business logic hence struggling for where to start?
I have tried to get all the tables and columns in where clause of the sql. Checked index status,last_analyzed date and blocking sessions,memory, cpu details
Do i have to check anything other than this
3,If have large sql, where to start.....
Due to company policy, i couldn't share sql, expalin plan etc.All are restricted.
Please share your suggestions.
Thanks,