PerfMatrix 
Following are the Performance Engineering Interview Questions Set #7. Q. 31 What is Redo Size? Ans: In AWR, Redo size indicates the amount of DML (Data Manipulation Language) activity i.e. insert, update or delete operations that occurred in the database during the specific period. Q. 32 What is the ‘Log Buffer’? Ans: The Log Buffer … Read more
Following are the Performance Engineering Interview Questions Set #6. Q. 26 What does the low value of the soft parse ratio indicate? Ans: Under ‘Instance Efficiency Percentages (Target 100%)’, check the value of Soft Parse % (or Soft Parse Ratio), if the value is low, then it indicates there could be a parsing issue. A … Read more
Following are the Performance Engineering Interview Questions Set #5. Q. 21 What is PGA? Ans: Program Global Area or PGA is a non-shared memory area used for the server process. PGA is only read and written by Oracle code acting on behalf of that process and used for operations like sorting and hashing. There is … Read more
Following are the Performance Engineering Interview Questions Set #4. Q. 16 What is the significance of the ‘Execution Plan’? Ans: The execution plan provides details about the data fetching operation. It describes how the data is fetched from the database by the SQL statement. It explains the operations like table scans, index scans, joins etc. … Read more
Following are the Performance Engineering Interview Questions Set #3. Q. 11 How to identify SQL statements consuming the most CPU resources in the Database? Ans: Fetch/Extract the AWR report for the problematic period, go to the section ‘SQL Statistics’ and then click the ‘SQL Ordered by CPU Time’ link. This will take you to the … Read more
Following are the Performance Engineering Interview Questions Set #2. Q. 6 What is an AWR? Ans: The full form of AWR is Automatic Workload Repository. It is a built-in repository in the Oracle database that collects, processes and maintains performance statistics. AWR captures data on system load, wait events, SQL execution and more at regular … Read more