Monday, June 16, 2025
SQL executions based on AWR
SQL exection per day
SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUTIONS_DELTA) AS executions FROM DBA_HIST_SQLSTAT ss JOIN DBA_HIST_SNAPSHOT s ON ss.SNAP_ID = s.SNAP_ID AND ss.DBID = s.DBID AND ss.INSTANCE_NUMBER = s.INSTANCE_NUMBER WHERE ss.SQL_ID = '1gyhdhv4bcuaf' AND s.BEGIN_INTERVAL_TIME >= SYSDATE - 15 GROUP BY TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD'), ss.SQL_ID ORDER BY execution_date;
SQL exection per hour
SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD HH24') AS execution_hour, ss.SQL_ID, SUM(ss.EXECUTIONS_DELTA) AS executions FROM DBA_HIST_SQLSTAT ss JOIN DBA_HIST_SNAPSHOT s ON ss.SNAP_ID = s.SNAP_ID AND ss.DBID = s.DBID AND ss.INSTANCE_NUMBER = s.INSTANCE_NUMBER WHERE ss.SQL_ID = 'gg4cuaprd4fsj' -- Replace with actual SQL_ID AND s.BEGIN_INTERVAL_TIME >= SYSDATE - 15 GROUP BY TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD HH24'), ss.SQL_ID ORDER BY execution_hour;
Subscribe to:
Posts (Atom)
SQL executions based on AWR
SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...
-
1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in...
-
1) To hold the specific concurrent program Hold update fnd_concurrent_requests set HOLD_FLAG='Y' where PHASE_CODE='P'...
-
1) How to compile a form? A) Open the source code in the client PC using X-Server -------------------------------------------------------...