(Bobby Curtis) In a previous post, I showed you how to build an Integrated Extract (IE) and Distribution Path by using JSON and cURL. In this post, let’s look at how you can build an Integrated Replicat (IR) in the same manner.

(Anuradha Mudgal) Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile.

(stewashton) Marc Bleron blogged about CSV CLOBs and JSON_TABLE two years ago. Here’s my contribution to improve on a great idea.

(Frits Hoogland) Starting from Oracle 12, in a default configured database, there are more log writer processes than the well known ‘LGWR’ process itself, which are the ‘LGnn’ processes:

(Richard Foote) One of the problems with populating the value of a Primary Key (or some such), is that they can cause contention, especially in relation to indexes.

(Jagruti Jasleniya) In a DBA’s routine, we perform thousands of command every day. Sometimes it also happens we don’t know the post-impact of the command.

(Martin Berger) I am struggling with DBCA right now so a little tracing is advised.

(Oren Nakdimon) This is part 6 of a post series about EBR.

(Jagruti Jasleniya) In previous articles, we have seen various methods of converting Non-RAC database to RAC database.

(David Fitzjarrell) Patching is a necessity, and CPU updates can include patches some installations may not need.