This post is dedicated to Pieter Van Puymbroeck. When using a physical standby database, you can use RMAN to backup the standby database instead of the primary. You can backup
Category: Did You Know
Did You Know #36 – List All Active RolesDid You Know #36 – List All Active Roles
When granting roles to users we need to remember two things: Any child role of the granted role is granted to the user as well (and this is hierarchical) You
Did You Know #35 – New Child Cursor Creation ReasonDid You Know #35 – New Child Cursor Creation Reason
In many cases we see a new child cursor for existing SQL. You can see the children and their information in V$SQL (where CHILD_NUMBER identifies the child). To see the
Did You Know #33 – Updating an Entire RowDid You Know #33 – Updating an Entire Row
The background story for that is long and complex, so I won’t get into it. I’ll just say that it was related to replication and I wrote a procedure to
Did You Know #32 – OEM Scripts LocationDid You Know #32 – OEM Scripts Location
Sometimes you get an alert from OEM but you can figure out why. It would help a lot if you could see the test and understand what exactly OEM is
Did You Know #31 – OCR and Voting Disks in 18c and 19cDid You Know #31 – OCR and Voting Disks in 18c and 19c
In Oracle GI 18c, the OCR and Voting disks must be located on ASM. A certified NFS or 3rd party shared file system is not supported for these files (you
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
Did You Know #29 – Who is Executing Jobs?Did You Know #29 – Who is Executing Jobs?
When you create a job using DBMS_SCHEDULER.CREATE_JOB you can specify a schema for the job (job_name => ‘my_schema.my_job’). What does it mean?
Did You Know #28 – Standby + RACDid You Know #28 – Standby + RAC
In an Oracle Data Guard configuration, the primary and standby databases can have different configurations. It’s very common to have a smaller server for the standby database (less CPUs, less
Did You Know #27 – SQL*Plus ErrorloggingDid You Know #27 – SQL*Plus Errorlogging
This is not my tip, but Connor Mcdonald‘s. I attended a couple of his sessions at Open World 18 and had to write about this small but really useful feature