Home » RDBMS Server » Server Administration » possible to find out last access to a table?
possible to find out last access to a table? [message #526616] Tue, 11 October 2011 23:17 Go to next message
hanner
Messages: 90
Registered: August 2011
Location: at HOME
Member
hi,

was wondering is it possible to track the last access to a table?

I think it is possible if you set some kind of audit on the table. Isn't that set a huge workload on the database itself?

Re: possible to find out last access to a table? [message #526617 is a reply to message #526616] Tue, 11 October 2011 23:19 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/311

http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/statements_4007.htm#i2059073
Re: possible to find out last access to a table? [message #526621 is a reply to message #526616] Wed, 12 October 2011 00:51 Go to previous message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Isn't that set a huge workload on the database itself?

Built-in audit workload is within the margins of error of performances measures. That is it is less than the natural variations in measurements.

Regards
Michel
Previous Topic: SYSTEM, sysdba, sysoper
Next Topic: ASM add disk issue
Goto Forum:
  


Current Time: Thu Oct 23 07:55:56 CDT 2014

Total time taken to generate the page: 0.09319 seconds