(Iggy Fernandez) The purpose of a SQLT report is to collect all the information that could possibly shed light on a problem with SQL query performance. I was recently asked to investigate why performance had suddenly changed for the worse on the 1st of the month. I was assured that “nothing had chan

(Andrejus Baranovskis) Groovy scripting is improved in ADF 12.2.1. There are no inline Groovy expressions anymore. Expressions are saved in separate Groovy language file, external codesource. Each EO/VO will be assigned with separate file to keep Groovy expressions.

(Andrejus Baranovskis) Groovy scripting is improved in ADF 12.2.1. There are no inline Groovy expressions anymore. Expressions are saved in separate Groovy language file, external codesource. Each EO/VO will be assigned with separate file to keep Groovy expressions.

(Richard Harrison) As many of us are now aware I’m sure the upgrade process is very different in 12c than in previous releases due mainly to the introduction of the catctl.pl script for running parallel upgrades of multiple pluggable db’s at once (no more just runing catupgrd.sql or catalog.sql indi

(Uwe Hesse) This is how an upgrade with pluggable databases looks conceptually:

(Aman Sharma) A recent thread in the Database General Questions place was posted today. The original poster set some wrong values for the database memory related parameters and using those exceptionally large values, database got hung.

(Frits Hoogland) This post is about manually calling and freeing a shared latch. Credits should go to Andrey Nikolaev, who has this covered in his presentation which was presented at UKOUG Tech 15. I am very sorry to see I did miss it.

(Iggy Fernandez) P.O.I.S.E.D. is the acronym I invented for the performance tuning method described by Chris Lawson in The Art and Science of Oracle Performance Tuning; it stands for Problem, Observation, Interpretation, Solution, Execution, and Documentation.

(Andrejus Baranovskis) I’m going to share few more tips, how to implement CRUD in JET and call ADF BC 12.2.1 REST service. You are going to learn how to implement table row selection and how to call REST PATCH method to update data through ADF BC REST service.

(John Hallas) I like the memory advisors that are available from the OEM GUI or the direct database tables themselves. If I want a quick overview of whether a memory area (shared_pool, cache or the overall memory target itself) needs reviewing look there first.