Home / Database Scripts / Generating AWR Reports

Generating AWR Reports

Generating AWR Reports

You can generate AWR reports by running SQL scripts, as described below :-

# Generating an AWR Report

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

 

# To generate an AWR report on a specific database instance:

@$ORACLE_HOME/rdbms/admin/awrrpti.sql

 

# To generate an AWR report in an Oracle RAC environment: 

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

 

#To generate an AWR report on a specific database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgrpti.sql

 

# To generate an AWR report for a particular SQL statement:

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

 

# To generate an AWR report for a particular SQL statement on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

 

#To generate an AWR Compare Periods report:

@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

 

# To generate an AWR Compare Periods report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

 

# To generate an AWR Compare Periods report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

 

# To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql

 

# To generate an ASH report:

@$ORACLE_HOME/rdbms/admin/ashrpt.sql

 

# To generate an ASH report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

# To generate an ASH report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Oracle Database Monitoring Queries

QUERY TO CHECK SIZE OF ALL TABLESPACES

Leave a Reply