I have a Oracle 734 database on windows Nt.Usually only 10 mb of archives are generating per day.But Now it is Around 75mb of archives per day since 10 days.Is it a serious concern.What should be the problem and how to resolve it.Please let me know ASAP.It's a Production database.
Check if you have too many rollbacks. If some transactions run for a period of time and then do a rollback, you could be generating some extra redo entries as the aborted transactions will be executed again & again.
The best thing will be if you can get hold of "Top Sessions" tool of Oracle Enterprise Manager. This has a very good GUI that shows you detailed information about the current sessions and their activities.
It actually uses the following objects to gather the info --
Also make sure that you didn't create any Management Server's repository on this database. MAnagement server pings the database at a set interval to check the status of the services you are monitoring (this causes transaction information).
To track the current transactions, check in the V$TRANSACTION view, in this you can find the session address and you have the timestamp also. Using this and V$SESSION you can find out the username and kill that session, if required.