Author: Stefan Knecht

Stefan Knecht, Pythian Solutions Architect, discusses rdbms/audit on 12c.

Stefan Knecht discusses OEL and RHEL and the need to find clarity on reoccurring issues.

Stefan Knecht, Pythian Solutions Architect, encountered some issues while mapping ASM allocation units (AU) to database extents. It’s not easy to find a clear cut solution, but he’s done some digging to make your life easier.

Oracle DBA and Consultant Stefan Knecht discusses how Oracle handles a failed login attempt when an account is locked, and in turn, why locking these accounts is a bad idea.

  Oracle 12c introduced a new capability to move a partition online, without any interruptions to DML happening at the same time. But, there’s a catch. So far we’ve been able to use basic table compression without having to worry…

  Recently on a heavily used and freshly upgraded 12.1.0.2 ware-house type database, we started seeing lots of ORA-10173 dumped into the alert log. The information out there on this error is somewhat sparse, and it is often linked to…

If your system meets any of the following criteria: – Oracle 12.1.0.2.0 or higher – Partitioned tables – Parallel query heavily used – Bind variables in use, as they should be and, you’re seeing unusually high “cursor: pin S wait…

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and…

The Oracle In-Memory Column Store (IMC) is a new database option available to Oracle Database Enterprise Edition (EE) customers. It introduces a new memory area housed in your SGA, which makes use of the new compression functionality brought by the…

I was contacted by a colleague about a problem he was having. “I’m trying to set up something simple which I’ve done millions of times, but it’s not working. I might be missing something obvious.” The issue was that the…