Exadata and Bash Shellshock

There has recently been a lot of news about the exploit revealed in the bash shell.  While the fix is very quick to implement, there are a couple of tricks that are required to install this update on an Exadata environment.  According to Oracle support note #1405320.1, Exadata storage server versions 11.2.3.x.x and 12.1.1.x.x are susceptible to the exploit.  On a typical Oracle Enterprise Linux, a simple (more...)

RDX IT Process Automation

RDX’s IT Process Automation Strategy

Remote DBA Experts (RDX) is the largest pure-play provider of remote data infrastructure services. We have been providing remote services for over 20 years, which also makes us one of the pioneers in this space. We currently support hundreds of customers and thousands of database implementations.

Remote data infrastructure services is an extremely competitive market arena. Our competitors range from “2 guys in a garage” to major outsourcing providers like (more...)

Plea For Tight Messages – OOW14

It’s so easy to lose track of time at Oracle OpenWorld.  I think I’m writing this on Tuesday, but can’t say for sure…

Lots of information being shared here:  incremental development of Simplified UI, a myriad of new cloud services announced (including a very cool Integration Cloud Service), new features for MySQL, new mobile applications for the E-Business Suite, Eloqua services for Higher Education, a visualization-oriented UI for OBIEE (and saw a very cool (more...)

ADF and service dependencies

In order to keep the business-IT gap manageable, it is important for analysts, designers and architects to know what their implemented application landscape actually looks like. An important part of this is insight in dependencies between different components. In my previous blog post I’ve described how service dependencies can be determined. In this blog post I will provide a script for analyzing which services are called by ADF pages. Keep in mind both analyses are executed on (more...)

Packt Publishing – ALL eBooks and Videos are just $10 each or less until the 2nd of October

Just spread good campaign from Packt Publishing - It's a good news for people who love to learn something new - ALL eBooks and Videos are just $10 or less -- the more you choose to learn, the more you save:
  • Any 1 or 2 eBooks/Videos -- $10 each
  • Any 3-5 eBooks/Videos -- $8 each
  • Any 6 or more eBooks/Videos -- $6 each


OCP 12C – Managing CDBs and PDBs

Connecting to a CDB or PDB Connecting to a CDB or PDB is not different of connecting to a standard database. When you create a PDB, it is automatically assigned a service which can be used to reach this specific PDB. You can either use the EZ connect syntax, the Oracle Net Service syntax or the [...]

The post OCP 12C – Managing CDBs and PDBs appeared first on Oracle DBA Scripts and Articles (Montreal).

Exadata: What’s Coming

This is based on the presentation Juan Loaiza gave regarding What’s new with Exadata. While a large part of the presentation focussed on what was already available, there are quite a few interesting new features that are coming down the road.

First of was a brief mention of the hardware. I’m less excited about this. The X4 has plenty of the hardware that you could want: CPU, memory and flash. You’d expect some or all (more...)

Spotify engineering culture part I & II

Spotify engineering culture part I & II

I’ve been reading quite some article on engineering culture and ways of working. The videos on Spotify Labs are among the best sources I’ve watched or read in the last year on the subjects of agile and culture. Recently the second part of their series on Spotify’s engineering culture was released.

Spotify engineering culture part I

Important take aways for me were:

  • Agile over scrum
  • Principles over practices
  • (more...)

Level Up Campaign- Packt Publishing

Take your skills to the next level 

 For the next 7 days ALL eBooks and Videos are just $10 or less -- the more you choose to learn, the more you save:
  • Any 1 or 2 eBooks/Videos -- $10 each

  • Any 3-5 eBooks/Videos -- $8 each

  • Any 6 or more eBooks/Videos -- $6 each

The discounts above are automatically applied in your cart when you add the correct number of titles. Offer ends October 2nd.
Explore more here Level Up !

Change the Apex parsing schema at runtime

One of our clients needed an application for the follow-up of the production in their plants. The main feature of the application was to show all the data of the current year, but the client also wanted to be able to consult the historical data. Unfortunately the historical data was not in the same schema as the current data.

The two schemas:

  • SCHEMA_A
  • SCHEMA_A_HISTORY

As you could already guess, the second schema contained the historical data. Each year, (more...)

Complément : Chargeback

A lire, l'article de Cap Gemini sur Enterprise Manager 12c, le Metering et le Chargeback :
http://www.capgemini.com/blog/capgemini-oracle-blog/2014/09/oracle-cloud-billing-with-metering-and-chargeback

OpenWorld Presentation on Row Pattern Matching

You can download my presentation from http://www.slideshare.net/stewashton/row-patternmatching12coow14 Please download instead of viewing: the slideshare viewer doesn’t show the animations I worked so hard on. I have already blogged about some of the topics in my presentation. Sometime soon I will continue with in depth looks at other issues, such as “catastrophic backtracking”. To those many […]

OOW14 Session: SQL Tuning Without Trying

Many thanks to all those who attended my session "SQL Tuning without Trying" at Oracle Open World 2014 #oow14. I hope you found the session useful.

If you want to download the slide deck, here it is. As always, I would really, really like to hear from you.

Oracle OpenWorld 2014 – New Data Formats and Integration

Especially on this Monday it seems all about new database data intern ration technologies and support for more data formats. Now adding in 12.1.0.2 native...

Read More

OOW14 Update: PeopleSoft’s new Delivery Model

Oracle Open World 2014 is a truly storm of information. Not only because of the myriad of sessions and the struggle needed to get from room to another with so many people around, but also due to the clouds, which seem to be everywhere. Ok, that was a really bad joke, but really clouds are omnipresent in Oracle's vocabulary nowadays.

Still, within the storm, I managed to attend some very interesting PeopleSoft sessions. I may (more...)

PeopleSoft and Shellshock

As many will have no doubt heard, there’s a new vulnerability that has been spotted, and there are already exploits for it in the wild.

The vulnerable systems are those running Bash – so Windows machines are safe, it’s just Unix/Linux and MacOSX.

Security Researcher Kasper Lindegaard from Secunia rates this as a bigger issue than the Heartbleed exploit discovered in April this year. “Heartbleed only enabled hackers to extract information, Bash enables hackers to execute (more...)

OCP 12C – Basics of Multitenant Container Database (CDB)

The multitenant architecture Needs enterprise edition and the multitenant option. Consists of a CDB (Container database) and zero, one or up to 252 PDBs (pluggable databases). Has a root container (the CDB itself) and a seed container (template to create PDBs) There is only one instance per CDB. A PDB doesn’t have : background processes [...]

The post OCP 12C – Basics of Multitenant Container Database (CDB) appeared first on Oracle DBA Scripts and (more...)

JSON is flowing through SOA’s veins

This year’s Oracle Open World is again all about Cloud and Mobile. However, this year it is getting more and more concrete. Apart from all the announcements of Process Cloud and integration cloud services there will be more JSON support in Oracle’s SOA Suite.

In Oracle SOA Suite 12C (12.1.3) the REST Adapter already made its appearance. This adapter makes it make your SCA component available as, and leverage REST services, using JSON. (more...)

OOW14 Session: Cache Fusion Demystified

Thank you all those who attended my session Cache Fusion Demystified.

As I mentioned, it was impossible to fit in a demo within that compressed 45 minute timeline. I put the details of the demo in a separate file with all the scripts and instructions that allows you to execute the demos at your own site.Download the slide deck as well as the scripts. In addition I have also written a whitepaper to explain (more...)

OPTIMIZER_MODE = FIRST_ROWS_N

I have known about the first_rows optimizer mode for some time. This tells Oracle to use an execution path which will return the first few rows as quickly as possible. However, I recently read about the first_rows_n optimizer mode, which apparently appeared first in Oracle 9. This tells Oracle to use an execution path which will return the first n rows quickly, where n can be 1, 10, 100 or 1000. I decided to try (more...)