Can you please tell me the command to find the plan hash value for the particular sql query with sql_id with execution time.
Kindly share your valuable views here.
Thansk in advance.
No Comments Posted for this Article.
Freeze bad Hash Plan Value in 11g
Hello Experts,I have a problem with My query that was performing well yesterday, but today it was performing badly. Do anybody know how to freeze the bad hash plan and match with good hash plan from...
What is use of HASHED TABLE?
Hashed table is useful when your have to work with very big internal table and to read it with "READ TABLE WITH KEY ..." The time access is constant ! Definition of a Hashed...