Hi All,
DB version is 11.2.0.2. Archive generation was high in the database for two days. Using log miner saw the contents of few logs and most of them are like
SQL> select operation,count(*) from v$logmnr_contents group by operation;
OPERATION COUNT(*)
-------------------------------- ----------
START 351
COMMIT 350
ROLLBACK 1
UPDATE 21
INTERNAL 302
UNSUPPORTED 440
INSERT 7288
SQL> select operation,count(*) from v$logmnr_contents group by operation;
OPERATION COUNT(*)
-------------------------------- ----------
DDL 49
COMMIT 1324
START 1324
UPDATE 52
DELETE 442
INTERNAL 12655
UNSUPPORTED 5417
INSERT 465
Lot of commits in one log and lot of inserts in other log. When i checked the sql all where like insert into sys.wrh$_* tables. Commit and start statements were like
START
set transaction read write;
COMMIT
commit;
Trying to find Why is that large inserts on sys.wrh$ tables and commits happening in the database? Need few suggestions in finding it.
baskar.l