Each year at the annual Oracle ACE Director briefing, I look around at the laptops my fellow ACE Directors are carrying. More and more of them are MacBooks – I think we were up to around 50% last year.
That makes it all the more puzzling that the installation guide for the latest version of Oracle JDeveloper (12.1.3) does not mention OS X installs at all. The 12.1.2 version had sections (more...)
We have a fairly common query process, where we run a MERGE command to compare a remote table to a local copy of it, as "poor mans" Golden Gate to bring that table up to date on a regular basis. [Editors note: Writing MERGE's is more complicated but a lot cheaper than Golden Gate :-)]
After an upgrade to 12c, the performance of some of the MERGE’s went very bad…and you can see what (more...)
I played a lot of volleyball in a bygone life :-) and subsequently ruined my knees to the extent that I needed surgery. I got a shock when the surgeon (after a series of x-rays and checks) said to me: "Of course, we’ll only know once we’re in there".
So here’s a body part (a knee) that’s had hundreds of thousands of years to evolve, so you’d expect that knees are pretty much the same (more...)
We did a "real" upgrade to 12c this weekend, where "real" means a production system, as opposed to my laptop, a play VM etc etc :-)
It all went relatively smoothly except for one interesting thing, that I can’t 100% say was caused by the upgrade, but it would appear to be the case.
After the upgrade, our scheduler external jobs started failing. A quick look in the alert log revealed:
Sun Jun 29 (more...)
Lucas Jellema is writing a great series on SQL applied to the World Cup of football / soccer. In the article about finding matches with comebacks, he challenged readers to “find ‘dramatic comebacks’ where a team was two goals behind at some stage and yet managed to win the game.” Here is my reply, since replying […]
I came across an interesting article Employees Who Stay In Companies Longer Than Two Years Get Paid 50% Less and thought to share with you.
Let’s use the rule of 72 as an example.
Basically, the rule of 72 is a simple method of determining the number of years an investment will double by dividing 72 by the rate of return.
With a 4% annual salary increase, salary will double in 18 years (72/4).
With an (more...)
Sweet! I just installed the software from the CD that came with Sam Alapati’s book related to the OCP 12c upgrade exam and found that it has questions related to the key DBA skills section of the test. Now I feel good about my test preparation materials. The first time I took the test I didn’t have this degree of guidance on what to study, especially on the key DBA skills section.
For many Oracle database patches there is an option to apply them “online”, i.e. without stopping the database and related services (listener, ASM etc.). This is very convenient when downtime is impossible or difficult to arrange. However, this convenience comes at a certain price, including some performance penalties. Such side effects of hot patching are not well understood, even by Oracle support engineers.
There is a MOS note 761111.1 where in addition to (more...)
I was looking into some new features of 12c and I didn’t need to dig deep, in order to figure out how does the “fetch first” feature work:
QL> set autotrace on
SQL> select ename from emp offset 5 rows fetch next 5 rows only;
Plan hash value: 3611411408
| Id | Operation | Name | Rows | Bytes | Cost (more...)
Another wager lost to my daughter, this time an iPhone 5s.
Thank God she does not want the 6.
Learning the alphabets in school, A is for apple.
Earning straight A’s all the way through 8th grade.
Having dad pay for all the Apple toys – Priceless!
Supporting an enterprise software system like Oracle WebCenter is no easy task. Technical complexities, customizations, and multiple versions make it difficult to resolve issues quickly and keep the system up and running. Without a dedicated and knowledgeable support team, WebCenter environments can suffer from system downtime, poor performance, and frustrated users.
Join Fishbowl Solutions for a webinar as they discuss their Oracle WebCenter technical support offerings. These offerings include specific technical services to support WebCenter (more...)
Here’s a quick list of several new EM CLI verbs and a few deprecated verbs in OEM 22.214.171.124:
New verb > modify_monitoring_agent
Deprecated > resyncAgent
Deprecated > get_signoff_status
New verb > grant_bipublisher_roles
New verb > revoke_bipublisher_roles
New verb > add_blackout_reason
New verb > add_chargeback_entity
New verb > assign_charge_plan
New verb > assign_cost_center
New verb > create_charge_entity_type
New verb > create_charge_item
New verb > delete_charge_item
New verb > export_charge_plans
New verb > export_custom_charge_items
The idea of clouds “meeting" big data or big data "living in" clouds isn’t simply marketing hype. Because big data followed so closely on the trend of cloud computing, both customers and vendors still struggle to understand the differences from their enterprise-centric perspectives. Everyone assumes that Hadoop can work in conventional clouds as easily as […]
Data lakes, like legacy storage arrays, are passive. They only hold data. Hadoop is an active reservoir, not a passive data lake. HDFS is a computational file system that can digest, filter and analyze any data in the reservoir, not just store it. HDFS is the only economically sustainable, computational file system in existence. Some […]
I was recently invited to speak about big data at the Rocky Mountain Oracle User's Group. I presentedto Oracle professionals who are faced with an onslaught of hype and mythology regarding Big Data in generaland Hadoop in particular. Most of the audience was familiar with the difficulty of attempting to engineer even Modest Data on […]
In the 1960s, Bank of America and IBM built one of the first credit card processing systems. Although those early mainframes processed just a fraction of the data compared to that of eBay or Amazon, the engineering was complex for the day. Once credit cards became popular, processing systems had to be built to handle […]
Next up in the ‘hit list’ of topics on the way to specialisation is the Security Specialist. Fusion Security was designed with Role Based Access Control (RBAC) at its heart, allowing separation of duties for Sarbanes Oxley compliance easier to achieve, so that should make it easier to pick up, given my history of PeopleSoft. Let’s dive in …
There are a number of different role types in Fusion. My first impression is (more...)
If you speak german and you are interested in quality assurance for your ADF projects you should come and attend my presentation at DOAG Development on 06/04/2014 in Dusseldorf.
I will show you, how you can implement in the JDeveloper IDE and in Continous Integration server Jenkins:
- static code analysis with PMD, FindBugs and Checkstyle
- Commit tests with JUnit, Mockito and Powermock for Mockito
- Code coverage for commit tests with JaCoCo
- Acceptance tests with JUnit (more...)
Whether you already have or are planning to build an Oracle WebCenter-based intranet, extranet or customer portal, its overall success hinges on its time to market, ability to scale, and the presence of user productivity tools. Attend this webinar to see how Fishbowl’s Portal Solution Accelerator (PSA) can provide an extensible framework that bundles reusable templates and page layouts, standards-based portlets, and in-place security administration. Join us to discover how this framework can be applied (more...)