Subscribe
30/01/2025
Achieve Database Optimization Without Abandoning Normalization
High concurrency, scattered queries, unpredictable data growth—the usual suspects. When everything’s slow and your tables are bursting, you face a tough choice: enforce strict normalization for pristine data integrity or optimize aggressively to wring out every last drop of performance. Overly normalized schemas may lead to a maze of joins and hamper speed under heavy loads. Performance-driven shortcuts—like denormalizing key data—can bloat storage and complicate updates. Balancing database optimization and normalization isn’t always straightforward, but it is possible.
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.
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…
18/07/2024
The Replication Dichotomy: Logical vs Physical Replication
There’s a peculiar habit among some database professionals occasionally to toss logical and physical replication into the same bin. One might as well say socks and shoes are the same because, after all, they both go on your feet, right? But as anyone who’s tried wearing socks in the snow can attest, similarities on the surface can hide a whole universe of differences between logical vs physical replication.
Blurring together logical and physical replication, or neglecting their differences can lead to inefficient data management strategies. Each method has its merits and ideal scenarios of use. Knowing just when to apply each one—understanding their unique roles in the spectrum of data management—helps avoid unnecessary workload, optimizes performance, and ensures data integrity.
04/07/2024
Execution Plan Changes in SQL Server: Reasons and Solutions
Executions plan—complex maps charted by the SQL Server optimizer, dictate the most efficient route for data retrieval. However, the plans are not static. They morph and adapt, influenced by a host of factors ranging from data volume changes to system upgrades. Each of the execution plan changes in SQL Server has the potential to sway performance dramatically.
Understanding the reasons behind these shifts, and more importantly, how to effectively manage them translates to maintaining optimal performance in SQL Server environments.
27/06/2024
The Domino Effect in the T10 Database on g1rush Server
Performance issues rarely occur in isolation. Often, a single problem can trigger a cascade of related issues, each compounding the overall impact on the system. This case study explores such a scenario in the T10 database on the g1rush server.
20/06/2024
From Analysis to Action: Overcoming Execution Plan Changes
Execution plans choose the way in which SQL queries are executed by the database engine. As such, they are a difference between a smoothly running database and one that stumbles under load. Sometimes, an execution plan changes, for various reasons—often silently and without warning—and the far-reaching fallout can be huge.
The most immediate impact seen as the execution plan changes is a decline in query performance. A query that once ran smoothly in milliseconds might, due to an altered plan, start consuming seconds. This increase in query time can cascade into longer load times for applications, frustrated end-users, and severe financial repercussions in high-stakes environments such as financial trading platforms or real-time data services.
06/06/2024
The Most Important Database Performance Metrics
If no one sees the database issues, do they really happen? – Contrary to the popular philosophical dilemma, this question can be answered quite easily – Absolutely yes. Unseen or unmonitored problems in database systems do occur and can indeed cause significant disruptions. It doesn’t matter if they’re not immediately apparent. Without monitoring of the database performance metrics and proactive management, these underlying issues can compound, leading to decreased performance, potential data loss, and even system failures that by their nature demand urgent and often extensive interventions to rectify.
The cost of ignoring database performance metrics is just too great.
05/04/2019
DBPLUS at the mbuf congress in Karlsruhe
Congress is a meeting of nearly 200 member companies from the IT industry and a popular network platform. Mbuf is…
28/12/2018
SQL Saturday in Linz, Austria
SQLSaturday is an all-day conference and training event which is taking place Friday, January 18, 2019 for the sixt time…
14/12/2018
IT Tage 2018 in Frankfurt
We spoke during the Frankfurt IT Tage 2018 about SQL Query Performance Monitoring and Analysis under Oracle and Microsoft SQL…
21/11/2018
webtelligence will present an Showcase Webcast: the DBPLUS Performance Monitor
On Monday, December 10, MSDynamicsWorld.com is holding an international Solution Showcase webcast. There we will be demonstrating new options for…
23/10/2018
DBPLUS solutions at the DOAG 2018 conference
From 19 to 23 November 2018, this year’s edition of the DOAG German Oracle User Group conference will be held…
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.
22/08/2024
Performance Monitor Changes in Version 2024.2—Part I: Online Monitor
Statistics can lie—” The only statistics you can trust are those you falsified yourself” This old adage attributed to Sir Winston Churchill rings especially true if you’re dealing with daily database monitoring. When data is only captured in 15-minute intervals, transient issues that can severely impact performance might slip through the cracks, unnoticed and unaddressed until they’ve already caused significant problems.
In the newest release of the DBPLUS PERFORMANCE MONITOR, we’re extremely excited to show you the solution that the new functionality brings to the table.
04/04/2024
Performance Monitor (Release 2024.1)
In April 2024, we published another version of the Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL, and SAP Hana…
24/01/2024
New version Performance Monitor (Release 2023.4)
In December 2023, we released the next version of Performance Monitor application for Oracle, Microsoft SQL Server, PostgreSQL and SAP…
05/07/2023
New version Performance Monitor (Release 2023.2)
On July 5, 2023, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…