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

Databases in 2025: New Architectures, Smarter AI, and Stronger Security

The year is 2025, and the databases that once seemed so clever have gotten old and cranky. They’re no longer content with sitting there, quietly holding onto rows and columns like good little librarians. Nope. Now they’ve got opinions. They’ve got styles. They’ve got ideas about how to organize themselves, how to spread out across the clouds, how to speak human language, and how to lock the door behind you when you’re done rummaging through their shelves.

The old way of doing things — shoving everything into a single warehouse and hoping for the best — is about as appealing as canned spinach. So, what will we do instead?

The Intersection of Quantum Computing and Database Management

Databases are the engines powering our digital age, storing, managing, and retrieving the vast amounts of data generated every second. For decades, they’ve relied on classical computing to do the heavy lifting, using algorithms and hardware that have become increasingly optimized but still face fundamental limits. As datasets grow larger and more complex, and as the demand for real-time insights and advanced security rises, it’s becoming clear that classical systems alone may not be enough to meet these challenges. What then? Two words: quantum computing.

ORA-12154: TNS:Could not Resolve the Connect Identifier Specified

Encountering the ORA-12154 error can halt productivity and disrupt critical database operations. This error arises when Oracle cannot resolve a specified connect identifier, often due to configuration oversights or network issues. Without an understanding of the root causes, users find themselves stumbling in the dark, trying to rectify an issue without knowing where to start

09/07/2021