Andreas' Adventures

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.

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

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

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!

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