Index Sanity

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...)

Oracle Berkeley DB Java Edition 7.0 Announced

Oracle Berkeley DB Java Edition 7.0 is now available for download. Download Page – Click Here Documentation Page – Click Here Oracle Berkeley DB Java Edition Version 7.0 – New Feature · Time-To-Live – efficient aging out of “expired” data – This is a common IoT requirement. Berkeley DB JE continues... [Read 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

clip_image002

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...)

Summer Camps PaaS & Middleware – free partner trainings 2016

View this message in a Web browser


Oracle EMEA Partner Sales June 2016


Summer Camps PaaS & Middleware



Announcement or Updates


Dear Partners,

You are working on large Fusion Middleware & PaaS opportunities & projects? Oracle is pleased to invite you to the PaaS & Fusion Middleware Summer Camps 2016.

For technical experts we offer five days hands-on trainings in Lisbon or live virtual classes:

Lisbon
Aug 29th – Sept 2nd 2016
Live Virtual Classes from your desk
August 2016
PaaS (more...)

Fedora 24 and Oracle 12c

fedoraFedora 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...)

DataStax Cassandra 3.2 Bash Install Script

The below script installs the DataStax distribution of Cassandra 3.2.x and the latest Oracle Java 8 on Debian. Copy and paste the script into a file called install_cassandra.sh and execute it as root. [crayon-57710056be337224829235/] Then connect to the local Cassandra instance run the cqlsh tool. [crayon-57710056be341380981175/]  

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Full Transportable Export/Import - one of the coolest features in Oracle Database 12c  We blogged about Full Transportable Export/Import a while back. It is - no doubt - one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab - Upgrade,... [Read More]

Processing large XML files in the SOA Suite by Emiel Paasschens

clip_image002Read large XML files in chunks

Introduction

At 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 large.
Processing such large XML files consumes a lot of memory and can be a bottleneck especially when multiple end users are (more...)

Video : CASE Expressions and CASE Statements

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. 🙂

Cheers

Tim…


Video : CASE Expressions and CASE Statements was first posted on June (more...)

SOA & BPM 12.2.1 Installation and Configuration Workshop by John VanSant


clip_image002Overview of Workshop

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...)

Never …

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...)

The Secret to Maximizing Your Oracle OpenWorld Experience

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...)

Master Oracle SOA Suite 12c by Lucas Jellema

clip_image002

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...)

Network considerations on an ODA X5-2

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...)

Intro to Database Security – Part 4

In the previous parts I talked about database security and the infrastructure part of database security. In this post I will discuss the development aspect of the database. Links to the previous posts: Part 1 – general introduction to security Part 2 – introduction to database security Part 3 – infrastructure aspect of database security […]

Cluster Sets using SQL with Oracle Data Mining – Part 3

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.

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...)

SOA Cloud Service & Hybrid Integration updated presentations

clip_image002

At the SOA Community Workspace (SOA Community membership required) we posted the latest details about SOA Suite Cloud Service:

· SOACloudGoLiveOfficeHours-Final.pptx

· Hybrid Integration - CloudWorld-MexicoCity.pptx

· SOA Suite customer success deck 09.2015.pptx

· Oracle Integration Office Hours - PM ICS Roadmap and Demo.ppt

For more information please visit the SOA Cloud Service tag here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become (more...)

HP Systems Management vacancies – Bradford , West Yorkshire

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...)

NEW Security Learning Subscription – Preview for FREE Now!


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. 

Learn how Oracle University's Security Learning Subscription helps companies protect sensitive data. (more...)

Conditional SQL- 6

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...)