Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SQL run against the database
Dear Oracle Gurus:
Is there a way to get at all the SQL statements that have ever been run against the database in the last couple of days? I am only interested in 'select' statements. I looked at the SGA(v$sql) and a lot of what I am interested in has already been flushed out. Are there any Oracle forensics experts that can sleuth out this information? I know this is a long shot, but any help is much appreciated.
Thanks,
Sunil.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 22 2006 - 16:56:15 CDT
![]() |
![]() |