At Rittman Mead, we believe that people are more important than profit.
This manifests itself in two ways. First, we want to impact the world beyond data and analytics, and secondly, we want our employees to be able to contribute to organizations they believe are doing impactful work.
This year, we’ve put a Community Service requirement in place for all of our full-time employees.
We’ll each spend 40 hours this year serving with various nonprofits. (more...)
In the previous part of this mini-series we looked at differences in multiblock read behavior for different nested loop optimization mechanisms depending on degree of ordering of the data. In this post I’ll continue to explore the subject, but this time we’ll focus on decision-making process: what factors (other than the obvious ones — like optimizer hints and/or parameters) affect the specific choice of a mechanism?
Previously, we saw that in all nested (more...)
It’s interesting that we still see lots of code out “in the wild” that leans itself to taking forever. Now I’m not talking here about poorly performing SQL etc…because (at least theoretically) no matter how bad the SQL is, presumably it will finish one day, even if that day is years into the future. What I’m referring to here is the default mechanism for locking in Oracle.
If you try access a row that is (more...)
Integration is the term we employ for ‘what ties systems together into end-to-end interaction flows’. Integration describes what we have to do to make applications in one domain talk to those in another, or systems in one enterprise talk to those in another. And to systems running in one cloud interact with those running in another cloud or those running on premises. Integration is ideally approached based on standard based service interfaces and encapsulated implementations. (more...)
Still loving the idea to use Oracle Enterprise Manager as a ‘kind of ‘ Software Asset Management Tool, and get regular centralized reports that tells me what Oracle software is running and if there are changes in use of licenses over time. The necessary data is already there in the OEM repository, so there should be standard report facilities to get me informed (other then my own sql-reports from the repository). And guess what, these (more...)
One problem with the architecture of most SQL clients is they connect to a database, send off a SQL statement and do nothing until the database responds back with an answer. That's a great model when (more...)
Oracle has released a nicely packaged, preconfigured OEM 13c environment for us to play with inside Oracle Virtual Box. The VM comes with an installed repository database, a management server, and a local agent. Great starting place.
Download the zip files from http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/oem-templates-2767917.html.
Lets walk through items c-f since the instructions aren’t super clear.
Item c: Uncheck ‘Programs’ when edelivery brings up this page
Item d: Start typing Oracle VM (more...)
Doing performance measurements of an OSB Proxy Service by programmatically extracting performance metrics via the ServiceDomainMBean and presenting them as an image via a PowerPoint VBA module
This article explains how the process of doing performance measurements of an OSB Proxy Service and presenting them in a “performance analysis document” was partly automated. After running a SoapUI based Test Step (sending a request to the service), extracting the service performance metrics was done by using the ServiceDomainMBean in the public API of the Oracle Service Bus. These service performance metrics can be seen in the Oracle Service Bus Console via the Service (more...)
The latest video on my YouTube Channel is a run through of using the Database as a Service (DBaaS) offering on Oracle Cloud.
There have been a few minor changes in the interface since I last ran through capturing images, so the related article has been brought up to date.
Martin Preiss (see comments) has been working hard to investigate this, and managed to produce a couple more variations in statistics for 'the same' problem.Ganz so hart war die Arbeit nicht, aber überraschend war das Ergebnis für mich allemal. Interessant ist zunächst, dass sich zwar Angaben für die Statistiken "table scans (short (more...)
I know what you are thinking. Not another standby monitoring script, right?
There’s plenty of them out there already and what makes this one any different?
You are probably correct and there’s probably nothing different about this.
Having to work with environments that are inconsistent such as manual standby, dataguard without broker, dataguard with broker,
I have been obsessed to create standby SQL which can accommodate any environment and can be run from primary or (more...)
The title of the Contribute event/seminar was "Oracle Forms 12c: Built to last".
Indeed, Forms is built to last. It has been around for over 20 years and it's added to Oracle Fusion Middleware 12c, which is supported until 2023.
Oracle Forms is still running at a lot of Belgian companies looking at the turnout.
I saw a tweet that made me smile a few days ago:
Like many of you, I started out my working life in IT as a computer programmer. Like some of you, I still am a computer programmer from time to time. I don’t think I’ve had a year of my working life when I did not do either some application development programming or some database infrastructure programming. I am constantly writing small (or not (more...)
It’s amazing how easy it is to interpret a number incorrectly until the point comes where you have to look at it closely – and then you realise that there was a lot more to the number than your initial casual assumption, and you would have realised it all along if you’d ever needed to think about it before.
Here’s a little case in point. I have a simple (i.e. non-partitioned) heap table t1 (more...)
The task at hand is to call (more...)