on 12-13-2017 7:04 PM
Hi,
Is there a way to check they statistical details of usage for a given table.
We would like to see the data usage in all tables in our environment for a given period.
system table M_CS_ALL_COLUMNS has last accessed date information, but seems its not storing the history usage and user details. Also i couldn't identify weather table has been accessed by system or a user.. If we have a SLT enabled, then not sure if the table is accessed by system to replicate the data or a user has executed some data out of this table.
Thank you.
Hi,
You can check the monitoring view M_TABLE_STATISTICS for more details on table usage, or in the case of virtual tables, virtual table statistics are stored in the SYS.P_statistics_ system table. More information on system views can be found in the following reference guide: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US
In addition to these, you could also possibly also set up audit policies to check for specific actions related to accesses for tables: https://help.sap.com/viewer/b3ee5778bc2e4a089d3299b82ec762a7/2.0.02/en-US/db4b4fb4bb571014a22b8f893c...
Hope this helps!
Kind regards,
Amelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.