Managing Redo Log Files

Managing online redo log files is not something that is done very often, but it can have dramatic impact upon a database’s performance. Often when a database is initially created, DBAs may specify too few groups or size the members too small. Or if additional volumes are available for database use, the DBA may need to add additional members across different locations for availability purposes. Whatever the reason, there are times when a DBA needs a friendly and efficient interface for managing all aspects of online redo log files. TOAD provides such a screen in the Redo Log Manager screen shown in Figure 6.60 and located on the main menu at DBA|Redo Log Manager.

Figure 6.60. TOAD Redo Log Manager screen— iconic.

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.