Question:
I want to run the awrrpt.sql report on windows to
generate an AWR report on Windows but I cannot locate my
rdbms\admin directory to get to the awrrpt.sql executable.
How do I generate an AWR report in Windows?
Answer: In
Windows, I use the dir /s
command is used to find the directory that contains the
awrrpt.sql executable. In this case, we search for the
rdbms directory to find the rdbms\admin location of the AWR
reports:
c:> dir /s rdbms
directory of
c:\oracleexe\app\oracle\prodict\12.0\server
12/19/2012 10:46 AM
<DIR> RDBMS
c:> cd
c:\oracleexe\app\oracle\prodict\12.0\server\rdbms
c:> sqlplus scott/tiger
SQL> @awrrpt
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
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
buy it
for 30% off directly from the publisher.
|
