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

Read the latest Oracle Utilities News – June 2016 Edition


Oracle Partner Network and the Utilities Global Business Unit are pleased to announce this latest news to the Utilities Partner Community!

Read all about them in the latest Oracle Utilities Partner Newsletter

Query tuning by waste minimization: a real-life example

Today I’d like to share another tuning example from a recent case at work, which in my opinion is good for illustrating typical steps involved in SQL optimization process.

I was handed a poorly performing query with a relatively verbose text, so I will only give the general structure here (it will also prevent me from accidentally disclosing some sensitive information from that application):

SELECT 
       /* long list of columns here */
       ,
	   (select *  (more...)

Oracle DBA vacancy – Bradford, West Yorkshire

My team has a permanent vacancy which almost anyone could apply for.

We are looking for a good DBA with RAC, RMAN and Dataguard skills

We  are thinking that we might wish to take on a Junior DBA who has some skills but maybe not all three listed above.

We would also consider someone who has no real experience  – maybe has used RDBMS at University

Whoever we take-on will get a broad experience of (more...)

Oracle GoldenGate Studio 12.2.1.1.0 Release is Available

Oracle GoldenGate Studio (OGGS) 12.2.1.1.0 is released on June 21st, 2016. You can now download the software from OTN and eDelivery. This is the second release after we launched the OGGS at the start of this calendar year. In this release, we have certified two new heterogeneous databases (MySQL and Microsoft SQL Server) that you can use to design and deploy in high-volume, real-time database replication.

Key Features

New OA Framework 12.1 Release Update Pack 5 Now Available

Web-based content in Oracle E-Business Suite 12 runs on the Oracle Application Framework (OAF or "OA Framework") user interface libraries and infrastructure.   Since the release of Oracle E-Business Suite 12.1 in 2009, we have released several cumulative updates to Oracle Application Framework to fix performance, security, and stability issues. 

These updates are provided in cumulative Release Update Packs. "Cumulative" means that the latest Release Update Pack includes all of fixes released in (more...)

Time Slider Bug In Solaris 11: Snapshots Created Only For Leaf Datasets

Time Slider is a feature in Solaris that allows you to open past versions of your files.

It is implemented via a service which creates automatic ZFS snapshots every 15 minutes (frequent), hourly, daily, weekly and monthly. By default it retains only 3 frequent, 23 hourly, 6 daily, 3 weekly and 12 monthly snapshots.

I am using Time Slider on several Solaris 11.x servers and I found the same problem on all of them (more...)

ASMCMD&gt: A Better DU, Version 2

A while ago, I posted a better “du” for asmcmd . Since then, Oracle 12cR2 beta has been released but it seems that our poor old “du” will not be improved.

I then wrote a better “better du for asmcmd” with some cool new features compared to the previous one which was quite primitive.

In this second version you will find :

  • No need to set up your environment, asmdu will do it for you
  • (more...)

My New Book!

After what seems like eons since we first started on it, I’m excited to announce a new book I co-authored is finally out. The book is called “Building Database Clouds in Oracle 12c” and is available on Amazon. Of course, it really isn’t that long ago that we started writing the book, but there’s been a lot happening between then and now!

The book was co-authored with Tariq Farooq and Sridhar Avantsa. Tariq asked me (more...)