(Frits Hoogland) This blogpost is about oracle’s patching tool for the database and grid infrastructure: opatch. I personally have a love/hate relationship with opatch. In essence, opatch automates a lot of things that would be very error prone if it were to be done by hand, which is a good thing.

(Michael McLaughlin) A question that comes up now and again is there a way in Oracle Database 11g Express Edition to mimic some behavior in the Oracle Standard or Enterprise editions. Many of these questions arise because developers want to migrate a behavior they’ve implemented in Java to the Expre

(Zahid Anwar) When a database starts to churn more redo then normal, it is handy to be able to extract the amount of redo over time, to be able to plot this in a graph.

(stewashton) In this post, I’m going to treat two closely related but distinct requirements:

(Franck Pachot) There are not many ways to access efficiently to table rows. Either you want lot of them, because your predicate is not very selective, and you read the whole table in the fastest you can do. This is Table Full Scan.

(Joel R. Kallman) Preface: Many blog posts about Oracle APEX seem to cover a new feature or something rather obtuse & complex. The sophisticated blog posts have little relevance to someone who is completely new to APEX and Oracle Database. Having worked with APEX since 1999, it’s always difficult

(Michael McLaughlin) Oracle Database 9i introduced external tables. You can create external tables to load plain text files by using Oracle SQL*Loader. Alternatively, you can create external tables that load and unload files by using Oracle Data Pump. This article demonstrates both techniques.

(Hemant K Chitale) Here’s a compilation of some useful data dictionary queries on the implementation of Partitioning.

(Andrejus Baranovskis) Oracle Digital Assistant is a new name for Oracle Chatbot. Actually it is not only a new name – from now on chatbot functionality is extracted into separate cloud service – Oracle Digital Assistance (ODA) Cloud service.

(Jeremy) TLDR: Note to future self… (1) Read this before you modify a table on a live PostgreSQL database. If you do it wrong then your app might totally hang. There is a right way to do it which avoids that. (2) Especially remember the lock_timeout step.