Amazon Web Services (AWS) : Relational Database Services (RDS) for MySQL

Here’s another video on my YouTube channel. This one is a quick run through of RDS for MySQL, a DBaaS offering from Amazon Web Services.

The video was based on this article.

If you watch the little outtake at the end you will hear me cracking up with the goofiest while filming Brian ‘Bex’ Huff‘s clip. :)



Amazon Web Services (AWS) : (more...)

Enterprise Planning: ‘too many cooks in the kitchen’?

Veel organisaties zien tegenwoordig in dat planning en budgeting niet langer de ‘+ X% van vorig jaar’-oefening van een enkele medewerker op de finance-afdeling kan zijn. Ze begrijpen dat als continue verbetering de noodzaak en frequente revisie van strategie de regel worden, er ook een realiseerbaar, voldoende gedetailleerd en flexibel toekomstbeeld moet zijn.

e reden daarvoor is niet enkel ‘voorspellen’, maar vooral inzicht krijgen in hoe de toekomstvisie van een onderneming concreet waargemaakt kan (more...)

The Data Brew – Week of Feb 8

The Data Brew - Your Source for Hot, Fresh Data News!

Welcome to The Data Brew! This weekly series highlights the latest in data-driven news and updates for marketers, all in one place.

Data Dark Roast

How Big Data is Changing Disruptive Innovation
Despite the many differences in application, most people agree that disruptive innovations are: cheaper, more accessible, and use a business model with structural cost advantages. Learn more on how data is changing disruptive innovation at Harvard Business Review.

Art in the Age of (more...)

Top Exastack ISV headlines: Gruter Tajo

Gruter achieves Oracle Exastack Big Data Appliance Optimized status with app Gruter Tajo Platform. Gruter Tajo, a scalable, cost-efficient SQL-on-Hadoop system for enterprise data warehousing, gains 15~50% performance increase running with Oracle Big Data Appliance.

The Oracle wait interface granularity of measurement

The intention of this blogpost is to show the Oracle wait time granularity and the Oracle database time measurement granularity. One of the reasons for doing this, is the Oracle database switched from using the function gettimeofday() up to version 11.2 to clock_gettime() to measure time.

This switch is understandable, as gettimeofday() is a best guess of the kernel of the wall clock time, while clock_gettime(CLOCK_MONOTONIC,…) is an monotonic increasing timer, which means it (more...)

PaaS4SaaS Developers’ Code Is Always ‘On’: OAUX is on OTN and GitHub

Boom! That's the sound of thunder as SaaS and PaaS developers work like lightning in the cloud. The cloud has changed customer expectations about applications; if they don’t like their user experience (UX) or they don’t get it fast, they’ll go elsewhere.

PaaS4SaaS developers know their code is always 'on'.

But you can accelerate the development of your PaaS4SaaS solutions with a killer UX easily by now downloading the AppsCloudUIKit software part of the Cloud (more...)

Security Alert CVE-2016-0603 Released

Oracle just released Security Alert CVE-2016-0603 to address a vulnerability that can be exploited when installing Java 6, 7 or 8 on the Windows platform. This vulnerability has received a CVSS Base Score of 7.6.

To be successfully exploited, this vulnerability requires that an unsuspecting user be tricked into visiting a malicious web site and download files to the user's system before installing Java 6, 7 or 8. Though considered relatively complex to exploit, (more...)

PeopleSoft is Recognized as “Best in Klas ERP Software” in Healthcare Industry

PeopleSoft is recognized as “Best in Klas ERP Software” in Healthcare Industry for 2015/2016  

Oracle PeopleSoft received exciting news about our efforts in the Healthcare Industry.  KLAS has named Oracle’s PeopleSoft the best ERP software in its "2015/2016 Best in KLAS Awards Report".  The report named top performing companies based on feedback from their customers. The title of Best in KLAS is a highly coveted recognition of outstanding efforts to help healthcare (more...)

How to store database credentials in Oracle Wallet (for WLS datasource definitions)

Oracle Wallet can be used to securely store the database credentials. Multiple credentials for multiple database can be stored in a single wallet file.

Below are the steps to create a datasource which uses Oracle wallet to store database credentials :

Step 1 :

Create a wallet in a secured location :

Command :  

$ORACLE_HOME/oracle_common/bin/mkstore -wrl <wallet_location> -create 

 Step 2:

Add database login credentials to the wallet 

Command :

 $ORACLE_HOME/oracle_common/bin/mkstore -wrl <wallet_location> -createCredential <db_connect_string> <username> (more...)

Infographic: Building Real Relationships on Social Media

Logging in the Data Warehouse Configuration Web Application

