Home » RDBMS Server » Performance Tuning » UPDATE DATE AND TIME OF TABLE
UPDATE DATE AND TIME OF TABLE [message #245656] Mon, 18 June 2007 05:54 Go to next message
Messages: 28
Registered: January 2000
Junior Member
Can anyone tell me how to find update date and time of any table in a database

Re: UPDATE DATE AND TIME OF TABLE [message #245662 is a reply to message #245656] Mon, 18 June 2007 06:07 Go to previous message
Michel Cadot
Messages: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not recorded unless you activate the audit.
LogMiner is a way to get it from redo logs.
Flashback transaction also if you have 10g.


[Updated on: Mon, 18 June 2007 06:09]

Report message to a moderator

Previous Topic: Buffer Busy waits, db file scatteredl read, sequential read
Next Topic: dbms_advisor
Goto Forum:

Current Time: Wed Jul 26 03:51:40 CDT 2017

Total time taken to generate the page: 0.06825 seconds