Hello, in Oracle 184.108.40.206, RHEL 6 x86-64, how can I tell what tables have the highest transaction activity?
Picked "Objects" because I could not find a space related to performance tuning
What version of Oracle are you running (standard or enterprise)?
Easist system is to run an AWR or statspack report. If you run either of these you will see sections on segments (so segments by logical reads, physical reads) which is easily digestible.
v$segment_statistics will also give you a breakdown on segment access.