Thursday, August 31, 2017

A workaround for ORA-12008 and ORA-14400 during online redefinition

›
To introduce partitions in one of my tables, I was using online redefinition of a rather large table. The following error was thrown after ...

How to explain a SQL statement using bind variables

›
Sometimes I am asked to analyze an SQL statement picked up from Enterprise Manager Cloud Control. These SQL statements only reveal the bind...
Wednesday, August 30, 2017

How to move a partition online from Oracle 12.1 and onwards

›
From Oracle version 12.1 and ownwards, moving partitions and subpartitions becomes non-blocking DDL operations. DML against the table can c...

What exactly is a LOB index object?

›
This question was answered by Tom Kyte in an old post from 2001. A LOB is simply a pointer. It points to an index. The index points to t...
Tuesday, August 22, 2017

How to split a default subpartition in a table using a subpartition template

›
Here is an example on how to split a subpartition utilizing a "subpartition template". Before the change, the table looked as fo...
Monday, August 21, 2017

Some important tuning parameters in Oracle 12c

›
Here are some parameters that you will have to deal with when tuning an Oracle 12c database. Execute the following SQL to view their curr...
Thursday, August 17, 2017

What does 1048575 in the Pstop column in the explain plan indicate?

›
The answer lies in the dictionary view ALL_PART_TABLES (or DBA_PART_TABLES). The column partition_count is the total number of partitions...