23/01/2025
Database Performance Tuning – the Sensible Way: Collaborative Strategies, Clear Metrics, and Tested Changes
Databases are either the invisible workhorse that keeps everything running smoothly or the ticking time bomb that wakes you at 3 a.m. with catastrophic slowdowns. There’s rarely a middle ground. Performance tuning makes all the difference—especially when you combine actual metrics, meaningful collaboration, and a dash of common sense. A few checks here and there can save hours of panic later on, and nothing beats a stable, responsive system for making you look like the hero of the IT team.
Of course, it helps to have a reliable way to see what’s going on under the hood while performance tuning, keep everyone on the same page, and avoid applying fixes blindly. After all, a well-tuned database is happier, and so are the people who rely on it every day.
16/01/2025
ORA-01555: How to Preserve Undo Data and Keep Queries Consistent
Oracle database has many problems and often recurring ORA-01555 is one of them. It is known as the “snapshot too old” error, and occurs when Oracle cannot provide a consistent read of the data that existed at the query’s start time. Oracle attempts to use undo data to roll back any changes made after the query began. If that undo information has been overwritten or otherwise lost, Oracle can no longer reconstruct its older version. This leads to the ORA-01555 exception.
09/01/2025
Performance Monitor 2024.4: What’s New
Managing database performance is rarely straightforward, and the demands only keep multiplying. In response, DBPLUS Performance Monitor 2024.4 introduces new features that help you see exactly how queries behave across different platforms, track CPU usage at a glance, refine how and when alerts reach you, and unify session data.
If you prefer a monitoring tool that shows critical insights with less hassle, the latest version deserves your attention.
02/01/2025
ORA-06512 Explained: Locating PL/SQL Errors the Right Way
ORA-06512 is often misunderstood as the primary cause of an Oracle error, when in reality it just pinpoints where an exception occurred in your PL/SQL code. The true issue usually lies in a preceding error, such as an unhandled exception or data mismatch, hidden earlier in the stack.
In contrary to ORA-12154 or ORA-00600—which typically point to direct connectivity or internal database failures—ORA-06512 simply acts as a line-number reference. It tells you where an error occurred, not why. But let’s start from the beginning.
19/12/2024
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?
24/10/2024
On-site Database Events to Attend in 2025
From Wales to London, Orlando to Stockholm, and beyond, 2025 promises a smorgasbord of data-driven sagas across various locales. Here’s a peek at the not-to-miss database events set to sprinkle some intellectual stardust on your next year’s calendars.
08/02/2021
Manage your database performance and data accessibility today…alive tomorrow.
Webinar date: Wednesday 10th March, 11:00am CET Your business growth demands efficient IT services with upgrades and enhancements delivered on…
16/09/2020
Actinium Consulting GmbH and DBPLUS enter into partnership
Actinium Consulting GmbH specializes in business intelligence and ERP. The software developments by DBPLUS for database optimization and real-time data…
07/01/2020
dbi services with real-time replication using the DBPLUS Data Replicator
dbi services described our solution for real-time data replication on their blog. dbi services was founded in 2010 and is…
16/10/2019
Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg
Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg You wish to become more familiar…
23/01/2025
Database Performance Tuning – the Sensible Way: Collaborative Strategies, Clear Metrics, and Tested Changes
Databases are either the invisible workhorse that keeps everything running smoothly or the ticking time bomb that wakes you at 3 a.m. with catastrophic slowdowns. There’s rarely a middle ground. Performance tuning makes all the difference—especially when you combine actual metrics, meaningful collaboration, and a dash of common sense. A few checks here and there can save hours of panic later on, and nothing beats a stable, responsive system for making you look like the hero of the IT team.
Of course, it helps to have a reliable way to see what’s going on under the hood while performance tuning, keep everyone on the same page, and avoid applying fixes blindly. After all, a well-tuned database is happier, and so are the people who rely on it every day.
09/01/2025
Performance Monitor 2024.4: What’s New
Managing database performance is rarely straightforward, and the demands only keep multiplying. In response, DBPLUS Performance Monitor 2024.4 introduces new features that help you see exactly how queries behave across different platforms, track CPU usage at a glance, refine how and when alerts reach you, and unify session data.
If you prefer a monitoring tool that shows critical insights with less hassle, the latest version deserves your attention.
19/12/2024
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?
14/11/2024
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.
26/09/2024
From Clustered to Specialized: Types of SQL Indexes and When to Use Them
Considering the sheer volume of data slugging through the digital pipelines, knowing your indexes shou be your bread and butter. Here, we’re slicing through the thick crust of complexity to expose clustered and non-clustered indexes and their cousins.
Why bother? Because we live at the age of instant grafitication. The speed at which you can retrieve data can be the difference between leading and trailing behind. That’s why we will be going through the ins and outs of clustered and non-clustered indexes and their specialized kin. On they way, keep in mind that each type has a role. For every one there is a specific scenario where its purpose becomes the most obvious.
It’s about knowing who to tap for the performance you crave, at precisely the right moment.
16/09/2020
Actinium Consulting GmbH and DBPLUS enter into partnership
Actinium Consulting GmbH specializes in business intelligence and ERP. The software developments by DBPLUS for database optimization and real-time data…
31/03/2020
dbi services and DBPLUS enter into a partnership
Delémont, March 31, 2020 – dbi services has secured a partnership with DBPLUS, a software development company which specializes in…
16/10/2019
Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg
Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg You wish to become more familiar…
16/07/2019
DBPLUS on “IT Tage” in Frankfurt
“Everything under one roof!” is the motto of the IT-Days 2019 from December 9th to 12th in the Cape Europa,…
17/06/2019
DBPLUS expands partner network
Another companies from the CEE region joined the group of DBPLUS partners. As a result, DBPLUS Clients gain access to…
09/07/2019
Performance Monitor (release 2019.2)
On June 28, 2019, we released a new version of Performance Monitor for Oracle and Microsoft SQL Server databases. The…
20/03/2019
Performance Monitor (release 2019.1)
March 16, 2019, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…
21/12/2018
Performance Monitor (release 2018.4)
December 21, 2018 we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…
08/10/2018
Performance Monitor (release 2018.3)
October 8, 2018, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…
08/06/2018
Performance Monitor (release 2018.2)
August 6, 2018, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…