In high-performance enterprise environments, the chain is only as strong as its weakest link. I recently faced a critical issue where a long-running task in my development machine running in JBoss Application Server was failing consistently. The investigation led me down a path from application timeouts deep into the core I/O mechanics of the Oracle… Read More »
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 »
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 »