Tuesday, April 26, 2022

19c RU Bugs Fixes

An year ago i've wrote the post "Time to upgrade to 19c"

Now it is the time to refresh the picture.

After the time new release have been issued, the question arises - is it time to move to the new release?
Is it good enough to work in production by now?
Usually users wait a while for a release to be "good enough" and for bugs to be fixed.

What is the criterion we may use to define whether a release is good and fine tuned enough?

As one of the criteria, we can take the number of bugs that are fixed in the each quarterly patch.
The logic here is: in the beginning, after a new release, a few people immediately start using it.
That's why the number of patches in the quarterly patch list is pretty small.
Gradually, the activity of users is growing, and then the number of identified problems/bugs is growing too. Therefore, the number of fixes in the patchset also increases.
After the time the software reaches a state where all the major bugs are fixed and the number of patches in the patchset decreases. Such an inflection point can be considered a stage of maturity of the software product.

The 19c Database Quarterly Bug Fixes:

                           Oct-20 Jan-21  Apr-21  Jul-21  Oct-21  Jan-22  Apr-22
                            19.9   19.10   19.11   19.12   19.13   19.14   19.15

Advance Queuing               4       6      11       9      10      12       6
ASM                          10      31      22      27      29      16      11
Buffer Cache Management       9      14      20      16      14       5       9
Generic                      77     160     215     120     117      66      73
High Availability            32      69     128      64      84      53      67
Diag                          1       2       1       2       1       1       2
Global Data Services                          1       1      10       0       2
Heterogenous Services         0       3       1       1       0       0       1
JVM                           0       0       0       0       0       0       0
Multitenant                   6      23      22       8      10       6       8
Net                           0       0       4       1       0       0       4
OLAP                          0       1       0       1       0       0       0
LOB                           1       1       4       1       2       1       0
Security                      7      11      15       3       8      10       3
Security Service              2       2       5       4       4       7       1
Sharding                      0       1       2       3      10       5       3
TableSpace management        16      31      36      22      12       7      10
Storage Server Service       13       6       5       2       9       3       4
Streams                       1      10       4       1       2       1       6
Transaction Mgmt              9      10      20       7       5       9       5
Universal Storage Mgmt        0       1       1       0       0       0       0
Utilities                     1      10      10       4      12       4       2
Virtual OS                   12      32      36      27      28      15      18
PL/SQL                        4       4      14       5       7       3       2
Manageability                 1      14      12       7       3       1       5
XML Utilities                 1       1       6       6       7       1       1
XML database                  3      19      25      17      24      13       4
Miscellaneous                29      47     114      59      86      65      33
                   SUM:     239     509     734     418     494     304     280

 

 

 

The 19c Grid Infrastructure Quarterly Bug Fixes:

                           Oct-20 Jan-21  Apr-21  Jul-21  Oct-21 Jan-22 Apr-22
                            19.9   19.10   19.11   19.12   19.13  19.14   19.15

Portable ClusterWare        124     195     139     132     65      61      82
Universal Storage Mgmt       26      30      48      41     41      43      26
Miscellaneous Issues          -       -       -       -     22      28      23
                     SUM:   150     225     187     173    128     132     131


:)



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

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