Home » RDBMS Server » Performance Tuning » table access count
table access count [message #293237] Fri, 11 January 2008 05:16 Go to next message
Messages: 128
Registered: October 2005
Location: UK
Senior Member

Is there a way (v$ view, SQL query) to find out how many times a table has been accessed since DB was started or between certain time period?

Thank you.
Re: table access count [message #293242 is a reply to message #293237] Fri, 11 January 2008 05:47 Go to previous message
Michel Cadot
Messages: 65152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you have to enble auditing for this.

Previous Topic: multiple dbwr processes and multiple archver process
Next Topic: works in test env but very slow in production
Goto Forum:

Current Time: Tue Aug 22 06:17:36 CDT 2017

Total time taken to generate the page: 0.06985 seconds