Find out the history of SQL queries

by 
    select v.SQL_TEXT,
           v.PARSING_SCHEMA_NAME,
           v.FIRST_LOAD_TIME,
           v.DISK_READS,
           v.ROWS_PROCESSED,
           v.ELAPSED_TIME,
           v.service
      from v$sql v
where to_date(v.FIRST_LOAD_TIME,'YYYY-MM-DD hh24:mi:ss')>ADD_MONTHS(trunc(sysdate,'MM'),-2)

where clause is optional. You can sort the results according to FIRST_LOAD_TIME and find the records up to 2 months ago.

More Related Contents:

  1. Number of rows affected by an UPDATE in PL/SQL
  2. Printing the value of a variable in SQL Developer
  3. PL/SQL, how to escape single quote in a string?
  4. Passing an array of data as an input parameter to an Oracle procedure
  5. Oracle Equivalent to MySQL INSERT IGNORE?
  6. null vs empty string in Oracle [duplicate]
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. NLS_NUMERIC_CHARACTERS setting for decimal
  12. Formatting DATE in oracle
  13. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  14. Oracle: How to find out if there is a transaction pending?
  15. Best practice for pagination in Oracle?
  16. check if “it’s a number” function in Oracle
  17. Sql*plus always returns exit code 0?
  18. ORA-06508: PL/SQL: could not find program unit being called
  19. ORA-12170: TNS:Connect timeout occurred
  20. How to create and use temporary table in oracle stored procedure?
  21. SQL*Plus how to accept text variable from prompt?
  22. How to find difference b/w TIMESTAMP format values in Oracle?
  23. if (select count(column) from table) > 0 then
  24. How to find out when an Oracle table was updated the last time
  25. NLS_LANG setting for JDBC thin driver?
  26. How can I describe a table in Oracle without using the DESCRIBE command?
  27. Is it possible to kill a single query in oracle without killing the session?
  28. Why cannot I create triggers on objects owned by SYS?
  29. automating rollback script oracle
  30. How can I issue a single command from the command line through sql plus?

Leave a Comment