AWR

Performance Engineering Interview Questions #9

by
Performance Engineering Interview Question 9

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

Performance Engineering Interview Questions #8

by
Performance Engineering Interview Question 8

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