Oracle – AWR, ASH and ADDM reports for RAC

By Ravi Karamsetty | August 19, 2015 |

Following are the scripts that can be executed as sysdba in order to get the AWR, ASH and ADDM reports on Oracle RAC: SQL script for getting AWR Report on RAC database: SQL>@$ORACLE_HOME/rdbms/admin/awrgrpt.sql SQL script for getting AWR Report for  single instance: SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sql SQL script for getting ASH Report on RAC database: SQL>@$ORACLE_HOME/rdbms/admin/ashrpti.sql SQL script for … Continue reading “Oracle – AWR, ASH and ADDM reports for RAC”

Read More

Which Mobile Platform Should I Support? - dwaprince - can you give suggestion to list out all files which are replication factor is 3 through a command line

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Excellent

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Good

TNS SQL .NET Connectivity Issues – Troubleshooting and Diagnosing Tips - dwaprince - Good