What is Execute to Parse ratio OR Execute to Parse %? Every query needs to be parsed before it gets executed. If some queries are quite frequently used, a good design will be to reuse the parsed query. That means it will not parse the same query again. In an ideal world, execution should be … Read more
In AWR, the ‘Instance Efficiency Percentages’ table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the ‘Instance Efficiency Percentages’ table of an AWR report: Buffer Nowait % (Buffer Nowait Ratio) This metric provides the percentage of availability of the data buffers. This ratio gives an idea … Read more
In AWR, the Load Profile table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the Load Profile table of an AWR report: DB Time(s) DB Time(s) is the number of average active sessions during the given period. The active sessions are calculated by dividing the ‘DB … 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