Oracle Monitored SQL executions list history

Posted on 2014-08-11
Last Modified: 2014-08-19
Oracle 11gR2 OEM, when I check monitored SQL executions, it shows list only for 1 or 2 hours even when I select "ALL" or "24 HOURS" from the drop down list.  Please help me to see longer history in OEM.
Question by:partnershipit
    LVL 5

    Expert Comment

    by:Sanjeev Labh
    The best area I would suggest would be to look at the sql history from the awr snapshot history. This will have the details of sql which are not available in the cursor cache too.
    LVL 5

    Accepted Solution

    You can refer the dba views dba_hist_sqlstat and dba_hist_snapshot for getting it. This will enable you to monitor the sqls by snap id of the awr snapshots enabling you to extract it from various time periods.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    find difference between dates from a column in oracle 9 40
    PL/SQL Group by 2 34
    Add 0 to end of Number 21 58
    oracle query help 29 45
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to recover a database from a user managed backup

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now