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.
02/05/2024
How can you speed up database read queries
Before getting into the technicalities of speeding up your database read queries, the first step is always to have a clear understanding of what exactly you need. This might sound straightforward, but inefficient queries often begin with uncertainty about the data requirements. Knowing exactly what information is necessary for your application or analysis not only helps in crafting precise queries but also prevents the database from retrieving extraneous information, which can significantly slow down performance.
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,…
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…
09/09/2017
NEUCA is betting on DBPLUS Performance Monitor
The NEUCA Group, a leader in the wholesale pharmaceuticals sector in Poland, is another company which has chosen DBPLUS Performance…
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…
29/06/2017
DBPLUS Performance Monitor at Lagardere
Lagardere Travel Retail has been active on the retail sales market since 1998, managing a network of 630 press salons…
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…
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…