OraFAQ Forum: Server Administration » Find SQL history of all executed statements along with user details

Home » RDBMS Server » Server Administration » Find SQL history of all executed statements along with user details (oracle 9/10g, windows xp)

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

Find SQL history of all executed statements along with user details [message #461196]

Thu, 17 June 2010 00:54

vamsikrishnag
Messages: 16
Registered: October 2008

Junior Member

hi,

I would like to get all the history of SQL statements that are executed on the schema and the session or user details who has executed it.

I am using oracle 9i/10g.

Please let me knwo how this can be acheived

Regards,
Vamsi

Report message to a moderator

Re: Find SQL history of all executed statements along with user details [message #461202 is a reply to message #461196]

Thu, 17 June 2010 01:15

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

Senior Member
Account Moderator

Activate extended audit (for 10g, not possible in 9i).

Regards
Michel

Report message to a moderator

Re: Find SQL history of all executed statements along with user details [message #461204 is a reply to message #461202]

Thu, 17 June 2010 01:21

vamsikrishnag
Messages: 16
Registered: October 2008

Junior Member

Thank you .

I would like to get the details without setting the audit parameter on.

Is there any other way apart from this.

Regards,
Vamsi

Report message to a moderator

Re: Find SQL history of all executed statements along with user details [message #461208 is a reply to message #461204]

Thu, 17 June 2010 01:48

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

Senior Member
Account Moderator

Quote:

I would like to get the details without setting the audit parameter on.

You can't. Someone has to record the statements and audit is the only one to guarantee all of them.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 9i
Next Topic:	Big Datafile vs Multiple Small Datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 10:36:23 CST 2024