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
meeta
Messages: 28
Registered: January 2000
Junior Member
Hi,
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: 64122
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.

Regards
Michel

[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 Dec 07 05:04:57 CST 2016

Total time taken to generate the page: 0.73155 seconds