V$SQL | V$SQLAREA | V$SQLSTATS | DBA_HIST_SQLSTAT
V$SQL, V$SQLAREA & V$SQLSTATS stores SQL details (including execution statistics) for all SQLs available in the Library Cache (SQL Area).
V$SQL – One row for each SQL Child cursor
V$SQLAREA & V$SQLSTAT – One for each each SQL ID and all execution statistics details (such as buffer gets etc.) are aggregated for the single row.
V$SQLSTAT is faster and scalable and has greater data retention (The SQL execution statistics may be available in v$SQLSTAT, even if the SQL cursor is edged out of the library cache.
DBA_HIST_SQLSTAT – This is a AWR (Automatic Workload Repository) View which contains the historical SQL statistics data from V$SQLSTAT and V$SQL. This is a very useful view to perform performance analysis over time such as any plan change etc.
Watch Video format : https://www.youtube.com/shorts/-rIL2ApjUeY
No comments:
Post a Comment