How To Generate the AWR reports in oracle database?

Rameshdba.com

Summary: in this tutorial, you will learn how to generate the AWR report in the oracle database, 

Subtitles:

  • What is the AWR report?
  • How to generate the AWR reports?
  • What is the AWR report?
  • AWR stands for Automatic Workload Repository 
  • AWR report has data on database activity between two points in time – two snapshots. 
  • The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for the oracle database.
  • It's easy to understand Where exactly struck the SQL queries.
  • AWR reports providing an excellent recommendation for an SQL plan for that particular SQL statement.
  • How to generate the AWR reports?
  • Log in to the database server.
  • Set the ORACLE_HOME environment variable.
  • Change the directory to $ORACLE_HOME/rdbms/admin.
  • Login sqlplus utility
  • Execute the script 'awrrpt.sql' like @awrrpt.sql;. This script resides at $ORACLE_HOME/rdbms/admin.


  • Execute the below command and select the file formats



  • select the HTML then choose num of days You want 



  • Once You choose the days it will provide the snapid start- end.



  • select begin_snap and end_snap both.

  • Then select the name of that folder for your convince 



  • Once run the scripts You will get the report's same location.


  • Please find the report for your reference !!


                                                            Thanks for your time!!




0 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

by
Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...
Image