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

Report message to a moderator

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: 68651
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 21:36:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.