Forum Stats

  • 3,701,596 Users
  • 2,239,431 Discussions
  • 7,835,406 Comments

Discussions

How to get the duration or active time for last 24 hours SQL statements

FadiFadi Posts: 26 Blue Ribbon

How to get the duration or active time for last 24 hours SQL statements 

Answers

  • user11986216user11986216 Posts: 1 Blue Ribbon

    These may be useful:

    1. V$SQL / V$SQLSTATS
    2. V$ACTIVE_SESSION_HISTORY / DBA_HIST_ACTIVE_SESS_HISTORY
    3. DBA_HIST_SNAPSHOT / DBA_HIST_SQLSTAT / DBA_HIST_SQLTEXT
    4. AWR / ADDM / ASH reports
Sign In or Register to comment.