Oracle Performance Insights A Blog By Kamlesh Ambre

Introduction Oracle Database's SQL Monitor is a powerful tool that provides deep insights into the execution of SQL statements, offering DBAs and developers crucial information for optimizing query performance. In this guide, we will delve into the various aspects of SQL Monitor, from understanding its default behavior to generating real-time and historical reports. Whether you're new to SQL Monitor or a seasoned user, this guide aims to provide valuable insights for effectively utilizing this tool. Default Behavior and Forcing Monitoring SQL Monitor automatically tracks SQL statements that run in parallel or consume at least 5 seconds of combined CPU and I/O time during a single execution. However, if you want to monitor specific SQL statements, you can include the `MONITOR` hint within the statement itself. For instance: SQL SELECT /*+ MONITOR */ count(*) from table you can force monitoring by setting the event "sql_monitor" at the system level: SQL ALTER SYSTEM SET...

ORAdiff – Your Ultimate Tool for Database Release Comparison In the dynamic realm of database management, staying updated and informed about the differences between database releases is crucial. This is where ORAdiff steps in, empowering you to seamlessly compare two database releases, whether they include patch bundles or not. Getting Started is a Breeze: 1. Click on the inviting menu icon located in the upper left corner of the page. 2. Explore a plethora of object types via the convenient left-hand navigation menu. 3. Handpick the Source and Target versions along with their respective patch levels. 4. Immerse yourself in the insightful report that follows. And, should you desire, apply a filter to tailor your experience. Witness the Magic of ORAdiff: Unveiling distinctions is the forte of ORAdiff. Whether it's identifying "new tables," highlighting "added parameters," exposing "changed columns," or shedding light on "removed privileges," O...

  🔔 Exciting News! 🔔 I'm thrilled to share that Oracle has just made a groundbreaking announcement that will surely benefit all technology professionals and cloud enthusiasts! Oracle has officially announced that they are offering FREE certifications for Oracle Cloud Infrastructure (OCI)! This is a game-changer in the world of cloud certifications. As the demand for cloud skills continues to skyrocket, Oracle has taken a bold step to empower individuals to enhance their expertise and stay ahead in the rapidly evolving technology landscape. By offering free OCI certifications, Oracle has opened up incredible opportunities for professionals to upskill, broaden their knowledge, and showcase their proficiency in Oracle Cloud Infrastructure. This move not only demonstrates Oracle's commitment to fostering a skilled and empowered cloud community but also reflects their dedication to supporting professionals on their career journeys. Obtaining an OCI certification will not only vali...

Introduction: In a complex Oracle Real Application Clusters (RAC) environment, unexpected issues can arise, leading to system instability and performance degradation. In this blog post, we will delve into a specific incident involving a CPU spike and resource hang that occurred during the execution of a high parallelism SQL job. We will analyze the root causes and explore potential solutions to mitigate such problems in the future. The Incident: On a particular day between 2:00 PM and 6:30 PM IST, an SQL job with a Degree of Parallelism (DoP) set to 200 was initiated on Node#3 around 2:12 PM IST. Soon after, the CPU Idle% dropped to single digits, reaching as low as 1% at 3:10 PM IST. This performance degradation led to Node#6 being evicted following a dirty detach reconfiguration. During the incident, it was observed that the shutdown process remained hung for an extended period, and the system was only restarted at 4:44 PM as per the Syslog. The Cluster Ready Services (CRS) stack cam...

  Oracle Enterprise Manager 13.5 Release Update 2 In Oracle Enterprise Manager 13.5 the custom dashboard option was not visible in the base 13.5 release. Dashboards allow you to visualize monitoring and management data in real-time, enable youto monitor your enterprise at a glance, and simplify potential problems resolution. With RU2, Enterprise Manager introduces out-of-the-box dashboards that provide a summary of the health, compliance status, grouping of your targets, and other details of your assets. The health and status data is organized, summarized, and presented graphically as various widgets. To further analyze and diagnose potential issues, you can drill down to more information from each widget. These dashboards can further be copied and customized as you see fit for your environment and your monitoring guidelines. you can find more information in the below doc. 13.5.0 Enterprise Manager Cloud Control Base Platform Monthly Release Update (RU) 2 (Doc ID 2822316....