PerfMatrix Overview The word vector may sound like something out of a math textbook, but the truth is that vector is an important idea found in many areas of science, especially in artificial intelligence (AI). Understanding what a vector is can help you see how AI makes decisions, learns patterns, and even recognizes your voice or … Read more
Overview Introduction to Linear Algebra is an important topic that helps us understand many modern technologies, especially artificial intelligence. At first, it might seem like just another math subject, but it plays a big role in how machines learn, recognize patterns, and make decisions. Without linear algebra, things like voice assistants, self-driving cars, and even … Read more
Following are the Performance Engineering Interview Questions Set #14. Q. 66 What is the difference between ‘db file sequential read’ and ‘db file scattered read’ wait events? Ans: The ‘db file sequential read’ indicates single-block reads, often associated with index lookups whereas ‘db file scattered read’ involves multi-block reads, typically from full table scans or … Read more
Many free videos and learning tutorials related to Performance Testing are available on YouTube. Some video series are specific to performance testing and APM tools and share in-depth knowledge free of cost. Below are the links for those tutorials: Basics: Tools: APM Tools:
In AWR, the ‘Instance CPU’ table comes under the ‘Report Summary’ section. Refer to the below figure: To analyse the ‘Instance CPU’ section, you must Look at the Host CPU and Instance CPU sections. The key things to look for are the values “%Idle” in the “Host CPU” section and “%Total CPU” in the “Instance … Read more
In AWR, the ‘Host CPU’ table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the ‘Host CPU’ table of an AWR report: CPUs The number of CPUs is the product of the number of cores and threads available on the database server. Formula: CPU = Number … Read more