Hello to all, that's my first discussion in this wonderful community.
I need to know the number of table rows selected (read) from an Oracle user, in a given period (e.g. a week). When i write table rows, i mean any table rows selected by my user in the whole instance.
I know i need to enhance audit trail on this user (standard audit options do not register this type of activities, such as SELECT statement), but once i do it, where can i find this information? Is there a query i can use?
Thank you.