Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Monitor table access

Clemenss
Active Contributor

‎10-17-2006 1:39 PM

0 Kudos

Hi,

we are in a cleaning process. Althoug nobody gets hurt by unnused customer tables, the customer wants to know about tables that are nort used.

One approach is a where-used-list. OK, done.

Another approach is to analyze table access statistics. AFAIK the database collects statistics from database accesses. From those statistics the system gains information to optimize table access.

Now my question: Where can I find (programatrically or via transaction/report) information about table access?

TIA,

regards,

Clemens

1 REPLY 1

Former Member

‎10-18-2006 12:36 AM

0 Kudos

U have the list of custom related tables. Goto SE11 & using the custom table check where-used-list. It displays where all the table has been used. If the table has not been used anywhere or else not related at all to a program which is not needed, these all tables can be eliminated from the system.