Wednesday, September 24, 2014

Hard Drive Reliability Statistics


https://www.backblaze.com/blog/hard-drive-reliability-update-september-2014/

In Russian:

http://www.opennet.ru/opennews/art.shtml?num=40656

Tuesday, September 16, 2014

Is it good idea to connect production and standby Exadatas by Infiniband ?

Some time ago I used to think that the two Exadatas (production and standby) is better to bind by IB.
But from now i think otherwise:



"Primary and standby databases should NOT reside on the same IB Fabric"




Oracle Sun Database Machine Setup/Configuration Best Practices (Doc ID 1274318.1)

Friday, September 12, 2014

Ты готов к переводу стрелок часов ?



26 октября переведутся стрелки часов и надо подготовиться к этому моменту.

Патч на СУБД можно найти в нотах
The Russian Government re-introduces DST in 2014 - Impact on Oracle RDBMS (Doc ID 1907147.1)
Applying the DSTv23 update for the Oracle Database (Doc ID 1907093.1)
Его надо поставить заранее. На все Oracle Home какие только есть. :)

 В Экзадатовских патчах этого патча не будет:
Exadata and DST (timezones) (Doc ID 1343576.1):
"Exadata updates do not contain the updated timezone (tzdata) files."

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