Subscribe
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.
30/05/2024
The Toughest Challenges and Problems with Oracle Database
As of today, the Oracle database is still the most popular database out there, with a rating score of 1,240.88. Considering all of the factors – its powerful and comprehensive features that cater to large-scale enterprise needs, it comes as no surprise.
However, having managed and used numerous Oracle databases over time, we’ve observed several recurring frustrations — problems with Oracle database that can pose significant challenges for its users. From the complex and often opaque licensing structure to high costs and aggressive sales tactics, taking care of the Oracle ecosystem requires constant awareness and a willingness to adapt, at any second.
23/05/2024
The Story of Locks by Application Issues
On the 20th of April, query load times usually ranged from 12 to 15 seconds per snapshot, but there was a notable spike exceeding 2,000 seconds during certain periods. This anomaly suggested a deeper issue, prompting a detailed investigation. By examining the correlation between locks and application issues, executions, disk reads, and buffer writes, a significant overlap was found between increased query durations and intensified locking issues. Accessing the lock history tab provided detailed data on each lock event, including the time, duration, and specific database elements affected.
16/05/2024
Why Oracle Changes the Execution Plan for a Query?
Understanding why Oracle changes the execution plan for a query can save you a lot of time and headaches. Statistics, data distribution (even without updated statistics), schema changes, and much more — There are numerous factors behind the changes of the execution plan. Having a grasp on all of them helps maintain efficient and stable query performance.
09/05/2024
BLOG – 10 Mistakes Committed by Inexperienced Programmers in Relation to Databases
From the basics of understanding SQL and its impact on databases, to the importance of maintaining clear Service Level Agreements and performance baselines, this article sheds light on critical areas often overlooked by newcomers.
15/03/2017
DBPLUS CeBIT 2017 in Hanover
We maintained a presence during the entire trade fair, as well as at the stand operated by the Polish Agency…
20/02/2025
Key Metrics for Reliable Database Replication
Database replication sounds simple enough: take data from one place and make sure it appears somewhere else, quickly and correctly. But anyone who’s spent time monitoring and troubleshooting replication knows it’s anything but straightforward. Networks fail, logs get backed up, and suddenly your secondary database is minutes (or hour) behind.
That’s why replication metrics matter.
13/02/2025
ORA-00904: Invalid Identifier in Oracle Databases
When you’re working with Oracle databases, some errors pop up so regularly that DBAs almost recite them in their sleep. ORA-00904: invalid identifier is certainly one of those classic offenders. On the face of it, ORA-00904 indicates you’ve referenced a column or other identifier that Oracle can’t locate or doesn’t consider valid. Straightforward enough—maybe there’s a simple typo, or a missing column in your table. But there are subtler corners of Oracle that can trigger the same error even when you think you’ve done everything right.
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.
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.
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…
15/04/2018
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…