When you develop an application that uses a database, one of the topics you need to consider is how to connect to the database. Some application use a one-to-one connection,
Category: How Things Work
Shrink Table and Fragmentation in Oracle, Part 2Shrink Table and Fragmentation in Oracle, Part 2
This is the second part of the article, in the previous part I explained how extent management and shrink table works. In this post I’ll dive into a problem that
Shrink Table and Fragmentation in Oracle, Part 1Shrink Table and Fragmentation in Oracle, Part 1
This is an article that was published in the past, however, it’s not available anymore so I decided to post it here. Fragmentation is a common issue which we try
Oracle SEHA – Failover When VIP Goes DownOracle SEHA – Failover When VIP Goes Down
Lately I’ve been writing about Standard Edition High Availability (SEHA). After publishing my introduction post about SEHA, I got a comment from Purav with a case I didn’t cover in
Oracle Database Home Disk Space and PatchingOracle Database Home Disk Space and Patching
This occurred to me not too long ago, when I prepared an Oracle Software for a client. It is a small appliance with not a lot of disk space and
ORA-29283 with UTL_FILE in Oracle RACORA-29283 with UTL_FILE in Oracle RAC
UTL_FILE is used to work with local files on the database server side. In this post I’ll explain why you might get ORA-29283 in RAC (but not only) and how
Oracle Real Memory UsageOracle Real Memory Usage
I’ve been struggling with that for a while now, so in this post I’d like to explain what I’ve found so far and what I’m missing. If you can help
Archive Backups are not Deleted from Standby DatabaseArchive Backups are not Deleted from Standby Database
In an environment I’ve upgraded lately from 11.2 to 18c I found out that some backups are not getting deleted from the standby database. The environment has a single instance
Oracle Data Guard Explained – Step By StepOracle Data Guard Explained – Step By Step
Oracle Data Guard consists of many components. In this post I’ll explain about an environment that helped me understand how all the components work. This is a 12.1.0.2 (with APR
Did You Know #30 – Order in a PredicateDid You Know #30 – Order in a Predicate
I’ve known this for a while but never wrote about it. In KScope19 I attended a session by Alex Nuijten and during the session he asked a question about LIKE