Oracle 9i - number of transactions per table/user
I'm troubleshooting a 9i (on AIX) database that's performing badly.
In the process I've spotted a few tables that I do not recognise that are rather large and fragmented and I'm curious to know how frequently these are being used.
Is there a way I can pull figures for how often certain objects are accessed? And the associated load these put on the DB?
Thanks in advance, finding the site very useful!
1) Check that your statistics are up to date.
2) Install the STATSPACK package (?/rdbms/admin/spcreate).
3) Also, the number of transactions per table could be monitored by setting "MONITORING" on such tables.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
if you like you could use logminer.
it will help you find the operations about the tables you want check.
becase the operation use archivelog,
1、if few impact the database
2、long time data have more persuasion
Click Here to Expand Forum to Full Width