Build 64bit OCILIB Libraries for CodeBlocks

I tend to compile with gcc, in a bash session, on Windows 7. I use Code::Blocks as my IDE of choice and one of my projects, well, quite a few, use the excellent OCILIB library for accessing Oracle databases, by Vincent Rogier. I can’t recommend this library highly enough.

However, it comes with a Code::Blocks project file to build 32 bit libraries, but I need 64 bits. Here’s how I do it.

Continue reading Build 64bit OCILIB Libraries for CodeBlocks

Generate Entity Relationship Diagrams from a SQL Script.

Sometimes, just occasionally, you find yourself as a DBA on a site where, for some strange and unknown reason, you don’t have an Entity Relationship Diagram (ERD) for the database that you are working on. You could use a tool such as Toad, or SQL*Plus (or even, SQL Developer – if you must) to generate a list of referential integrity constraints. There has to be a better way. Continue reading Generate Entity Relationship Diagrams from a SQL Script.

Snorkelling in the Oracle Listener Logs.

(Snorkelling is not quite as in depth as a “deep dive”!)

Attempting to parse a listener.log will probably bend your brain, but I needed to do it recently to determine which unique servers and/or desktops and/or application servers were still connecting to a database prior to that database going down for maintenance. This was an exercise in confirming that the documentation we have, is correct.

Continue reading Snorkelling in the Oracle Listener Logs.


   Send article as PDF   

Window Maintenance Tips

Regular maintenance is important for your home’s windows. It can help them last longer, perform better and look great. Well-maintained windows will also serve to enhance the security and appearance of your home, guarding against the effects of temperature fluctuations, weather and debris. Follow these maintenance tips from Rescom’s expert window technicians to help keep your windows in shape. Visit for more information about professional maintenance.


Wipe down windows regularly with a damp cloth to remove dust and dirt. Don’t use too much water, especially on wood frame windows, as moisture can lead to rot. For vinyl windows, used a combination of warm water, a mild detergent and a soft scrubbing brush.

Use a glass cleaner in between deep cleans to keep the windows sparkling. Don’t neglect the window casing and adjacent wall area, in an effort to remove that build-up of dirt and debris in hard-to-reach components. Window jams can occur when dirt is allowed to accumulate in those areas.

Regular Inspections

In spring and fall, perform a thorough inspection of your windows, being sure to check the condition of the window frame and sash. Keep an eye out for signs of rot, especially on wood frames, that can indicate moisture infiltration.

Be on the lookout for moisture in double- or triple-paned windows, which could mean the seal has failed and must be replaced. Allowing a failed seal to remain will reduce the insulation capacity of your windows.

Have the sun’s harsh UV rays caused areas of the frame to become brittle and warp? Is paint peeling in certain areas? Is the weather stripping still intact? Replace, repair and repaint as needed. Caulk any gaps between the wall and window casing.


Gaps around your window allow for energy leakage, increasing your bills and reducing the efficiency of your home. For optimal sealing, replace all worn rubber seals to keep air and water leaks at bay and further secure the window in place. You can also use spray insulation or caulking to do the job.

Damaged Parts

Repair any cracks, holes, and splinters in the window to avoid further deterioration. If you notice cracked or broken glass, get it repaired or replaced immediately to prevent energy leakage and accidental cuts. This task is best left up to professionals.

Check the Fit

Frames and sashes can change subtly in size over time, thanks to usage and exposure to temperature cycles. As a result, gaps can form between window components, allowing air and water infiltration. Carefully check the fit of all window components. Make sure they can open all the way and that they close and lock completely. Swelling or warping of the window frame or sash means moisture is present.

Which Extra Cost Oracle Options is my Windows Server Running?

It’s always nice to know which extra cost Oracle options are enabled, whether deliberately or silently as the result of some patching that has taken place.
Keep yourself and your server room cool with blaux wearable ac.

Continue reading Which Extra Cost Oracle Options is my Windows Server Running?

Dropping Temporary Tables (With Bonus, Broken Check Constraints!)

I found a broken check constraint, one that simply wouldn’t work, on a database. It was created as:


Try it yourself, it doesn’t work! Anyway, I needed to find if there were any other check constraints broken in this manner, so I did the following:

Continue reading Dropping Temporary Tables (With Bonus, Broken Check Constraints!)