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

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.

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, you have to enble auditing for this.

Regards
Michel

Report message to a moderator

Previous Topic: What can I do to increase my Library Cache Hit stats
Next Topic: PL SQL Merge of tables - efficiency
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:14:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.