Performance Monitor (release 2018.1)

15 April 2018, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most important functions added in the application are: improvements in generate PLAN GUIDE script, improvements in query search by FIND SQL and changes in session view.

Generate PLAN GUIDE
In the functions that enable the preview of the execution plan, i.a.: Session, Performance-> Sql Analyze, Performance-> Sql Details an improvement was made to generate the PLAN GUIDE script. This function is particularly useful in situations where the database engine changes the execution plan to a worse one. Very often when the plan changes, the execution time increases and the slow-running query can be a source of other performance problems (e.g. extended transaction, locks increase). When user put the plan on the PLAN GUIDE mechanism, they set a definite execution plan on which the query should run. The upgrade is available for SQL Server.

Improvements in query search
In the new version for Oracle and Microsoft SQL Server, the search method for queries using the FIND SQL function available in the SQL Details screen has been extended. The method of display additional statistics for query search has been modified. In each tab information about Elapsed Time, Cpu Time, number of executions, number of read, saved and returned blocks has been added. The analysis of queries that change the execution plan has also been improved. We added additional information grouped by modules: statistics with a summary for all performance plans on which the query worked, statistics with a summary for the slowest and fastest execution plan, comparison of the slowest and the fastest, estimation of the possible reduction of query time duration.

Page of the history of active sessions and sessions using UNDO
In the new application for Oracle, on the page of the history of active sessions and sessions using UNDO, cumulative indicators for monitored sessions have been introduced. In the main screen, information about the number of sessions using UNDO space, number of records / changes in Undo and size of changes in UNDO has been added.

Real Application Clusters (RAC) support
In the version for Oracle using RAC architectures in all tabs in the Sessions Screen (Sessions, Sort Usage session, Undo usage session, Session, History) in the results and filters a field with the instance ID has appeared. Add filter allows to display a session for a specific database instance.

Software updates
The DBPLUS software is updated at least 4 times a year. Customers have access to all updates when they have a license or maintenance service. With the upgrade to the latest version, the application will run faster and smoother. Each published version provides new functionalities that allow for easier management and performance improvement in the monitored database.

Detailed specification about changes in versions 2018.1.1:

The user documentation describes in an accessible way all the new functions available in the software

Oracle:

Microsoft SQL Server

Artur Boguszewski

Software Architect

Slash Your Cloud Database Bills: Proven Cost Optimization Tactics

Every silver lining has a cloud database, and in this case, it’s the bills that thunder down post-deployment. Indeed, 61% of enterprises chant the mantra of cost optimization, though the costs of cloud computing often spiral higher than expected.

What exactly is cloud database cost optimization? It’s our sherpa guiding us through the financial fog, ensuring we’re not pouring funds into the cloud abyss unnecessarily. It’s about fine-tuning our resources, so we pay only for the computing muscle we flex, ensuring our cloud ventures are both lean and mighty.

What’s New in DBPLUS Performance Monitor 2024.3

In the latest update of DBPLUS PERFORMANCE MONITOR, version 2024.3, we’re rolling out exciting enhancements and brand-new features. All are designed to elevate your database monitoring and management capabilities to the next level.

From real-time online monitoring improvements to smarter notification systems, we’re excited to walk you through what’s new, what’s better, and how these changes can make a big difference in managing your databases.

ORA-00600 Exposed: Understanding and Resolving Oracle’s Internal Error Code

The ORA-00600 error presents itself as a catch-all for a variety of unforeseen conditions that the Oracle database software cannot process normally. While not quite the apocalyptic “kiss of death,” it is certainly viewed with a mix of dread and resignation. It is Oracle’s not-so-subtle way of throwing up its digital hands and admitting that something has gone awry. And that something, wasn’t a thing that Oracle had every anticipated.

It could be said that encountering an ORA-00600 is a bit like hearing ominous rumbles from your car’s engine right after you’ve bragged about its reliability.

15/04/2018