This year I have been working mostly on Oracle Database In-Memory, so far have been impressed. As part of a project to move an analytical database to the cloud we have decided to use the In-Memory function. So far so good – it just works. Once the option is enabled a simple command loads the table into memory:
Alter table w_expense_f inmemory priority critical;
The columnar compression has worked really well for us, we have managed to get up to 85% compression on some tables. We are currently testing the performance against an exalytics system as well as TimesTen. So, watch this space
I set out on Thursday at 4am to catch a flight for Dublin at 6.30am to attend the OUG Ireland Conference as I had a session I was presenting after lunch. This conference has grown over the years and I am sure the numbers of attendees are increasing every year, That’s a credit to the organisers for the organisation UKOUG and the quality of the talks. It was great seeing everyone – speakers and delegates.
User group conferences are a great way to learn old and new technologies – you can never know everything. What I enjoy about speaking at these conferences is that I get to attend other sessions and learn something new 😃.
I missed the first few sessions as I was on a sev 1 web ex with oracle support over the conference WiFi, and was funny seeing Philippe also on a similar call. Work continues no matter where you are 😱. Once that was over I was mingling with everyone, I went to Mike’s talk on ‘Upgrading database to 12.2’ – nice to see they are making upgrades easier. 😉.
After lunch it was my talk on the DataSync tool with a live demo – it was the first time with this new talk but went Ok.
Later I went to Christian’s talk on ‘Oracle Analytics and EPM’ – it was interesting – I think he is a secret accountant 😉.
As the day came to a close, it was time for the social event. This is where we had some nibbles, drinks and jokes as well as chocolate tasting and some gin that Heli had brought with her.
Once the social was over some of the speakers were out for the customary dinner together :). We went to a nice restaurant called the Rustic Stone.
Once everyone was seated, Brendan stood up and announced he had a special announcement and it was a promotion. The Ace Program had promoted me to ‘Oracle Ace Director’.
It had been a long day but a day that I will never forget and surrounded by great friends to share this moment😃 . This new way of announcing promotions is a nice touch.
I couldn’t attend the 2nd day as I had to be at the Oracle Dublin offices – working with development on resolving some work issues that needed attention and presenting about ‘Analytics and Data in the cloud’ to some of the staff.
In the end, an awesome conference and hope to return again…
We are assuming you have already installed DataSync and you now want to copy an existing configuration you had already done on a another machine.
- Copy the entire folder path of the DataSync you want to copy and rename folder .._Old.
- Drill to new installed Datasync folder.
Double click datasync.bat.
Select the folder where the configuration exists that you want copied. Select OK
That’s it you have copied a previous configured Datasync to your new environment.