Toad World® Forums

Oracle Log files

How do i find the log files

the question is a little vague so I’m not sure exactly what you’re after, but…

You can go to main menu: Database -> Administer -> Oracle Parameters to see where the archive log folders are:

To find them easily, Type “archive” into the filter box. Then you’ll see what folder they are in on the server under “log_archive_dest” and maybe also the log_archive_dest_nn. You’ll have to go to the server to get to the actual files. Toad doesn’t do anything with them.

Or if you want to see where you redo logs are, go to Database -> Administer -> Redo Log Manager.

To get an idea of how often your log switches happen, go to Database -> Diagnose -> Low switch frequency map.