(savvinov) On one of the databases I’m looking after (11.2.0.4, Solaris, non-RAC), several different INSERT statements (all into tablespaces with manually managed segments) suffer from occasional hiccups.

(Hemant K Chitale) Yesterday, I demonstrated a DataGuard Switchover from a 2node RAC(ASM) database to a SingleInstance(FileSystem) Database.

(Ben Brumm) Do you need to list all tables in Oracle? There isn’t an SQL list tables command, but you can learn how to do show all tables in this article.

(Frits Hoogland) This second blogpost on Performance Co Pilot or PCP in short is about visualisation. In case you haven’t read the first part, here it is, which describes how it works, why you should use it, and how you can install it. Pmchart. One way of visualising PCP is using the pmchart utility

(Zohar Elkayam) So I’ve been using Oracle 12cR2 for a couple of weeks now (getting ready to ilOUG meetup in a few weeks), and I decided to share my favorite non-important feature of the new version: the History command for SQLPlus.

(Randolf Geist) Recently I repeated the I/O related tests on a 12.2.0.1 instance for curiosity and was surprised by the fact that I consistently got significantly better results as on 11.2.0.4 and 12.1.0.2.

(David Fitzjarrell) In a recent post in the Oracle General database forum the following question was asked:

(Andrejus Baranovskis) ADF 12.2.1.x brings improved API support for Contextual Event implementation – this should simplify Contextual Event usage. Now Contextual Events can be produced without referencing ActionEvent or SelectionEvent, also there is no need to define Data Control to implement Contex

(amitzil) When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as it affects the order of rows if the column list changes.

(Hemant K Chitale) Continuing this series of posts where I have a SingleInstance/FileSystem Standby database for a RAC/ASM database …