First page Back Continue Last page Graphics
…Control File Size…
Maximum log history records is 65535
- Oracle docs wrong on this – say no maximum
- Make sure CFRKT not too high if many log switches occur each day
Notes:
The initial number of records allocated for log switches is defined by MAXLOGHISTORY. The Oracle documentation says that the number of records that can be allocated is limited only by OS file size limitations or available disk space. This is incorrect. So, if your CFRKT parameter is high, say for example 300, and the number of log switches is also high, say 350 a day, then in 187 days (350 * 187) or less, you will have a problem. The problem is that your control file will have allocated the maximum 65535 slots for log switches, and the oldest record has not expired, meaning that Oracle has nowhere to put the new log switch data.