Tuesday, August 8, 2023

Query to find Plan Hash Values for a SQLID in Oracle

Query to find Plan Hash Values for a SQLID in Oracle SELECT DISTINCT sql_id, plan_hash_value FROM dba_hist_sqlstat dhs, ( SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap FROM dba_hist_snapshot ss WHERE ss.begin_interval_time BETWEEN (SYSDATE - &No_Days) AND SYSDATE ) s WHERE dhs.snap_id BETWEEN s.min_snap AND s.max_snap AND dhs.sql_id IN ( '&SQLID')
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle Database Password Management: Resetting Password Policies and User Account Expiry Issues

  Checking Password Lifetime Policy Oracle password expiration rules are controlled through profiles. The following query helps identify the...

  • TKPROF Overview
      TKPROF Overview.   TKPROF is used for diagnosing performance issues.  It formats a trace file into readable format for performance ana...
  • ORACLE CLOUD EBS INSTALLTION
      CLOUD EBS INSTALLTION   login as: opc Authenticating with public key "rsa-key-20201105" from agent Last login: Thu Nov 19 08...
  • Query to find the Concurrent Request Trace File Path
      Query to find the Concurrent Request Trace File Path In Oracle Applications, we all submit concurrent requests. As a developer when we nee...