How can I see the controlfiles for my database? I do not know,
and I want to find the location of my control files. I want to
controlfile, and I need to know which disks my controlfiles reside
: You can use this SQL*Plus commands to find the Oracle control file
SQL> show parameter control_files
SQL> database backup controlfile to trace
You can also use SQL*Plus scripts against the
For RAC, use the
col value format a41
name = 'control_files';
"control file name"
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.