Increase (database) performance when dealing with Hummingbird

As Hummingbird creates its queries on the fly you might end up with queries that perform well when the database is using an OPTIMIZER_MODE=RULE, as well as queries that perform well when the database OPTIMIZER_MODE is set to COST.

It seems that with good statistics and an OPTIMIZER_MODE=FIRST_ROWS best of both worlds can be achieved.

Small bit of info concerning directory syncronization

Most directories store their network login in an attribute named "uid" while Microsoft stores theres in "samaccountname".

ldapadd return codes

These might come in handy when writing scripts for large ldif files (or split up ldif collections):

0: entry added without error
32: parent does not exist
53: duplicate value
68: entry already exists

An awesome cool performance tool

I just found a tool called Insider on http://www.fourthelephant.com/
Just have a look at the screenshots on their site or download it. Gives a very cool overview of the status of your database. You can't compare it with GridControl but the graphical capabilities rock!

OC4J reports may hang

An OC4J with its own Reports Server might hang (seen under Linux when starting Reports from Forms).

In the trace file you might see
Formatting page 1

and it will never return from there.

Remedy is to set
pdfcomp=no