There is the case (db is 10g):
We have some tables which we wanna audit. If any user make "mass" select (e.g. 100 or more records per time) - we'd like to know he did it. Normal activity is selecting one record per time. What would be the best tool to reach it?
Please use DB auditing feature, for more details…
Master Note For Oracle Database Auditing (Doc ID 1299033.1)
How to Setup Auditing (Doc ID 1020945.6)