I need to find the location of my redo logs
on my Oracle Windows system. I know that there is an
archived redo log file directory but I do not know how to
locate this redo log directory in Windows.
There are several ways to locate the archived redo log
filesystem and the redo logs on a windows system:
1 - Use SQL*Plus:
show parameter log
Also located in log_archive_dest and log_archive_dest_1
2 - Windows command: C:> dir /s
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.