AWR – Execute to Parse Ratio – Analysis
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…
AWR – Instance Efficiency Percentages
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…
AWR – Load Profile
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)…
Performance Engineering Interview Questions #12
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…
How to start/stop Weblogic Server?
As a performance tester, you must have a basic knowledge of servers and services like how to start/stop the Oracle WebLogic Server. This article will help you to get a step-by-step understanding of the process.…
Parallel Garbage Collector (GC)
The Parallel Garbage Collector (GC) or Throughput Collector is the default garbage collector used by JVM. The parallel garbage collector works the same as the serial garbage collector. The only difference between serial and parallel…