Sometimes when you’re writing code you can encounter the situation only one session / thread may execute it (the code) at a time. This is commonly referred as a “Critial Section“. How do you solve such a problem within the Oracle Database?
Continue reading “Have only one session execute code (Critical section)”Category: Code tidbits
Debugging via Dbms_Pipe
When running code you sometimes have the need to debug the progress of the statements. One way is to use a table and write your debug output into it by means of an autonomous transaction. But sometimes it can be easier to just hand the debug info to a different session. Say hi to Dbms_Pipe…
Continue reading “Debugging via Dbms_Pipe”Controlling a POE switch from Home Assistant
In my quest to save on electricity I detected my TV set was using quite some energy while “Sleeping”. It turned out it wasn’t sleeping the whole time, waking every x minutes trying to get to the internet (it’s not allowed to) for a few minutes and then going back to sleep.
Continue reading “Controlling a POE switch from Home Assistant”