Following are the Performance Engineering Interview Questions Set #11. Q. 51 In the AWR report, where can you find information about PGA memory usage? Ans: The “Memory Statistics” section, specifically under “PGA Aggr Target Stats,”…
Following are the Performance Engineering Interview Questions Set #10. Q. 46 What is a Large Pool in Oracle DB? Ans: The large pool is an optional memory area intended for memory allocations that are larger than is…
Following are the Performance Engineering Interview Questions Set #9. Q. 41 What is Library Cache in Oracle DB? Ans: The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache…
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…