Monitor and control #ActiveMq using Jolokia #API

By | October 26, 2023

Apache ActiveMQ® is the most popular open source, multi-protocol, Java-based message broker. It is widely used in a lot of multi service application environments where we need to pass messages between services. All this type of environments (kubernets, docker swarm etc. ) are used to be able to monitor and control the component services using… Read More: Monitor and control #ActiveMq using Jolokia #API »

#Oracle # SQL Covert view to table issue: ORA-01723: zero-length columns are not allowed

By | July 31, 2023

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: #Oracle # SQL Covert view to table issue: ORA-01723: zero-length… »

#Jboss: Data source connection optimizations

By | June 21, 2023

In a high load system deployed on Jboss Application Server the following optimizations for data source pool resources may be needed. 1. Change the minimum and maximum pool size of a data source (MyDS). This will ensure that we always have a minimum number of allocated connections and also we set a threshold to the… Read More: #Jboss: Data source connection optimizations »

Activate #infinispan second level cache with #jboss and #hibernate

By | November 23, 2022

Second level cache is an extremely powerful way to improve performance of an enterprise application if done right. In the following I will explain how to activate and configure second level cache when using Hibernate and Jboss 7.4+ application server. Jboss 7.4 comes with Infinispan as the build in second level cache solution. This makes… Read More: Activate #infinispan second level cache with #jboss and #hibernate »

#Oracle quick way to investigate slow or time consuming application queries

By | November 21, 2022

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 quick way to investigate slow or time consuming application… »

#SQL #Oracle : Move all indexes to a different tablespace

By | October 18, 2022

In general is good to have a separate tablespace for your index tables. Sometimes the default tablespace, in our case DATA, is used by an application using hibernate layer to automatically create all the tables and indexes. Then the issue is how to move the automatically created indexes to the special created tablespace for indexes,… Read More: #SQL #Oracle : Move all indexes to a different tablespace »