Bash one liner: Fix Grafana SqLite
At times when closing Grafana with a kill command SqLite can get corrupted. This is the one liner that saves the day:
Category Archives: Databases
Clean #Oracle schema used space after an archival
When archiving a big database it is very important to free up space after that. After running the archival scripts that basically deleted old data from the production database, some extra steps were necessary to actually clean up the used space in the database. To first check how much space we still use after deleting… Read More »
Read text content of a blob in #Oracle SQL
Sometimes you need to inspect the content of a text blob in Oracle. Yes, if the content is not a text then this does not make sense, but often times we insert in a blob field a really long text like an XML content or JSON content of a document. What we need to do… Read More »
#Oracle # SQL Covert view to table issue: ORA-01723: zero-length columns are not allowed
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 »
Activate #infinispan second level cache with #jboss and #hibernate
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 »
#Oracle quick way to investigate slow or time consuming application queries
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 »
#SQL #Oracle : Move all indexes to a different tablespace
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 »
#Oracle ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn]
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 »
#Oracle: #SQL to get the latest executed queries in a schema
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 »
#Oracle: ORA-02298: cannot validate "key" – parent keys not found
When trying to add a foreign key to a table sometimes the error ORA-02298 is thrown. Let’s have two tables a MyTable and a MyTableHistory connected by a historyid column from MyTable that points to the id column from MyTableHistory Try then to add add foreign key like: If we are in the case of… Read More »