Following are the Performance Engineering Interview Questions Set #13. Q. 61 How can lock contention be identified in an AWR report? Ans: High wait events like “enq: TX- row lock contention” or “enq: TM- contention” indicate lock waits. The “Segments by Row Lock Waits” section shows which segments are involved. Q. 62 What does the … Read more
Following are the Performance Engineering Interview Questions Set #12. Q. 56 What role does the buffer cache play in database performance? Ans: The buffer cache stores copies of data blocks read from the disk. A properly sized buffer cache reduces physical I/O by satisfying requests from memory, thus improving performance. Q. 57 How can you … Read more
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,” provides insights into PGA memory usage, including total PGA allocated and in-use statistics. Q. 52: What does a high ‘PGA … Read more
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 appropriate for the shared pool. It can provide large memory allocations for the following: Q. 47 What is Java Pool … Read more
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 contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles. The library cache … Read more
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 is Database Buffer Cache? The database buffer cache is the memory area that stores copies of data blocks read from data … Read more