Tag: stefan knecht

Advanced compression option caveat in Oracle 12c

  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…

Read More >

ORA-10173: Dynamic sampling time-out error

  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…

Read More >

High “cursor: pin S wait on X” waits?

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…

Read More >