While working in one of Data Guard projects, I was asked about the current sync status of standby. I started talking about gap, SCN, or applied and received archive log numbers, and so on, which obviously did not make sense to business users. The only thing they’d like to know is whether or not data …
This is an interesting post by Tanel Poder on “Your read only accounts aren’t that read only”. Basically a read-only account with the select privilege only on a table can issue the lock on that table even though it does not have any DML privileges. This means that it could prevent any further DMLs (causing …
Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is a part of the standard database components. So after the 11g installation, I just follow simple steps (shown later below) for the post-installation. In order to access the APEX application, either the embedded PL/SQL gateway or Oracle HTTP …
Last week I had a chance to work on RMAN to duplicate the existing 3-node RAC database to another 2-node RAC database. In my case, the 2-node target already has running instances, the task here is to wipe out and copy data from production. Here is my note. I tried to put some comments to …
Well, I believe most of DBAs including myself do not want to create Oracle sample schemas when creating a database. Why bother because we thought we would never use those sample schemas anyway. However, recently I’m running into an issue when trying to use tutorials on Oracle Data Mining (ODM). It requires the Sale History …
