Oracle Locks, Blocking Locks and Deadlocks
What do the concepts of Oracle Locks mean? When should we use each one? And the most crucial question: how to avoid each scenario?
DataGuard Broker in Oracle Step-By-Step
DataGuard Broker to configure the database broker to make automatic changes of roles in case of having a switchover or a failover.
Configuring a Physical Standby with Oracle Dataguard
A standby database is a DRP (Disaster Recovery Plan) solution, and it is nothing but a copy of the primary database, which can be automatically synchronized with Dataguard. Either using Dataguard or shell scripts for automatic or manual synchronization, the primary database must operate in archive mode.
How to tell if your proposed index is going to be effective in your production environment
Once and again, developers ask me the same question: “I want to build the following index, do you think it is right?”
I will assume that the developer analyzed the functional use of the index correctly, so I can explain you how to test the impact of the index in your production environment.
How to quickly tell if your Oracle Database is running slow or not
If you are an experienced production database administrator, I am pretty sure that from time to time you have to hear “The problem is the database, it is running slow”.
If you are a junior DBA, trust me when I tell you that you will hear that, more times and more frequently than you would wish to on your daily job.
Identifying which SQL Statement is Better in Oracle
In general, we write down SQL sentences and we execute them whithout analyzing any metrics. Metrics are important. A small improvement is multiplied by the times the statement is executed
Estimating a schema/table size in Oracle
Sometimes, immediately after designing a database schema we have to define the amount of disk space required to run the application. At first glance this can be quite difficult but with these 6 steps, 99% of our problem is going to be solved.
Performance – Oracle Pool with PHP
I am new in the PHP world (I come from J2EE), so imagine my surprise when I found out that most PHP productive applications do not use connection pooling. Fortunately, I came across a new feature in Oracle 11g…
The Use of Oracle Feature SELECT FOR UPDATE to Prevent Race Conditions on our Exposed Services
Several times we may need to make a lock/release at a database row level. Let me expose a simple situation so you can then relate it to your particular problem in our web service or software in general.