Home » SQL & PL/SQL » SQL & PL/SQL » How to get history of commands?
How to get history of commands? [message #412709] Fri, 10 July 2009 14:21 Go to next message
JJVAC
Messages: 5
Registered: August 2008
Junior Member
Is there a way that I can see history of commands for the user I am logged in as from a SQL+ session? Or anything close to this?...
Re: How to get history of commands? [message #412710 is a reply to message #412709] Fri, 10 July 2009 14:25 Go to previous messageGo to next message
JJVAC
Messages: 5
Registered: August 2008
Junior Member
To clarify - I don't mean uparrow command history, I mean a history of commits. Table changes, etc.
Re: How to get history of commands? [message #412713 is a reply to message #412709] Fri, 10 July 2009 14:33 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
LOGMINER

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: How to get history of commands? [message #412716 is a reply to message #412713] Fri, 10 July 2009 14:41 Go to previous messageGo to next message
JJVAC
Messages: 5
Registered: August 2008
Junior Member
Oracle Version: 10g Enterprise 10.1.0.2.0
OS Version: Windows Server 2003

[Updated on: Fri, 10 July 2009 14:43]

Report message to a moderator

Re: How to get history of commands? [message #412717 is a reply to message #412709] Fri, 10 July 2009 14:50 Go to previous messageGo to next message
JJVAC
Messages: 5
Registered: August 2008
Junior Member
This is for commands that have already happened. Is there a query I can run against a table to see the actions of a specific user?
Re: How to get history of commands? [message #412721 is a reply to message #412717] Fri, 10 July 2009 15:12 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You might want to look at auditing and fine grained auditing.

[Updated on: Fri, 10 July 2009 15:13]

Report message to a moderator

Previous Topic: PLSQL Word Mail Merge
Next Topic: Create Materialized view on table which containing CLOB/BLOB
Goto Forum:
  


Current Time: Sat Dec 03 08:18:27 CST 2016

Total time taken to generate the page: 0.14166 seconds