(Patch72) Suppose you have data in your PL/SQL program stored in a collection. I am using the EMP table (14 records) but you should imagine you have many, many more records in your collection.

(Martin Bach) OSWatcher is a superb tool that gathers information about your system in the background and stores it in an (optionally compressed) archive directory. As an Oracle DBA I like the analogy with statspack: you make the tool available on the host in a location with – very important – enoug

(Jeffrey Kemp) If you have an ordinary checkbox item based on a list of values, here is a function which will set all the values to checked or unchecked:

(Dbaharrison) We had an unusual problem with datapump this week when exporting a large schema. A couple of small ‘static data’ tables were consistently throwing the error:

(mdinh) I have seen several blogs demonstrating using database exception table for error handling.

(savvinov) A few weeks ago, I received a request to review an AWR report for a database suffering from instance-level performance issues. Here are the the key parts of that report (with some masking):

(Guido Schmutz) The past 2 days I spent some time to upgrade the docker support I have created for Oracle Stream Explorer to work for Oracle Stream Analytics (which is the new Oracle Stream Explorer).

(Andrejus Baranovskis) There is a flaw in ADF BC remove operation. Row could be successfully removed in ADF BC – it dissapears from UI as well, but if there is DB integrity constraint violation – row is not removed in DB and error message is displayed to the user.

(mdinh) At first, I was wondering what’s the true benefit of the new feature (checkprm) since there exists CHECKPARAMS which does this.

(Jeff) I keep hearing this term lately and I dislike it.