Carl's Oracle

Carl's thougts about the Oracle Database Server

2005/11/1

Oracles Patchset 6 (9.2.0.7) Database Server arrived : time now for a Summary of all 9.2 Patchsets

@ 08:12 AM (49 months, 13 days ago)

Hello,

As i heard about the availability of the Patchset 6 (9.2.0.7) of the Oracle 9.2 Database Server i was very surprised. I thought Patchset 5/9.2.0.6 would be the last Patchset and ... that all errors would have been finally patched ;-).

For Analysis i scanned the bugs HTML document, pasted and prepared the bugs info with an editor and transformed it with awk. Now it had the right format for excel and then what else did you expect - I stored all the data in an 9.2 database (Patchset 3/9.2.0.4 ;-));

With the data in the database you could answer a lot of questions. I reduced that to two questions:

  • How many errors have been patched with each Patchset?
  • Which are the top 20 Components (of 139) have the largest amount of errors

The Total Number of fixed Bugs for the Oracle 9.2 Database Server

SQL> SELECT COUNT(*) FROM Buglist;
COUNT(*)
----------
10256

SQL>

10256 Bugs have been fixed with 6 Patchsets - about 1706 Bugs/PatchSet.


How many Bugs have been fixed with each Patchset?

I would expects that the number of bugs would decrease with every new Patchset.

 

SQL> SELECT COUNT(*), bl.FixedInRelease FROM Buglist bl group by bl.FixedInRelease;

COUNT(*)   FIXEDINRELEASE
---------- ----------------

1347       9.2.0.2
1053       9.2.0.3
1554       9.2.0.4
2547       9.2.0.5
2188       9.2.0.6
1567       9.2.0.7

6 rows selected

SQL>

http://img328.imageshack.us/img328/6498/bugstotalfixedinrelease7ts.jpg


The number of bugs was increasing and had its peak level at Patchset 9.2.0.5/9.2.0.6.

 46% of Bugs were fixed in 9.2.0.5/9.2.0.6 Patchsets!

An explanation could be: when a new version of Oracle is released a lot of customers do not switch to the new version very quickly. Some database releases are even not used at all. For example on the current customers site Oracle 10g will be allowed to be used at Main release 10.2 but not at Main release 10.1.

Read the rest of this entry ... (1257 words left)