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)

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...

  • 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...
  • How to Generate fmx from fmb in R12
      1) Login to application server. 2) Go to the directory $AU_TOP/forms/US 3) Place “.fmb” file in binary mode or search for existing --> ...
  • ORA-01157 and ORA-01110
    ORA-01157  is raised when Database Writer (DBWR) is unable to find and lock a Datafile. This may be due to various reasons like - Datafile ...