APEX 5 New Column Link Features

In the current version of Oracle Application Express you could use up to three items in a Column Link.
Most of the times that is enough. But there were always some use cases where you needed four or even five. And of course, just like with all limitations, you can figure out a work around. But wouldn't it be just awesome if APEX offers us more items out of the box.

And in APEX 5 (more...)

Big Data Lite VM v3 : VMのお試し環境

オラクルのビッグデータ関連製品がつまったVM環境(Virtual Box)をOTNで公開しています。


★Oracle Big Data Lite Virtual Machine



  • Oracle Enterprise Linux 6.4
  • Oracle Database 12c Release 1 Enterprise Edition ( with Oracle Advanced Analytics, Spatial & Graph, and more
  • Cloudera’s Distribution including Apache Hadoop (CDH 5.0)
  • Oracle Big Data Connectors 3.0
  • Oracle SQL Connector for HDFS 3.0.0
  • Oracle Loader for Hadoop 3.0.0
  • Oracle Data Integrator 12c
  • Oracle R Advanced (more...)

Order, Order.. Sorting Happens Last

While preparing for my session at Oracle Open World on "Oracle 12c for Developers" I ran into a little remarkable thing.

When sorting a dataset, the sorting is always done last. That is what I was taught anyway. There is probably some obscure way to detect the exact execution plan, but personally I never bothered to go and investigate.
When I was created some test scripts I found there was a way to see that (more...)

ACM 11g – Activities by Suyash Khot

In my previous blog, we looked at Oracle ACM's Title, Priority, and Category artifacts and their configurations in an Oracle ACM project. In this blog, we will dig a bit deeper into ACM, specifically ACM Activities. Within an ACM Case, when you create an ACM Activity, you are presented with a few properties that need be set for the activity. The values you select in these properties will define that activity. In this blog (more...)

Hands-On Programming with R by Garrett Grolemund

R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS.
R language is useful to become a data scientist, as well as a computer scientist. I mention a book that points about a data science with R. A Hands-On Programming with R Write Your Own Functions and Simulations By Garrett Grolemund. It was written how to solve the logistical problems of (more...)

Insights from an Oracle University Classroom – Oracle Data Integrator: What is a Repository?

By Brent Dayley, Senior Instructor at Oracle University

"While teaching Oracle University classes on Oracle Data Integrator, I often instruct my students that it takes roughly one and a half days to understand the setup that we do in ODI Studio in order to start to map data from source to target. I start out by giving them a visual tour of the four navigators: Topology, Security, Designer and Operator."

Read full blog entry (more...)

Rolling Out-of-Place patching para Oracle Grid Infrastructure 12c y 11gR2: clonación en esteroides

Mi artículo más reciente para ToadWorld, dentro de una serie dedicada a aplicar patches con mínima suspensión del servicio. Ahora detallando cómo aplicar patches a Grid Infrastructure usando un Golden Image.

Session Schedule Information OpenWorld 2014 San Francisco

I have received my session schedule information for OpenWorld 2014. This year event is going to be quite busy with three sessions. Below you can check session titles along with times, looking forward to meet you in San Francisco !

Session ID: CON2623
Session Title: Oracle ADF Development and Deployment to Oracle Cloud
Venue / Room: Moscone South - 270
Date and Time: 10/1/14, 15:30 - 16:15

Session ID: CON3745 (together with Danilo Schmiedel)
Session Title: (more...)

Rittman Mead in the OTN TOUR Latin America 2014

Another OTN Tour Latin America has come and gone. This is the most important technical event in the region visiting 12 countries and with more than 2500 attendees in two weeks.

This year Rittman Mead was part of the OTN Tour in Buenos Aires (Argentina) and Montevideo (Uruguay) presenting about ODI and OGG.

We have started in Buenos Aires on August 11 for the first day of the OTN Tour in Argentina. I’ve talked about (more...)

Greening of Storage

By Tim Gorman

I recall that the Dec 1999 or Jan 2000 issues of Nat’l Geographic magazine had a “Letters From The Editor” column that speculated, in jest, that the rate at which humans were saving back-issues of Nat’l Geographic magazine, would by the year 2100 result in the total accumulation of yellow magazines outweighing planet Earth.

Anyway, that statement resonated with me, because although I change residences every few years, it has only been (more...)

Unforgettable In-Memory

Inspired by Maria Colgans quest for In-Memory bumper sticker slogans for OOW14, I couldn't resist a little fun. Musical readers should stop reading now :-)

Sung to the tune of the old Nat King Cole classic

Like wizardry

Like the speed of light my query go
Column aggregates just happen so
Never before
Has data been more...

So cleverly
Is forever more

Row based access, it's a dinosaur

The Next Big Thing

Oracle’s was released a few weeks ago (You can download it from OTN here: Oracle Download). While technically a minor point release, it contains a couple of major features that would normally be rolled out in a more substantial version change like 12cR2 or perhaps V13. Of course the most highly anticipated feature is a new option (Oracle In-Memory Option) that provides a column (more...)

White Elephant Requirements

I’m often engaged with clients helping them respond to Requests for Proposals (RFPs), and there are way too many bad RFPs out there.

These bad RFPs not only specify what the customer actually needs, they also specify that the customer can possibly think he will ever need. Typical requirements are that the user must be able to add extra attributes to all entities, or that the user can dynamically change which attributes are mandatory, or (more...)

Sqlnet tracing during nightly hours…

A TNS error at night…

Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to update his data warehouse. That night one of his jobs did not run properly and generated an ORA-12592 error. He had to restart this job during daytime.

It turned out it was not the only occurrence of this TNS error. A couple of days later he (more...)

APEX 5 New Supporting Objects Features

In the current version of APEX the Supporting Objects feature is undervalued. You can create (sort of) self installing applications with it, but it is not widely used. Why? Because people don't realy know the feature or people do and experience lack of functionality. In both cases : Check out the functionality of APEX 5!
When you have scripts for creating tables, packages etc., in the current version you have to manually keep those (more...)

%sql: To Pandas and Back

A Pandas DataFrame has a nice to_sql(table_name, sqlalchemy_engine) method that saves itself to a database.

The only trouble is that coming up with the SQLAlchemy Engine object is a little bit of a pain, and if you're using the IPython %sql magic, your %sql session already has an SQLAlchemy engine anyway. So I created a bogus PERSIST pseudo-SQL command that simply calls to_sql with the open database connection:

%sql PERSIST mydataframe

The result is (more...)

Upcoming Big Data and Hadoop for Oracle BI, DW and DI Developers Presentations

If you’ve been following our postings on the blog over the past year, you’ll probably have seen quite a lot of activity around big data and Hadoop and in particular, what these technologies bring to the world of Oracle Business Intelligence, Oracle Data Warehousing and Oracle Data Integration. For anyone who’s not had a chance to read the posts and articles, the three links below are a great introduction to what we’ve been up to:

Talend: tips and tricks part 2

In the first part of these entries we discussed how to test your expressions, the importance of optimizing the appearance of a tLogRow component and how to handle windows and views within Talend. This time around, we will be talking about the different ways to get components into your job, how to trace your dataflow and how to easily sync columns. As last time, this post will be useful for both starting and experienced users.


Complément : Analyse des performances sur du long terme Introduction to Attribute Clustering (The Division Bell)

One of the really cool new features introduced in is Attribute Clustering. This new table based attribute allows you to very easily cluster data in close physical proximity based on the content of specific columns. As I’ve discussed many times, indexes love table data that is physically clustered in a similar manner to the index […]