Björn Bolltoft’s Blog: Oracle Database Managebility

I know, there are so many blogs out there. Some are good and helpful, others are driven by marketing messages only. But I believe this one will become a really good one in the Oracle universe: Björn Bolltoft’s Blog: Oracle Database Manageability. Björn Bolltoft’s Blog: Oracle Database Managebility First of all, let me say some words about Björn. I know Björn now for over 10 years. But he works even longer than I for Oracle. Björn joined Oracle Sweden in 1995. I bumped into Björn at our second Tech Challenge training. This is a hard-core training for geeks, diggers and…

Remove components from Oracle’s kernel with chopt

I’ve had an interesting discussion today. Somebody removed OLAP with chopt – and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you’ll have to make sure to remove the dictionary components as well. A while back a blogged about chopt already: Removing Options from the Oracle Database kernel in 12c And there are some helpful Support Notes out there: MOS Note: 948061.1 How to Check and Enable/Disable Oracle Binary Options This note WILL NOT address product specific scripts that…

Different Metrics for SPA (SQL Performance Analyzer)

I’m more the command line type of person. Once I’ve understand what’s going on behind the curtains I certainly switch to the GUI-click-click tools. But in the case of Real Application Testing – even though the support via the OEM GUI is excellent – sometimes I prefer to run my procedures from the command line and check my reports in the browser. Recently Thomas, a colleague from Oracle ACS Support, and I were asking ourselves about the different comparison metrics for the SQL Performance Analyzer reporting We did scan the documentation but we found only examples but no complete list. Then…

CSX Corporation Upgrades Databases 2x Faster With Oracle Real Application Testing

Wow – one of our reference projects went into the Yahoo Finance webpages. Carol Tagliaferri (my direct manager) worked with CSX, one of the largest US based railway companies, over a longer period together with the RAT team, and helped CSX to successfully upgrade and migrate their database landscape to Oracle Database 11.2. Plus: We did present about CSX at Oracle Open World 2012 as this project is a perfect showcase for: (a) an Upgrade project with many databases (b) over a longer period of time (c) using Real Application Testing decreasing the testing effort by factors! Read the published…