Database Administration (MOSC)

MOSC Banner

Specific row monitoring to determine SELECT frequency.

edited Jan 26, 2010 3:57AM in Database Administration (MOSC) 5 commentsAnswered
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.
SELECT * FROM tbl_customers;
SELECT lastname, firstname, phone FROM tbl_customers WHERE firstname = 'DARIUS';


Regards,
John Penrod

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center