(Martin Berger) Many bloggers have already discussed that Oracle can truncate the text of a “create table as select” statement to 20 characters depending on your version and patch level. This can be a problem in case a CTAS statement is a resource hog, yet you don’t see the SQL text that is needed f

(Brent Genereux) The past decade has seen a steady rise in the use of mobile applications across nearly all industries. At Fishbowl Solutions, we have played a part in this trend by developing a series of Android and iOS apps that allow users to easily access their Oracle WebCenter content from thei

(Dirk Nachbar) As I am not a fan of clicking through several Configuration Wizards, I am trying to script as much as possible. Here is a fully unattended way of how to install and configure Oracle Traffic Director 12.2.1.3.0.

(Martin Berger) I have to invest much of my time (at work) into Oracle and managing of patches, merge patches, patch requests and similar things.

(Bobby Durrett) In my introduction to my Python for the Oracle DBA topic I said that Python can connect to everything that an Oracle DBA needs. I want to use this post to expand on that and talk about the Python modules and packages that I have used.

(Martin) Quite frequently in database environments, security policies dictate that only personalized logons to Unix / Linux are allowed and that from there, one has to “sudo” to change to the oracle account. While this adds an additional layer of security, it makes administration a little more compl

(Stefan) The Setup of an Data Guard environment with Physical Standby via Data Guard Broker was done including an Switchover. Everything fine and works as expected. (Oracle Release is 12.1.0.2 and PSU Jan 2017).

(stewashton) Continuing my series on using ORA_ROWSCN to achieve optimistic locking, let’s zoom in on ORA_ROWSCN itself. I’ve been asking myself this question:

(Martin Berger) This blog post continues with all the objects and settings from SecureFile LOB – the empty table, SecureFile LOB – the 1st insert SecureFile LOB – the 1st update and SecureFile LOB – more inserts.

(Skant Gupta) KST tracing is an in-memory tracing feature for Oracle RDBMS Database Server, this is similar to on-disk (KSD) tracing except it is stored in SGA.