(Richard Foote) In my last couple of posts, I’ve been discussing how storing date data in a character based column is a really really bad idea.

(Frits Hoogland) In a previous article called ‘memory allocation on startup’ I touched on the subject of NUMA; Non Uniform Memory Access. This article is about how to configure NUMA, how to look into NUMA usage and a real life case of NUMA optimisation using in-memory parallel execution.

(Jeff Smith) Oracle SQL*Plus has been around since 1985. It does what it does, and it does it well.

(Michael McLaughlin) Installing any Oracle database is tedious, but the installing the prerequisites can be especially tedious.

(Alex Nuijten) One of the new features with Oracle database 12c is the new syntax for Top N queries and pagination. Did we really need this? Should you choose for the new syntax over the way we used to do it, with an inline view?

(Job Oprel) Oracle Enterprise Manager 13C has been introduced as a ‘single pane of glass’. Managing and monitoring all the assets, in or out of the public cloud.

(Andrew Reid) You can get the date and time a role was created from the CTIME column in SYS.USER$. You can see what I mean in the example below, which I tested in an Oracle 11.2.0.4 database.

(Frits Hoogland) This is a small blogpost on using ‘perf’. I got an error message when I tried to run ‘perf top’ systemwide: # perf top Too many events are opened. Try

(Martin Berger) Today I had some fun identifying how a ORA-08176 can happen.

(Brendan Tierney) When building predictive models the data scientist can spend a large amount of time examining the models produced and how they work and perform on their hold out sample data sets. They do this to understand is the model gives a good general representation of the data and can identi