Saturday, February 21, 2015

Oracle Partitioning Policy (including Engeneered systems)

The X5 Exadata allow implemented the virtualization technologies (Oracle VM) to separate the partitions.Partitioning occurs when the CPUs on a server are separated into individual sections where each section acts as a separate system.The purpose of this policy document is to define which of these partitioning technologies are eligible and under what conditions Oracle permits them:







 

And:   Solaris is not supported on Exadata X5 anymore !

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...