(David Fitzjarrell) The mutating table error (ORA-04091) thrown by Oracle can be a familiar sight throughout a DBA’s career, along with the usual question of ‘Why?’. The error itself is not difficult to understand nor is it hazardous to the table data. Let’s look at why the error is thrown, why it’s

(Ben) In this article, I explain what Oracle SQL analytic functions are, how they are different from other functions, and show you some examples.

(Randolf Geist) As Oracle ACE Director I got an extended trial license for Oracle’s Cloud offerings, in particular the “Database as a Service” offering. As part of the (ongoing) evaluation I try to get an idea how consistent the performance of such an service is, which might be one of the concerns o

(mdinh) Here is a list of download options for APR2016 (11.2.0.4.160419) PSU:

(ilmarkerm) I hit this issue by accident, developers wanted to disable inserts to child table so they could perform some one-time maintenance operation, and this maintenance only affected one rown from the parent table (and all it’s children).

(Oren Nakdimon) Sometimes when you present an advanced feature, questions from the audience reveal misconceptions about basic features.

(raysmithace) You can specify a connection string for database targets in two ways: fill in the blanks and let OEM create the connection string (my preference) or paste a Preferred Connect String on the bottom of the page.

(Yasin.Baskan) In my post about common distribution methods in Parallel Execution I talked about a few problematic execution plans that can be generated when the optimizer statistics are stale or non-existent.

(Kevin Closson) I occasionally get questions from customers and colleagues about performance expectations for the Oracle Database procedure called calibrate_io on XtremIO storage.

(Ben) The NEXT_DAY function is a handy date manipulation function provided by Oracle. In this article, I’ll explain how to use it and show you some examples.