Following are the Performance Engineering Interview Questions Set #3. Q. 11 How to identify SQL statements consuming the most CPU resources in the Database? Ans: Fetch/Extract the AWR report for the problematic period, go to the section ‘SQL Statistics’ and then click the ‘SQL Ordered by CPU Time’ link. This will take you to the … Read more
Following are the Performance Engineering Interview Questions Set #2. Q. 6 What is an AWR? Ans: The full form of AWR is Automatic Workload Repository. It is a built-in repository in the Oracle database that collects, processes and maintains performance statistics. AWR captures data on system load, wait events, SQL execution and more at regular … 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
Present you the Garbage Collection Quick Guide: Garbage Collection Basics: Garbage Collection Activities: Performance Metrics targeted by GC algorithms Type of Garbage Collector: Comparison GC Throughput Latency Memory Footprint Serial Low High Low Parallel High Medium Medium CMS Medium Medium Medium G1 High Low Medium Z High Very Low High Shenandoah High Very Low High … Read more