Monday, February 7, 2022

Exadata Storage Server Software Support Ends

I've never seen such an information about Exadata Storage Software:

https://www.oracle.com/us/assets/lifetime-support-technology-069183.pdf

Thursday, February 3, 2022

19c RU BugFix statistics

 Decided to refresh previous version


Oct-20 Jan-21 Apr-21 Jul-21 Oct-21 Jan-22
  19.сен 19.окт 19.ноя 19.дек 19.13 19.14
Advance Queuing 4 6 11 9 10 12
ASM 10 31 22 27 29 16
Buffer Cache Management 9 14 20 16 14 5
Generic 77 160 215 120 117 65
High Availability 32 69 128 64 84 53
Diag 1 2 1 2 1 1
Global Data Services
1 1 10 0
Heterogenous Services 0 3 1 1 0 0
JVM 0 0 0 0 0 0
Multitenant 6 23 22 8 10 6
Net 0 0 4 1 0 0
OLAP 0 1 0 1 0 0
LOB 1 1 4 1 2 1
Security 7 11 15 3 8 10
Security Service 2 2 5 4 4 7
Sharding 0 1 2 3 10 5
TableSpace management 16 31 36 22 12 7
Storage Server Service 13 6 5 2 9 3
Streams 1 10 4 1 2 1
Transaction Mgmt 9 10 20 7 5 9
Universal Storage Mgmt 0 1 1 0 0 0
Utilities 1 10 10 4 12 4
Virtual OS 12 32 36 27 28 14
PL/SQL 4 4 14 5 7 3
Manageability 1 14 12 7 3 1
XML Utilities 1 1 6 6 7 1
XML database 3 19 25 17 24 13
Miscellaneous 29 47 114 59 86 65

239 509 734 418 494 302

 "Database 19 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2523220.1)".

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