Link to home
Start Free TrialLog in
Avatar of finance_teacher
finance_teacher

asked on

ORACLE -- last 10+ SQL statements

How can I see the last 10+ SQL
statements that ran on my Oracle
server ?

Example
  SELECT * FROM CUSTOMERS
  DELETE * FROM USERS
  etc
Avatar of Sean Stuber
Sean Stuber

unless you have auditing turned on for everything,  no, you can't.

If you do, then you should be able to see them in dba_audit_trail
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good point.  Didn't consider that.