Oracle database 18c has come up with some really useful features and the new features guide is the best place to get started-as always. In this post, which is the 1st post about 18c, I shall mention two very simple yet very helpful features introduced for SQL statements. So without further adiue, le

(Frits Hoogland) The redo series would not be complete without writing about changing the behaviour of commit. There are two ways to change commit behaviour:

(Marc Lameriks) At the Oracle Partner PaaS Summer Camps VII 2017 in Lisbon last year, at the end of august, I attended the API Platform Cloud Service & Integration Cloud Service bootcamp.

(David Fitzjarrell) Oracle has decided that Solaris needs to retire, giving those who are running Oracle on Solaris roughly two years to move to another operating system.

(Oren Nakdimon) Let’s assume the EMPLOYEES table (from the HR schema) contains many records, and we want to write an (efficient) SQL query that filters it by one or more of the following columns: DEPARTMENT_ID, JOB_ID, MANAGER_ID and LAST_NAME.

(mdinh) What! Another post on hugepages – seriously?

(Dan Jankowski) I recently encountered one long-running session and several blocked sessions, all performing the same delete operation.

(Barry McGillin) Run them with the code we use for Oracle SQL Developer, SQLcl and REST Data Services.

(Connor McDonald) Let’s face it. Concurrency is a good thing when it comes to database applications. After all, if there is only a single user of your application, then chances are, it is not a successful application.

(amitzil) One of my clients is restoring their database backup to another server for some testing. They do it periodically so we can also verify that the backup is good (which is great!).