OraFAQ Forum: Server Administration » possible to find out last access to a table?

Home » RDBMS Server » Server Administration » possible to find out last access to a table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

possible to find out last access to a table? [message #526616]

Tue, 11 October 2011 23:17

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?

Report message to a moderator

Re: possible to find out last access to a table? [message #526617 is a reply to message #526616]

Tue, 11 October 2011 23:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: possible to find out last access to a table? [message #526621 is a reply to message #526616]

Wed, 12 October 2011 00:51

Michel Cadot
Messages: 68648
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

Report message to a moderator

Previous Topic:	SYSTEM, sysdba, sysoper
Next Topic:	ASM add disk issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 11:12:54 CDT 2024