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
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. How to stop the Weblogic Server? Step 1: Browse the Oracle Weblogic Server Console. It would be best to have … Read more
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 garbage collectors is that serial garbage collector uses a single thread for the garbage collection process while parallel garbage collector uses multiple threads for … Read more
The Serial Garbage Collector (GC) is the simplest and oldest garbage collector in Java. It derives its name from performing all its work on a single thread. Main Operation Single thread to perform Garbage Collection (GC) How does Serial GC work? Used For: Advantage: Disadvantage: Implementation: -XX: +UseSerialGC Tuning serial GC: Conclusion A straightforward and … Read more