<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Oracle 11gR2 OEM, when I check monitored SQL executions, it shows list only for 1 or 2 hours even when I select &quot;ALL&quot; or &quot;24 HOURS&quot; from the drop down list. &nbsp;Please help me to see longer history in OEM.
</div>
</div>


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.

Oracle Monitored SQL executions list history

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.