By popular demand (well, one person emailed me to ask for it) I’m going to publish the source code for a little demo I’ve been giving since the beginning of the millenium – it concerns indexes and the potential side effects that you can get when you drop an index that you’re not using. I think I’ve mentioned the effect several times in the history of this blog, but I can’t find an explicit piece (more...)
SOA & BPM Partner Community Webcast – tomorrow June 28th 2016 What’s new in Integration Cloud Service? Your High Productivity Integration Platform in the Cloud
Attend our June edition of the SOA & BPM Partner Community Webcast live on June 28th at 16:00 CET.
What’s new in Integration Cloud Service? Your High Productivity Integration Platform in the Cloud
During this session, we will be joined by Ramkumar Menon, the Product Manager for Oracle’s Integration Cloud Service (ICS). Ram will provide you an update on the latest on ICS, which now boasts more functional and connectivity capabilities than ever before (more...)
View this message in a Web browser
Fedora 24 was released a few days ago. As usual I had a play around with it and tried installing Oracle on it.
First comes the warnings, because people keep misunderstand why I do this. Do not install Oracle on Fedora before reading this!
With that out of the way, here’s what I did.
No real drama here. It (more...)
Full Transportable Export/Import – Migrating an 22.214.171.124 database to Oracle Database 12c- into the Oracle Cloud
my current project, XML files are uploaded by the end-user to be
processed in the Oracle SOA Suite. The XML files contain information
about employers and their employees. Because an employer can have
hundreds and even thousands of employees, these XML files can be quite
Processing such large XML files consumes a lot of memory and can be a bottleneck especially when multiple end users are (more...)
Today’s video is about CASE expressions and CASE statements.
The guest in today’s video is Scott Wesley, who is currently plugging his new book called Pro jQuery in Oracle Application Express. He will no doubt use the vast quantities of money he makes from the books sales to throw outlandishly extravagant barbecues, because that’s all they do down under. 🙂
Video : CASE Expressions and CASE Statements was first posted on June (more...)
This workshop will guide the participant through the installation of a non-development environment for SOA and BPM Suite v12.2.1. This workshop won’t cover the installation of the SOA Quickstart install, but the installation of the production software. Some notable differences between the Quickstart install and production bits are:
- The Quickstart installer doesn’t require an Oracle Database but uses a Java Database. In order to use BAM, an Oracle Database is (more...)
From time to time a question comes up on OTN that results in someone responding with the mantra: “Never do in PL/SQL that which can be done in plain SQL”. It’s a theme I’ve mentioned a couple of times before on this blog, most recently with regard to Bryn Llewellyn’s presentation on transforming one table into another and Stew Ashton’s use of Analytic functions to solve a problem that I got stuck with.
Here’s a (more...)
One day can make a huge difference. If you're already attending Oracle OpenWorld, get the most out of your conference experience by adding on Oracle University Preconference training.
Oracle University Preconference training is a one-day event held on Sunday, September 18 at Golden Gate University near Moscone Center. Sessions run from 8:30 am-3:30 pm with an hour break for lunch.
Why attend? Because Oracle experts are on-hand to provide deep dives into accelerated technical (more...)
Design, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this (more...)
When you buy an Oracle Database Appliance (ODA) X5-2 off the shelve, you will get a machine with four times 10Gb copper Ethernet (bonded into two interfaces) for public communication and two 40Gb InfiniBand (bonded into one interface) for interconnect communication between the two ODA_BASE’s. You would think that should be more than enough. Well in most cases it is. The interconnect running through InfiniBand is stunning for RAC and the public interface should be (more...)
This is the third blog post on my series on examining the Clusters that were predicted by an Oracle Data Mining model. Check out the previous blog posts.
- Part 1 - Examining predicted Clusters and Cluster details using SQL
- Part 2 - Cluster Details with Oracle Data Mining
In the previous posts we were able to list the predicted cluster for each record in our data set. This is the cluster that the records belonged (more...)
For more information please visit the SOA Cloud Service tag here.
For regular information on Oracle SOA Suite become (more...)
I have recently taken over our Systems Management team and we have several vacancies for people used to working with the HP toolset. I know my blog is read almost entirely by DBAs but I am sure some of you work with Systems management teams and hopefully you can pass a link on to anyone you think might be interested.
The main tools used are
- HP Service manager 9.x
- HP Operations manager for Windows, (more...)
Protecting corporate information and technology assets from intruders is a significant challenge for most enterprises.
Historically, investments in security technology were made by individual technology managers and business units in response to the specific threats.
CIOs are now implementing technologies that can support the centralized management and enforcement of security policy.
An odd little anomaly showed up on the OTN database forum a few days ago where a query involving a table covered by Oracle Label Security (OLS) seemed to wrap itself into a non-mergeable view when written using traditional Oracle SQL, but allowed for view-merging when accessed through ANSI standard SQL. I don’t know why there’s a difference but it did prompt a thought about non-mergeable views and what I’ve previously called “conditional SQL” – (more...)