Tuesday, December 30, 2014

EXADATA HEALTH AND RESOURCE USAGE MONITORING

The nice article about Exadata health monitoring:

http://www.oracle.com/technetwork/database/availability/exadata-health-resource-usage-2021227.pdf

Wednesday, December 17, 2014

Exadata: Shared Server Connect Prevents Offloading To Storage Cells (Doc ID 1472538.1)

Interesting article:
no offloading (aka Smart Scan) is performed for sessions connected via Shared Server.
Because such sessions cannot use DirectRead which is required for offloading.
In is not a bug, it is a feature.





Wednesday, December 3, 2014

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