EBS R12.1.3 with 11.2.03 db : too many archive logs generated.
Hi ,
I posted this in Database thread and it was suggested to move this to EBS board. I have an issue with archive log generation. I have 3 online redolog group of 1GB each. I expect the archive logs to be generated once every 15 or 30 mins. However, at present there are too many archive log generated in a day. The filesize are all over the place and it is getting difficult to manage.
Example
select to_char(first_time,'YYYY-MM-DD HH24:MI:SS'),(blocks*block_size)/(1024*1024) from v$archived_log
where first_time >= sysdate-1
TO_CHAR(FIRST_TIME, (BLOCKS*BLOCK_SIZE)/(1024*1024)