As of Primavera Data Warehouse 15.2 release, logging in the Configuration web application has the following behavior in a multiple data source environment.

If you have multiple data sources configured you will see multiple tabs along the top next to Home.  For each tab you can define an ETL schedule which wil result in each ETL running at a different time.  However the Status section (on both tabs) reads from the same (more...)

Indentifying Use Cases for Accelerating Apps with Oracle Database In-Memory

Wondering when to use Oracle Database 12c In-Memory?

This white paper identifies use cases for accelerating applications, and explains the scenarios under which Oracle Database In-Memory provides a performance benefit.

Following are just some of the scenarios discussed to determine whether your use case is a good match for this exciting new technology!

  • Improve the performance of analytics and reporting on data warehouse data.
  • Real-time reporting against the base OLTP data.
  • Enables analytic index maintenance (more...)

Parallel DML

A recent posting on OTN presented a performance anomaly when comparing a parallel “insert /*+ append */” with a parallel “create table as select”.  The CTAS statement took about 4 minutes, the insert about 45 minutes. Since the process of getting the data into the data blocks would be the same in both cases something was clearly not working properly. Following Occam’s razor, the first check had to be the execution plans – when (more...)

Partner news: Red Stack Tech rebranding to provide services for the entire Oracle Technology stack

Specialised Oracle Platinum Partner, Red Stack Tech have had their application to trademark their rebranded company name, 'Red Stack Tech' approved. The Oracle specialist company went through a rebrand in 2015 seeing its company name change from e-DBA to Red Stack Tech.

The rebrand to Red Stack Tech symbolises how far the company has grown from a remote database organisation in 1998 to a global organisation providing services across the entire Oracle Technology stack and (more...)

Installation von Hybrid Cloud Agenten – Quick Guide

Datenbanken, die in der Oracle Cloud im Rahmen von Database as a Service betrieben werden, können von Ihrer lokalen Cloud Control Umgebung verwaltet werden. Dazu müssen Sie in der Oracle Cloud die Agenten in den dort laufenden virtuellen Maschinen installieren. Dieser Tipp gibt Ihnen einen schnellen Einstieg in dieses Thema.

Het innovatieproces – strategisch of tussen wal en schip?

Door Joost Maliepaard, Solutions Director Retail, Distribution and Manufacturing

Over het belang van innovatie is de afgelopen tijd veel geschreven. Het
midden- en kleinbedrijf benoemde strategie en innovatie zelfs als prioriteit nummer 1 voor 2016. Ook uit onderzoek van PwC blijkt dat CEO’s innovatie als topprioriteit omschrijven.

Helaas gelooft
slechts 20 procent van deze CEO’s dat de investeringen zich voldoende terugverdienen. De conclusie van het onderzoek: het loont om het innovatieproces te borgen met een (more...)

EM13c: How to Disable Autodiscovery (and Autopromotion) of Clusterware Managed Targets

After we upgraded EM13c, I encountered a problem about automatically promoted listener targets. Since EM12c, I do not add/promote listeners. In earlier versions of EM12c, I had weird problems while monitoring listeners on RAC systems (such as they are detected down although they’re up). Since then, I don’t monitor them (specially SCAN listeners). In EM12c, when I remove a listener, it doesn’t promoted again. With EM13c, I see that listeners are discovered and promoted automatically (more...)

HCM Data Loader (HDL) – Objects Supporting Deletes

Here is a list of most commonly used objects during HDL conversion and if they support deletes or not. You can review HDL user guide for the complete list of supported objects. 

Delete command - You can use the DELETE action as part of the HDL (.dat) file for objects supporting deletes. Command identifies business-object components to be purged from Oracle Fusion HCM. You cannot delete individual date-effective records so you need to (more...)

Data Visualizations FAQ and New Data Visualization Articles on the JET Blog

Check out the latest data visualization articles on the Oracle JET Blog!

The Data Visualization FAQ provides pointers to answers to many questions about DVT components, such as which visualizations to use for which data sets, best practices, and more.

For our ADF and MAF customers, here are some very relevant articles that will help you with the common issues across the frameworks:

1. Which visualization should I use for percentage data sets?

Blog article: (more...)

An UNDO in a PDB in Oracle 12c?


According to the Oracle 12cR1 documentation and concepts, it is 100% clear that there can be only one UNDO tablespace in a multitenant architecture and it is at CDB level; thus, a PDB cannot have any UNDO tablespace.

Are we really sure about that? Let’s test it!

First, we need a PDB with few tablespaces:


FRED_PDB> select NAME, OPEN_MODE, CON_ID from v$pdbs ;

-------------------------------------------------- ---------- ----------