Carl's Oracle

Carl's thougts about the Oracle Database Server

2005/11/17

OPP2005 - first PL/SQL conference a big success!

@ 10:35 PM (33 months, 15 days ago)
Hi,

PL/SQL becomes mature (specially in Oracle 10.2!)!
Read more about conference papers at this link : http://oracleplsqlprogramming.com/opp2005_agenda.php
Regards
Carl



2005/11/16

Cost based Oracle has reached Germany!

@ 11:02 AM (33 months, 17 days ago)
Hi,
today when I came home there was a package from amazon – it contained the book Cost Based Oracle Fundamentals which I ordered in advance. I just could not wait to open the book. In 15 Minutes I would have to leave with my wife to go shopping at IKEA. So I had only a few minutes for the first review.

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

2005/11/9

Patching Oracle 9.2.0.4 to 9.2.0.7 on SuSE 9.2 Professional raises - undefined reference to `dl_iterate_phdr@GLIBC_2.2.4'

@ 10:57 AM (33 months, 24 days ago)
Hi,
It was time to upgrade my Linux based Oracle database from 9.2.0.4 to 9.2.0.7. A thing which is easy going – I thought! Linux was SusE 9.2 Professional with 2.6.x kernel and gcc 3.3.4. After the oracle installer finished copying the files to Oracle Home the linking of the executable started. Soon an error raised which I could not solve:

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

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 (34 months, 2 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)