Thursday, December 8, 2016

12-ТБ и 14-ТБ hard disks

Western Digital introduced 12T and 14T hard disks.

https://www.wdc.com/about-wd/newsroom/press-room/2016-12-06-western-digital-introduces-advanced-devices-to-manage-evolving-data-center-application-demands.html

Новые технологии в производстве жестких дисков до 2020 года:
http://fcenter.ru/online/hardnews/#material_id=39308

Western Digital: Мы не разрабатываем новые 10K и 15K жёсткие диски:
https://3dnews.ru/945263?from=most-commented-index

Thursday, May 19, 2016

EXAFUSION_ENABLED = 1 (def=0 )

ExaFusion is Direct-to-Wire protocol which allows DATABASE processes send messages directly over the Infiniband network bypassing  the OS kernel. This means database processes make no syscal to OS. Database process directly write data to IB HCA bypassing normal networking software stack. This is the one of reasons why IB improves the response time in Oracle Exadata Database Machine. Data is transferred directly from user space of one process on one node to user space to other process on other node (no context switch to kernel space).

But, ExaFusion is disabled by default !
To enable ExaFusion look to the documentation:

http://docs.oracle.com/database/121/REFRN/GUID-A0612249-0A65-476D-A2B8-FA94DF5EEC7F.htm#REFRN-GUID-A0612249-0A65-476D-A2B8-FA94DF5EEC7F

You should to set EXAFUSION_ENABLED=1 in the database parameter file.

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