Following are the Performance Engineering Interview Questions Set #8. Q. 36 What are the Oracle Database memory caches that affect performance? Ans: The main Oracle Database memory caches that affect performance include: Q. 37 What…
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…
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…
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…
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…
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…