Home » RDBMS Server » Server Administration » Where can i see all executed statements? (Oracle 11g)
icon5.gif  Where can i see all executed statements? [message #578447] Thu, 28 February 2013 03:52 Go to next message
ghostX
Messages: 1
Registered: February 2013
Junior Member
Hello,

at 1st sorry for my bad english.

Does anyone know whether i can see anywhere all executed Statements in my DB (Deletes, Updates...)?

perhaps in a particular table or in Oracle Enterprise Manager?

[Updated on: Thu, 28 February 2013 03:52]

Report message to a moderator

Re: Where can i see all executed statements? [message #578449 is a reply to message #578447] Thu, 28 February 2013 03:56 Go to previous messageGo to next message
ThomasG
Messages: 3064
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Hello,

You could use LogMiner to analyze the online and/or offline redo logs.
Re: Where can i see all executed statements? [message #578450 is a reply to message #578447] Thu, 28 February 2013 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is nowhere.

Regards
Michel
Re: Where can i see all executed statements? [message #578451 is a reply to message #578447] Thu, 28 February 2013 04:02 Go to previous message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

You would have to enable extended database auditing,and then enable statement auditing for each user:
orcl> sho parameter audit_trail

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
audit_trail                          string      DB, EXTENDED
orcl> audit all statements by scott;

Audit succeeded.

orcl>
and then look at the dba_audit_statement view.
Previous Topic: Strange alters in alert.log
Next Topic: unable to connect to database
Goto Forum:
  


Current Time: Thu Apr 17 18:08:36 CDT 2014

Total time taken to generate the page: 0.11967 seconds