Tuesday, April 19, 2016

X6-2 1/8 new features: half disks and half flash removed

As we know in previous editions 1/8 Exadata = 1/4 Exadata by HW.
This means that storage servers had a 12 hard disks and 4 flash cards, but 6 hard disks and 2 flash cards were disabled. But they still were installed in the server.

In the X6-2 we have a new feature from Oracle:  "Eighth Rack HC storage servers have half the cores enabled and half the disks and flash cards removed."

This means that  X6-2 1/8 contain 6 hard disks and 2 flash cards.

The EF edition has the half flash cards disabled, but installed in the storage server.



http://www.oracle.com/technetwork/database/exadata/exadata-x6-2-ds-2968790.pdf

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...