Latest
Events
Products
Partners
Release info
ORA-00904: Invalid Identifier in Oracle Databases

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.

How Did Microsoft Compete with Oracle Database Over the Years

06/02/2025

From .NET to Azure: How Did Microsoft Compete with Oracle Database Over the Years?

For a long time, talk of database supremacy circled around Oracle’s hold on mission-critical workloads. Then Microsoft stepped up with SQL Server, coaxing DBAs away from Unix systems by leaning heavily on a Windows ecosystem that many found simpler to manage. Fast-forward to the present, and the contest has expanded into cloud territory, culminating in an unexpected partnership that underscores just how practical both tech giants have become. How did Microsoft compete with Oracle Database throughout this journey? 

Achieve Database Optimization Without Abandoning Normalization

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. 

Database Performance Tuning - the Sensible Way: Collaborative Strategies, Clear Metrics, and Tested Changes

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.

ORA-01555: How to Preserve Undo Data and Keep Queries Consistent

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.

16/02/2018

DBPLUS at the DOAG/Oracle Data Analytics Conference 2018 in Brühl, Germany

Data Analytics 2018, which was previously known as the “Oracle Data Warehouse Conference,” took place this year on March 19…

18/01/2018

DBPLUS is the Silver Sponsor of SQLBits

SQLBits is the largest SQL Server conference in Europe for data professionals. It provides the education, skills, and solutions from…

03/01/2018

DBPLUS at SQLSaturday #679 in Vienna

SQLSaturday is an all-day conference and training event which is taking place in 2018 for the fifth time in Austria….

10/10/2017

webtelligence to show DBPLUS portfolio at SQLdays conference October 10-11, 2017

ppedv AG invites to SQLdays 2017 in Erding, just to the east of Munich Airport. Numerous experienced speakers will present…

11/05/2017

DBPLUS partner – webtelligence IT consulting GmbH as a speaker and exhibitor at the mbuf

It is one of the highlights within the German IT industry: the regularly held mbuf annual conference . Both members,…

DBPLUS PERFORMANCE MONITOR Release 2024.3

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.

Types of Indexes and When to Use Them

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.

Performance Monitor Changes in Version 2024.2—Part III: OS Stat Page

19/09/2024

Performance Monitor Changes in Version 2024.2—Part III: OS Stat Page

In the high-tech tangle of our time, more cores usually mean a slower tick-tock in the CPU clock. The sage database administrators find themselves revisiting the old battleground of processor usage. The latest update to DBPLUS Performance Monitor (Version 2024.2) includes significant enhancements that aid in this monitoring. Particularly through its dedicated page for OS statistics—OS Stat Page.

Performance Monitor Changes in Version 2024.2—Part I: Online Monitor

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.

The Toughest Performance Challenges of SQL Server

08/08/2024

The Toughest Performance Challenges of SQL Server

SQL Server has a stellar reputation among the suits in the boardroom—lauded for its architecture and the ability to juggle massive datasets with the grace of someone who can juggle quite well. Yet, those who actually wrestle with the data, know a different story. They understand that SQL Server, like any towering giant, has its own set of quirks and foibles that can keep database professionals on their toes. Welcome to the performance challenges of SQL Server.

10/10/2017

webtelligence to show DBPLUS portfolio at SQLdays conference October 10-11, 2017

ppedv AG invites to SQLdays 2017 in Erding, just to the east of Munich Airport. Numerous experienced speakers will present…

27/07/2017

DBPLUS Performance Monitor in German multi channel companies

Renowned German multichannel providers place their trust in DBPLUS Performance Monitor Multichannel sales are an integral part of almost every…

11/05/2017

DBPLUS partner – webtelligence IT consulting GmbH as a speaker and exhibitor at the mbuf

It is one of the highlights within the German IT industry: the regularly held mbuf annual conference . Both members,…

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…

DBPLUS PERFORMANCE MONITOR Release 2024.3

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.

Performance Monitor Changes in Version 2024.2—Part I: Online Monitor

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…