OraFAQ Forum: Server Administration » Where can i see all executed statements?

Home » RDBMS Server » Server Administration » Where can i see all executed statements? (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Where can i see all executed statements? [message #578447]

Thu, 28 February 2013 03:52

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

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Hello,

You could use LogMiner to analyze the online and/or offline redo logs.

Report message to a moderator

Re: Where can i see all executed statements? [message #578450 is a reply to message #578447]

Thu, 28 February 2013 03:56

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is nowhere.

Regards
Michel

Report message to a moderator

Re: Where can i see all executed statements? [message #578451 is a reply to message #578447]

Thu, 28 February 2013 04:02

John Watson
Messages: 8989
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.

Report message to a moderator

Previous Topic:	Strange alters in alert.log
Next Topic:	unable to connect to database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 12 13:42:51 CDT 2025