(Hemant K Chitale) So far, all the examples of SQL Tracing that I have provided in this series are for SELECT statements. (By “DML” I mean INSERT / UPDATE / DELETE statements other than SELECT statements)

(Jay Stanley) One of the most common issues with Oracle databases that result in major business issues happen when database resources are overwhelmed with work. When this happens, some or all of the following can happen:

(Stefan Knecht) Time and time again I run into database accounts, which are marked “LOCKED” or “EXPIRED & LOCKED”. The main problem here lies with how Oracle handles a failed login attempt when the account is locked. In this blog I will discuss why locking Oracle accounts is a bad idea.

(Renan Medeiros) Use this script to generate a random password.

(Andrejus Baranovskis) I had a post about REST support by ADF BC in ADF 12.2.1 – ADF 12.2.1 ADF BC Support for REST. This was introduction, today I will go further and test CRUD (Create Read Update Delete) operations (using Postman REST client). Good news, CRUD are supported by ADF BC REST out of th

(Anju Garg) I received this error message when I was trying to perform a data pump export of SH schema in parallel in a RAC database. I proceeded as follows:

(Bane Radulovic) According to Wikipedia, data scrubbing is “an error correction technique that uses a background task to periodically inspect main memory or storage for errors, and then correct detected errors using redundant data in form of different checksums or copies of data.

(John Hallas) This blog has the aim of answering quetions about how a sql statement has performed and which plan it has used. I have asked the type of questions that we as DBAs normally have to answer and shown how an answer may be arrived at.

(Howie Jiang) There are many reasons for causing this error when you are trying to login to the database with your oracle internet directory (OID) authentication. The error sample is shown as below:

(Jeff Smith) This challenge has come up a few times recently for me. Just HOW can a SQL Developer user quickly build out a SQL script for a database user that will include ALL of their privileges, roles, and system grants?