New answers tagged oracle-asm
The recommendation is to have log switches occur a few times an hour. If you have a 100 log switches an hour with 50MB redo logs, you need e.g 1GB redo logs for 5 log switches/hour. 100*50 MB redo/hour for a 6.5GB database is unusually much though. You can add the new logs, e.g: ALTER DATABASE ADD LOGFILE THREAD 1 SIZE 1G; ALTER DATABASE ADD LOGFILE THREAD ...
Top 50 recent answers are included