New version Performance Monitor (Release 2021.2)

On July 9, 2021, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases. The most important functions added in the application are: the improvement of collecting information about parsing schema and owner for queries in the Oracle database, generating reports for Anomaly Monitor for all platforms, implementing a parser for the PostgreSQL platform.

Collecting information about OWNER and PARSING SCHEMA of inquiries (Oracle)
The DBPLUS Performance Monitor application collects information about queries performed in the monitored database. In the latest version of the application, we have added information about:

PARSING SCHEMA – the scheme from which the query was run
OWNER – owner of the object on which the query is performed

This information is collected during the snap procedure once every 15 minutes from the system views of Oracle databases. Adding additional information is the next step leading to the currently developed DBPLUS Query Advisor mechanism, which in the future will automatically display information on possible query optimization in a given database.

Generating reports of problems detected by Anomaly Monitor (Oracle, Sql Server, PostgreSQL)
As part of the Anomaly Monitor functionality, which presents information about the problems detected in the monitored database, a reporting module has been added. The module generates documents in * .docx format. Generating a report is possible on the basis of templates added by default or by configuring your own report. The report contains information about main database parameters as well as presents information about performance problems that were detected by Performance Monitor applications in the period for which the report was made.
Query parsing on the PostgreSQL platform
In the latest version of the application for PostgreSQL databases, we have added a query parser. This functionality is based on the analysis of components of query objects (tables, indexes). Thanks to the query parsing mechanism, it is possible to quickly verify which tables or indexes and which columns are used in the analyzed query. The parsing mechanism is available after clicking on the Show Plan Objects for link visible in the query plan.

Access to 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 version 2021.2:

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

Oracle:

Microsoft SQL Server:

PostgreSQL:

Artur Boguszewski

Software Architect

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.

Database Security in the Era of IoT and Edge Computing

Every refrigerator, smartwatch, or industrial sensor that connects to the internet streamlines our lives, Yes, that’s true. However, by doing so, they also add to the growing pile of concerns in regard to database security. As we integrate more devices and decentralize data processing, the potential for breaches expands exponentially. This seismic shift demands a reimagined approach to security. One that transcends conventional methods and addresses the issues of protecting data. Even among the expanse of IoT devices and edge nodes.

09/07/2021