OraFAQ Forum: Security » looking for sql statements ran and date/time

Home » RDBMS Server » Security » looking for sql statements ran and date/time

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

looking for sql statements ran and date/time [message #244899]

Thu, 14 June 2007 09:21

shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada

Junior Member

Hi,
I'm looking for the list of sql statement and time when they were executed for
a single user in the system:
select * from v$ sql for example.
the problem is that v$ session can give me the last one.
thanks

Report message to a moderator

Re: looking for sql statements ran and date/time [message #244917 is a reply to message #244899]

Thu, 14 June 2007 10:26

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Only select statements ? or dml and ddl only?
if dml and ddl then start auditing.

[Updated on: Thu, 14 June 2007 10:28]

Report message to a moderator

Previous Topic:	Problem with security and cross-schema foreign keys
Next Topic:	Multi-tier auditing in Oracle from Business Objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 28 03:03:25 CDT 2026