Category: Database

C callouts from MySQL

While I was trying to find a way to use the statistical functions built into MySQL for performance measurement, I discovered the ability to create user defined functions that use C callouts from within the database. I knew you could…

Who is generating all the redo?

Recently I was tasked with answering why we generated over 500GB of redo in a little over one day, when we normally generate an average of 100GB. We are in the midst of building out a remote data center which…

Getting connection strings from LDAP

After a recent migration, we found deficiencies with the process of how clients connect. As such, we are trying to standardize our repository of connection strings. We implemented an OpenLDAP server and added the schema information for Oracle objects from…