Conversely, if you have three default redo log files created on the database, the archives can’t keep up and the database has to wait for the archver daemon process to catch up. Too many checkpoints put a high load on the buffer cache and IO sub system. If a DBA did not notice how many archive logs were being generated for each hour, the database might end up with performance problems. If there are numerous changes to the database, we see the number of archive log files generated grow, or as some call it as “excessive redo generation”. I would like introduce in this article, some of my favorite, more commonly used interfaces of TOAD 9.0. Tools like TOAD are most user friendly and have less overhead. In situations like this, or for that matter anything that users request on production databases that are prone to human errors, are situations where GUI tools are vital since they lessen the possibility of human mistakes. Instead, they ask that I let them know what statements were executed in the database for the period in question to investigate. Let us say, I see unusual activity on my production database and ask the application community if there were any changes on their side, they reply that they are not sure exactly what is going on. That being said, it is not necessary to be familiar with all of the command line interface utilities that we use for ongoing issues. For example, when you have to recover the production database, you will not have time to look at manuals for database recovery commands. It is good to have a knowledge of some of the most frequently used commands for these interfaces, to troubleshoot any production issues when you do not have the luxury of extra time to look at the manuals or online knowledge base. Oracle has command line interface tools for all of it components, such as ASMCMD for Automatic Storage Management (ASM). Moreover, command line interfaces are easy and certain. As a Production or Development DBA, we’d better know all the syntax of the command line interface (CLI) utilities whether it is sqlplus or old srvrmgr, which Oracle no longer supports.

Toad for oracle