Reaction to Shadow IT
- Misaligned Expectations
- Increased Data Exposure and Administrative Surface Area of Risk
- Choice of newer better cloud options now available after initial “wrong choice”
Read and monitor Oracle related blogs and news sources, all in one place.
Reaction to Shadow IT
Currently drinking a bottle of this
I didn’t actually notice the name until I opened it tonight.
I finished testing 1000 select statements on our new Exadata X5 to see if they would run faster or slower than on our older Exadata V2. Our current production V2 has 12 nodes and the new X5 has only 2. The memory and parallel server parameters on the X5 are 6 times are large as on the old one, since we have one sixth as many hosts and more than 6 times the memory and (more...)
This post is just a quick note to myself on how to configure JBDC on Oracle Enterprise Data Quality (OEDQ) to connect to different databases.
First let’s talk about connecting to Oracle database. By default, OEDQ’s Data Store can only connect Oracle database by SID, but not by Service Name.
Fortunately, the JDBC connection option is available to take advantage of the connection string that can support Service Name and multiple hosts if needed.
Credit: Matthias Weinberger (CC2)
What is Devops?
As has been noted many of times, DevOps is a term that is hard to define.
DevOps is a term that is so easily misapplied in the enterprise that it’s popularity threatens adoption.
If you can’t define it for the bean counters – it might as well not exist at all.
Thus being able to clearly define DevOps is crucial to its success.
For the last post in this series, I want to end with something that will help you improve the overall quality of your apex applications. That something is called: “advisor”.
The easiest way to access advisor is through the edit page. If you press the “utilities” button, and then select the option “check”, you will end up in an advisor report for the current page.
read the full IDC report on Virtual Data here.
Here are some key sound bites from the report:
“Data has turned IT departments into business enablers. Data acts as a tax on IT operations when IT departments cannot do what businesses need them to do because they are too busy ‘keeping the lights on.’ ”
“When we bought Delphix, the original reason was all of the terabytes we were avoiding. But now, the main benefit for (more...)
Today it’s all about developing software that makes access to your product easier.
We are also seeing the same thing happen in IT where cloud such as AWS is undercutting industry hardware vendors like Oracle, Netapp, EMC
Steve Jobs sets a great perspective on the journey of simplicity. It starts from simple, goes through complexity and ends up in simplicity.
“When you start looking at a problem and it seems really simple, you don’t really understand the complexity of the problem. Then you get into the problem, and you see that it’s really complicated, and you come up with all these convoluted solutions. That’s sort of the middle, and that’s (more...)
I don’t know if you are ever asked to compare to AWR periods. AWR period comparison is pretty easy if you have access to the two periods in the same AWR repository. AWR in the same repository can be compared with
SELECT * FROM TABLE( dbms_workload_repository.awr_diff_report_text( [db_id ], [instance id], 120, -- start snapshot id 121, -- end snapshot id [db_id of target, [instance id] , 122, -- start snapshot id 123 -- end (more...)
Here is a short video
You can find the full length video of my Delphix talk that I did at OakTable World on Tuesday here: url
Also, the OakTable folks have updated the OakTable World agenda page with video of all the talks. This has lots of good material and for free. Scroll down to the bottom of the page to find the links to the videos.
We’re running a set of three webcasts together with Oracle on three popular use-cases for big data within an Oracle context – with the first one running tomorrow, November 3rd 2015 15:00 – 16:00 GMT / 16:00 – 17:00 CET on extending the data warehouse using Hadoop and NoSQL technologies.
The sessions are running over three weeks this month and look at ways we’re seeing Rittman Mead use big data technologies to extend the and capabilities of their (more...)
When I am trying to install oracle 12c software in windows server 2012 r2, Its asking the windows user credentials. So I had given the windows new user “Test” and password like ” Test@123″ . Oracle installer accepted this password but windows not accepted this password because of password poilcy.
To improve optimizer estimates in case of skewed data distribution , histograms can be created. Prior to 12c, based on No. of distinct values (NDV) in a column two types of histograms could be created :
if no. of buckets >= NDV, frequency histogram is created and the optimizer makes accurate estimates.
If no. of buckets < NDV, height balanced histogram is created and accuracy of optimizer estimates depends on whether a key value is (more...)
This morning was my last day of Oracle OpenWorld sessions and this afternoon and evening finished off my day with Delphix Sync.
The first talk was my only NoSQL talk. It was interesting because the claim was that NoSQL was good for large numbers of simple transactions. This seems to be a theme across a couple of sessions. The funny thing is that the NoSQL code reminded me of my pre-SQL mainframe Datacom DB database (more...)
Well, it was a long day but it ended in a fun way.
Today I was back to the normal OpenWorld sessions starting with the general session. It was eye-opening because the speakers described a new CPU chip that they were using in their latest servers. It had some custom elements to support database processing. It was strange because I have recently been studying the latest Intel x86 documentation and it was interesting to compare (more...)
Instead of going to the normal OpenWorld events today I went to OakTable World. Now my brain is fried from information overload.
It started at 8 am with a nice talk about hash joins and Bloom filters. Toon Koppelaars had some nice moving graphics showing how bloom filters work. I’ve studied Bloom filters before but I’m not sure I understood it with the clarity that I had after this talk.
Then I did my talk (more...)