Skip to Main Content

Oracle Database Discussions


For appeals, questions and feedback about Oracle Forums, please email Please ask technical questions in the appropriate category. Thank you!

Audit - Rows selected by a user in a period

Sara_MarpSep 2 2021

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.

Post Details
Added on Sep 2 2021