This is a decent way to determine why a cursor isn’t being shared, resulting in cache locking during parsing (134 minutes total yesterday, which is very high historically)… SQL> select count(*),sql_id from gv$active_session_history where event = ‘library cache lock’ group…
Month: January 2014
Using Apache POI to generate Excel spreadsheets from database queries
Back in the 90’s when I first started working with computers professionally, I remember finding software for $49.95, and often much more, to do on Microsoft Windows what is now free. Apache POI (“Poor Obfuscation Implementation” 🙂 ) is a…
Installing a specific kernel related package without upgrading the kernel
If you simply type “yum install package_name”, you will get the most recent version available in the package repository to which you are pointing. If this is a kernel related package, you can inadvertently upgrade the kernel, which may be…
HAProxy setup
I wanted to have a deeper understanding of load balancing. I tested with several different open source products, but the most recent release of HAProxy (1.5.21) was the easiest to get running. I wanted to test the following on RHEL…
Using strace to determine progress when processing a file
I thought this was interesting, as I stumbled upon it. I find the most useful things often result from stumbling 😉 I had a job running that was gunzip’ing a file and piping the output to a python script. The…