Icinga chose ocilib as Oracle db layer

posted this in Development, IDOUtils on February 19th, 2010 | Leave a comment

Just to let you know:

Based on my finished Oracle implementation and the last blog post, I’ve dropped Vincent Rogier, developer of ocilib a few lines about my work experience with ocilib.

http://orclib.sourceforge.net/2010/02/icinga-chose-ocilib-as-oracle-db-layer/

This small diary entry describes the way how Icinga and ocilib happened :-)

Share

Icinga IDOUtils – More improvements Part I

posted this in Core, Development, IDOUtils, Misc, Technical on February 15th, 2010 | 1 comment

It’s been a while since I made several changes to the initial Oracle implementation in Icinga IDOUtils. Code has been split, first start of using prepared statements and binded params with ocilib and some other changes to the code.

In the last few weeks I have been investigating a lot on how to implement more [...]

Share

Playing with Oracle, ocilib and parameter bindings

posted this in Core on November 9th, 2009 | Leave a comment

Hi there,

IDOUtils queries differ quite a lot – some of the are just executed during startup, while others happen all the time. By analyzing the performance on our Oracle database with grid  it came to the top queries just like for

servicechecks, servicestatus hostchecks, hoststatus timedevents programstatus

But how to improve the performance of [...]

Share

Icinga IDOUtils will support Oracle RDBM in 1.0 RC

posted this in Core, Releases on October 20th, 2009 | Leave a comment

Hi there,

work was not getting better and getting Oracle to work was on hold. So I decided to push a night of coding after I had prepared the MERGE queries.

And yes, it was successful – initial support for Oracle is done!

Oracle driver requirements

You”ll catch the problems with libdbi and Oracle in [...]

Share