Category Archives: Databases

In an application using Spring Data I noticed frequent Warning lines and shaky behaviour, even locking with the following message. This is a Connection Eviction Warning. In simple terms, your application (using HikariCP) tried to use a database connection that it thought was valid, but when it reached out to the Oracle database, it found… Read More »

At times when closing Grafana with a kill command SqLite can get corrupted. This is the one liner that saves the day:

In an Oracle database I was trying to convert an existing view to a table and preserve the data in it. For most of my views the following SQL worked perfectly: Then in one on the instances the following error occurred: While inspecting the SQL code of the views I noticed that the view with… Read More »

In the following post I will describe my quick procedure I always use to debug the database queries generated by an application that hit an Oracle database. In a lot of cases your queries that hit the database are not written explicitly by a developer. That may be the case when intermediate layers as Hibernate… Read More »

Oracle 11g database with Data Guard active. A switch of the sites (from production to disaster recovery node) is done and all seems good. Suddenly one day after the switch (more than one month) the enterprise application using it cannot connect any-more (connection pool getting filled up). The underlying issue that causes this is reported… Read More »

I was trying to obtain the last executed query on an Oracle instance. Seems easy but I wanted also: to exclude the queries that are done by sys user as maintenance to focus on queries executed by a specific client type. The best way to do it is to use the V$SQLAREA system table. V$SQLAREA… Read More »