A recent question on CDOS was regarding how to have only one space at the end of a CSV output row. Below was my response… <span style="font-size: 100%;">SQL> create table t1110(c varchar2(10)) 2 / </span> <span style="font-size: 100%;">Table created. </span>…
Author: Steve
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…
Multicollinearity
The predictors should not correlate. In the stepwise selection one variable might take the prediction of the another variable into the model and the second variable will not be taken in to the model. The variables might get also inconsistent…
Does correlation help at all?
While studying how we can use statistics to better understand the performance of our applications, I came upon the concept of kurtosis. What this essentially means is that any given distribution is not normal if its kurtosis is very high…OK,…
RAC connection load balancing finally explained!
I have admittedly struggled to completely understand how RAC load balances connections. As I think I finally understand it, I thought I would post my findings. Normally, when you find a resource that describes server side load balancing, it simply…
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…
Parsing a 10046 trace with python
This needs work (I am just learning python), but try the following… 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28…