Hi,
I have Oracle RAC 10.2.0.5 on windows server 2008 R2.
Architecture is : 2 node
A lot of archivelogs are being generated.
SQL> select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKS*BLOCK_SIZ
E)/1048576) MB,count(*) Archives_Generated from v$archived_log
2 group by trunc(COMPLETION_TIME,'DD'),thread# order by 1;
DAY THREAD# MB ARCHIVES_GENERATED
--------- ---------- ---------- ------------------
01-JUL-13 2 208566 217
01-JUL-13 1 64944 111
02-JUL-13 2 107949 121
02-JUL-13 1 111021 127
03-JUL-13 2 346615 352
03-JUL-13 1 13779 120
04-JUL-13 2 347229 351
04-JUL-13 1 13541 121
05-JUL-13 1 14566 122
05-JUL-13 2 346865 352
06-JUL-13 2 264122 272
06-JUL-13 1 37876 112
07-JUL-13 2 355024 359
07-JUL-13 1 14596 122
08-JUL-13 1 102837 126
08-JUL-13 2 131551 141
09-JUL-13 2 202378 212
09-JUL-13 1 71298 118
10-JUL-13 1 31232 57
10-JUL-13 2 102809 109
The size of each archive log is 1GB and i have
Size in GB MEMBER
---------- --------------------------------------------------
1 +ABC/xyz/onlinelog/group_6.11635.818786557
1 +ABC/xyz/onlinelog/group_6.3439.818786551
1 +ABC/xyz/onlinelog/group_8.8864.818786655
1 +ABC/xyz/onlinelog/group_8.1051.818786661
1 +ABC/xyz/onlinelog/group_1.4999.818786211
1 +ABC/xyz/onlinelog/group_1.3573.818786215
1 +ABC/xyz/onlinelog/group_9.767.818786837
1 +ABC/xyz/onlinelog/group_2.11831.818786237
1 +ABC/xyz/onlinelog/group_5.6420.818786537
1 +ABC/xyz/onlinelog/group_9.5647.818786833
1 +ABC/xyz/onlinelog/group_4.11847.818786513
1 +ABC/xyz/onlinelog/group_10.8228.818786853
1 +ABC/xyz/onlinelog/group_10.3776.818786857
1 +ABC/xyz/onlinelog/group_5.11845.818786531
1 +ABC/xyz/onlinelog/group_7.8920.818786633
1 +ABC/xyz/onlinelog/group_3.11848.818786485
1 +ABC/xyz/onlinelog/group_3.659.818786491
1 +ABC/xyz/onlinelog/group_4.11846.818786509
1 +ABC/xyz/onlinelog/group_2.9972.818786233
1 +ABC/xyz/onlinelog/group_7.11308.818786627
So if we analyze we are generating about 350 GB per day.
I have auditing enabled. Can this be the cause. How can i make sure auditing is causing excessive log switches.
I have gone through
Audit Ouch! | Oracle Scratchpad
Thanks