16/01/2025

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.

• Blog
• Oracle

09/01/2025

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.

• Blog
• Microsoft SQL
• Oracle
• Performance Monitor
• PostgreSQL

02/01/2025

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.

• Blog
• Oracle

19/12/2024

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?

• Blog
• Oracle
• Performance Monitor
• PostgreSQL

12/12/2024

Databases are the engines powering our digital age, storing, managing, and retrieving the vast amounts of data generated every second. For decades, they’ve relied on classical computing to do the heavy lifting, using algorithms and hardware that have become increasingly optimized but still face fundamental limits. As datasets grow larger and more complex, and as the demand for real-time insights and advanced security rises, it’s becoming clear that classical systems alone may not be enough to meet these challenges. What then? Two words: quantum computing.

• Blog