DDL logging

I was presenting at the UKOUG event in Manchester on Thursday last week (21st April 2016), and one of the sessions I attended was Carl Dudley’s presentation of some New Features in 12c. The one that caught my eye in particular was “DDL Logging” because it’s a feature that has come up fairly frequently in the past on OTN and other Oracle forums.

So today I decided to write a brief note about DDL Logging (more...)

Workarounds

It’s been forever since I last shared any of my performance troubleshooting experiences at work. This week, I got a case that I think is worth publishing, and I decided to write about it in my blog. So, here we go…

A few days ago, I received a complaint about unstable performance of one of frequently running SQL reports on a 11gR2 database. Most of the time it completed within a couple of minutes, however, on (more...)

Data Integration Tips: Oracle Data Integrator 12c Passwords

Hey everyone, it’s Sunday night and we have just enough time for another Data Integration Tip from Rittman Mead. This one has originated from many years of Oracle Data Integrator experience – and several lost passwords. Let me start first by stating there is never any blame placed when a password is lost, forgotten, or just never stored away in a safe place. It happens more often than you might wish to think! Unfortunately, there is (more...)

How to configure eDB360?

eDB360 has two execution parameters. The first one specifies if the database is licensed to use the Tuning or Diagnostics packs (or none). The second parameter is optional, and if entered it specifies the name of a custom configuration file that allows to change the behavior of eDB360. With this optional configuration file you can make changes such as: reduce the scope of the output to maybe a single column, a section, or even a range (more...)

VR Research at OBUG

obug

As part of our push to do more international research, I hopped over to Europe to show some customers VR and gather their impressions and thoughts on use cases. This time it was at OBUG, the Oracle Benelux User Group, which was held in Arnhem, a refreshing city along the Rhine.

Given that VR is one of the big technologies of 2016, and is posed to play a major role in the future of (more...)

OTN Yathra Chennai

Rather than try to convey in words the first couple of days in India, I thought I’d share some of the images from the first days here in India, covering the Chennai conference. Enjoy

 


I Love My Job But Time to Move


When I joined Certus Solutions in Sept 2014, I loved that it was a small organisation where the owners Mark Sweeny and Tim Warner were betting everything on Fusion Apps. They believed in the Cloud and that there was a gap in the market for a niche partner.

They started weigh a few other industry experts and the first few years as told in Mark's own blog was a hard struggle, but by the time (more...)

Collaborate 2016


Finally getting around to making my comments about Collaborate 2016 and I've started by reading my summary of 2015.

This year a lot of things had moved on, there was more clarity around Oracle's strategy in Apps and in General, if you weren't there don't worry it is easy to understand the main message; It is Cloud.

C16LV – Having Fun in Vegas


As I mentioned in one of the other postings I don't actually like Vegas, however once I arrive and meet up with my friends it is fun.

This year as ever I managed to catch up with most, but the community I miss is EBS, as I move further and further away from here I see less of the team. I do see Nadia Bendjedou at a lot of events around the world, but very (more...)

C16LV – Oracle ACE Community


This was the first big event since Vikki Lira left the OTN team so it was a little sad, although we haven't lost Vikki she has gone to the User Experience Team and I do so much with that team I expect to do even more with Vikki.

I actually flew to Vegas via San Francisco (don't ask) and Jennifer who looks after us ACEs was on the same flight, so I felt (more...)

C16LV – User Group Focus


As at last year's event, user groups from around the world took the opportunity to get together and talk with Oracle. Jeb DaSteel and he gave us an update on initiatives started last year and shared with us a few ideas Global Customer Programs have for the coming year.

One of those initiatives will have a bearing on my own role in the day job, so whilst I can't share the details yet (more...)

C16LV – The Mobile App


Conferences need mobile apps, but I am yet to see the perfect one, and that includes UKOUG. In a tech world you think we could just write one but and if there is someone out there with nothing to do and doesn't need to earn any money, let me know.

Anyway there was a Collaborate16 App and it was one of the best I have seen.

Multiple Session Selection

It did allow you to select (more...)

C16LV – Celebration of Motivational, Strong Women


As is traditional at every IT conference now, Women in IT was featured at Collaborate.

At the WIT lunch session Heli Helsakyo gave an impassioned story of success in a country that the very next day was shown to be in the top countries for women on IT (all 4 at the top are scandinavian). It was very inspiring. So many people came up to her afterwards and throughout the rest of the event, saying thank (more...)

C16LV – Best Collaborate Ever


Collaborate is a conference held by 3 user groups however apart from the party and plenary keynotes the sessions and activities are separate. 

You are welcome to attend most of the sessions but some and events are limited to who you registered through. As a user group leader I wish there was a ribbon or badge that allowed me to move between them. 

Anyway Boris Brott was the motivational or re-energise speaker on the Wednesday a plenary (more...)

C16LV – Cloud Especially Apps


You will not be surprised to hear that this year Cloud was the main theme and it is certainly the Oracle mantra. When did exadata, engineered systems stop being the answer to everything?

This year Cloud Apps, my area, have I think reached maturity and I am really pleased to say I heard less presentations that added to any confusion, and in the main the name Fusion was unused. 

In the past few years (more...)

Video : Flashback Version Query

Today’s video gives a quick run through of flashback version query.

If you prefer to read articles, rather than watch videos, you might be interested in these.

The star of today’s video is Tanel Poder. I was filming some other people, (more...)

Oracle X5-2, from bare metal to VM Server. Without disks, without dvd drive.

Oracle offers a fine machine called the X5-2. Not to be confused with the ODA X5-2, which comes with sophisticated database software. The X5-2 is just bare metal.

The X5-2 is a 1HE 2 socket Intel machine with limited configuration options in terms of processor speed, number of cores and storage.

I will show you how to install Oracle VM Server software without even having a dvd drive for the installation disk, nor a hard (more...)

Fishbowl Hackathon 2016 Summary – Oracle WebCenter Innovations with Slack, Google Vision, and Email

This post comes from Fishbowl’s president, Tim Gruidl. One of Tim’s biggest passions is technology innovation, and not only does he encourage others to innovate, he participates and helps drive this where he can. Tim likes to say “we innovate to help customers dominate”. Tim summarizes Fishbowl’s Hackathon event, held last Friday and Saturday at Fishbowl Solutions, in the post below.

TimWhat an event! I want to start by thanking Andy Weaver and John Sim (Oracle (more...)

Extended Statistics und CHAR Spalten

Vor Problemen bei der Verwendung von Extended Statistics - also Statistiken für mehrere (in der Regel korrelierte) Spalten, die intern über eine virtuelle Spalte abgebildet werden - warnt Jonathan Lewis in seinem jüngsten Sratchpad-Artikel. Der Hintergrund des Problems ist folgender: für eine einzelne CHAR-Spalte (in diesem Fall CHAR(2)) mit Histogram ist der Optimizer klug genug zu erkennen, das Blanks, die am Ende eines zum Vergleich herangezogenen Literals angehängt werden, keinen Einfluß auf die Selektivität des (more...)

Delphix Replication

Someone just asked on the Delphix Forums whether they could test Delphix replication with the free version of Delphix called Delphix Express.

I’d never tried, so I sat down to try and was amazed at how easy it was.

I created twoDelphix Express installations.

On one engine, the source engine, (http://172.16.103.16/)  I linked to an Oracle 11.1.0.7 database on Solaris Sparc called “yesky”.

On that same engine I (more...)