Latest
Events
Products
Partners
Release info
PostgreSQL vs Oracle

13/06/2024

PostgreSQL vs Oracle: Choose the Right Database for Your Needs

PostgreSQL vs Oracle — an open-source framework that champions adaptability and accessibility versus a proprietary system designed for high throughput and scalability in enterprise environments.  These two database systems, while both engineered to manage vast amounts of data, diverge significantly in their approach, philosophy, and intended user base.

PostgreSQL is a community-driven, flexible model that supports customization and supports innovation, making it ideal for entities that value agile and cost-effective solutions. Oracle, in contrast, targets large-scale operations with its performance-oriented architecture that ensures reliability and robustness under heavy loads.

The Most Important Database Performance Metrics

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.

Problems with Oracle Database

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. 

Locks by Application Issues

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.

Why Oracle changes the execution plan for a query

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.

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…

27/08/2019

DBPLUS will perform at a meeting organized by the Warsaw PostgreSQL Users Group

On October 10, 2019 in Warsaw at 5 Kolejowa Street, DBPLUS together with Goldenore and EnterpriseDB will talk about PostgreSQL…

The Easy Way and the Hard Way to Optimize an Oracle Database

11/04/2024

The Easy Way and the Hard Way to Optimize an Oracle Database

It may seem that the companies entangled in the web of Oracle and its ecosystem have a limited set of options when it comes to performance tuning. It’s either – pay for extra functionalities and navigate Oracle’s complex licensing, risking non-compliance penalties. This often leads to a conservative approach to optimization, stifling innovation due to the fear of overstepping licensing terms.

But do we always have to go the hard way? 

There’s a much simpler route that doesn’t involve trembling with fear of clicking the wrong thing. That’s what we will be talking about today. 

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…

14/03/2024

The Nightmare of Database Deadlocks

A database deadlock occurs when two or more transactions in a database system hold locks on resources the others need. Each transaction waits for the others to release their locks, and just like two drivers who are not sure who has the right of way, none can proceed.

It would be lovely to be able to enumerate the causes of a database deadlock and address all of them. Sadly, it’s way too complex. It can be said, though, that a database deadlock is most likely to stem from poor application design, lack of proper transaction management, or the inevitable complexity of highly concurrent systems.

Wichtige Faktoren in DevOps-Operationen

29/02/2024

Shifting Gears to Real-Time: How One Company Overcame Its Data Dilemma

Today’s story is about a leader in the automotive spare parts market, spanning 17 European countries, grappling with a significant challenge. They faced the daunting task of managing delayed reporting, ensuring consistency across diverse markets, and customizing reports with limited flexibility. This scenario led to delayed data updates. This, in turn, caused frustration and inefficiency.

Wichtige Faktoren in DevOps-Operationen

14/02/2024

Key Factors in DevOps Operations

Ensuring access to, optimizing and securing key data is essential to the smooth flow of information, crucial on the path to operational success. DevOps professionals face the challenge of sifting through data in search of relevant insights. In the face of widespread data breaches, maintaining database security while ensuring easy access becomes a priority. DBPLUS PERFORMANCE MONITOR offers a solution, enabling effective data management, analysis and security.

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…

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…

07/04/2023

New version Performance Monitor (Release 2023.1)

On April 7, 2023, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…

performance monitor

10/10/2022

New version Performance Monitor (Release 2022.3)

On October 10, 2022, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…