From Gwen Shapira’s interview in the May 2015 issue of the NoCOUG Journal :
“I got my current job at Cloudera through Twitter.
At the time, I was working with a retailer in Japan, as a consultant through Pythian. I was there to help them migrate to Exadata, but their data warehouse system was tightly integrated with Hadoop, and I got to work on this integration too. I got a lot of exposure to Cloudera’s distribution—indispensible tools for integrating Hadoop with data...(read more)
The title of today’s Friday Philosophy sounds extreme, but it’s true.
Continuing from the previous part - which was about the Temp Table Transformation and join cardinality estimates - using the same simple table setup here is a slight variation of the previously used query to demonstrate the potential impact on single table cardinality estimates:
explain plan for
cte as (
select /* inline */ id from t1 t
where 1 = 1
*/ * from cte a, cte b
where a.id = b.id
and a.id > 990 and b.id > 990
-- 11.2.0.x Plan with TEMP transformation
In this series of posts I’ve been discussing my opinion on various aspects of writing, including blogging, writing articles and whitepapers, or just writing documentation in your company. If anything more comes to mind I’ll write it and link it from this post.
Here are the posts that made up this series.
SLOB 2.3 is soon to be released. This version has a lot of new, important features but also a significant amount of tuning in the data loading kit. Before sharing where the progress is on that front, I’ll quickly list some of the new important features that will be in SLOB 2.3:
I’ve been using VMware Fusion on my Mac but it costs about $60. Not that much but Virtualbox is free, so I also have Virtualbox as well.
For my VMs I use DHCP and this has caused some problems but mainly on Virtualbox. With VMware Fusion (and VMware Workstation) everything works fine.
With VMware, under “Edit Hardware Settings” then “Network Adaptor” I just set the network
This causes the system to act as a router, isolating the VM’s on their own network, while allowing internet connectivity outbound as well as being able to connect to the VMs from my laptop and being able to connect from one VM to another.
I mentioned in a recent post that Oracle are often guilty of changing URLs, which breaks all the documentation links in your site. Someone replied with this link. I knew I had a lot of clean-up to do, but I expected most of it to be old URLs, like stuff pointing to 8i, 9i etc.
I’ve just been looking and vast swathes of links have been changed in the 12.1 docs. In some cases, articles I wrote a couple of weeks ago are screwed. The reference manual is guilty of this big time!
If you’ve followed my blog you will know people try to steal my articles all the time. It happens to all bloggers, unless they are unpopular or rubbish. You don’t really have to look for it, because your readers will spot it and tell you.
Some things to remember about this stuff…
All material published on the internet has an implicit copyright, even if there is no explicit copyright notice on the site. This means, unless the copyright owner gives you explicit permission, republishing their content is an act of theft. When you are writing, make sure you are doing the work, not stealing other people’s work.
With Oracle’s move towards engineered systems we all know that “more” is being done down at the storage layer and modern storage arrays have hundreds of spindles and massive caches. Does it really matter if data is kept in the Database Buffer Cache anymore?
Yes. Yes it does.
With much larger data sets and the still-real issue of less disk spindles per GB of data, the Oracle database buffer cache is not so important as it was. It is even more important.