Specific row monitoring to determine SELECT frequency.
Does anyone know of an Oracle utility or an easy way to determine how many times a specific row is being accessed in a table? For example, I want to know how often Darius Jones is being selected or updated in the customers table, regardless of either of the following sample SQL.
Regards,
John Penrod
SELECT * FROM tbl_customers;
SELECT lastname, firstname, phone FROM tbl_customers WHERE firstname = 'DARIUS';
Regards,
John Penrod
0