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… Performance Engineering Interview Questions #7
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… Performance Engineering Interview Questions #6
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… Performance Engineering Interview Questions #5
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… Performance Engineering Interview Questions #4
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… Performance Engineering Interview Questions #3
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… Performance Engineering Interview Questions #2