Can I read Track SQL Query Executions in Oracle on EtoBox?

Track SQL Query Executions in Oracle by Gloria Adriana Pimentel Robles is a document available to read on EtoBox.

What is Track SQL Query Executions in Oracle about?

The document discusses how to find SQL queries that have been executed against an Oracle database, especially those that have been run over the past two months by an application. It is suggested to check the GV$ACTIVE_SESSION_HISTORY view to see currently executing queries, and that Automatic Workload Repository (AWR) snapshots only keep query history for about a week by default, so queries from two months ago may not be available. Using Oracle Enterprise Manager to analyze performance is also recommended.

Author

Gloria Adriana Pimentel Robles

Language

EN