0

I use EF and Oracle.ManagedDataAccess to get/update/delete data from Oracle database.

How can I get history list of PL/SQL queries for this Oracle database ?

wolφi
  • 8,091
  • 2
  • 35
  • 64
Kirill
  • 429
  • 1
  • 6
  • 18

1 Answers1

1

You can use this sql statement to get the history for any date:

SELECT * FROM V$SQL V where first_load_time LIKE '2015-05-04%';

Repeated: Find out the history of SQL queries

I don't know how to set the question as duplicated...

James
  • 2,954
  • 2
  • 12
  • 25
  • 1
    I got error: SQL Error: ORA-00942: table or view does not exist – Kirill Jun 07 '18 at 09:42
  • Maybe your user doesn’t have enough privileges to query that table – James Jun 07 '18 at 09:46
  • That requirement was not present in your original question. Try adding this filter to your query: `AND PARSING_SCHEMA_NAME='TEST'` – James Jun 07 '18 at 10:21
  • @Kirill All of the names starting with _V$_ are views to SYS tables named _V_$_. So the table you need select privileges on would be _SYS.V_$SQL_. – Brian Leach Jun 08 '18 at 22:00