(Bobby Durrett) Still tweaking my Python based Oracle database performance tuning graphs.

(Simon Greener) Implementation of Travelling Salesman problem using Oracle Spatial and Pl/Sql only.

(John Hallas) I was showing some basic sqlplus connection tips to a new DBA starter today and my normal warning about putting the password on the line when calling sqlplus didn’t produce what I expected.

(amitzil) There are few ways to see the execution plan of a SQL statement. One of these ways is the autotrace option in sqlplus. It is a very easy-to-use feature and people use it quite often. But there is a risk here. The autotrace option doesn’t always show you the correct execution plan.

(Martien van den Akker) Two weeks ago, I wrote about how to set the log level voor SB Pipelines (12c) to be able to see the logging of the Log activity in the WebLogic Server logs.

(Dominic Brooks) Use of ANSI SQL is a personal thing.

(David Fitzjarrell) Recently a tweet by Chris Saxon (@chrisrsaxon) with respect to SQL, the language and implementation, started a list of contributions which should cause people to think a bit differently about how the language works and how queries should be structured.

(Chris Buckel) Today’s storage array market contains a wild variation of products: block storage, file storage or object storage; direct attached, SANs or NAS systems; fibre-channel, iSCSI or Infiniband…

(Franck Pachot) People often ask me if I use the SQL Tuning Advisor. The answer is no, at least not through the end of it. But don’t take me wrong. SQL Tuning Advisor is a really nice feature.

(Martien van den Akker) If you’re a regular reader of this blog, you’ve noticed that I’ve been busy with creating soasuite/osb installations with weblogic domains in a scripted way.