Introduction

Similarly to last year, as an Oracle Ace Pro, I’m very fortunate to be able to get a complimentary ticket to Oracle CloudWorld. Again, with my employer Version 1, covering travel, accommodation and time, which I am very grateful for, I was all set to attend Oracle CloudWorld 2023.

This year was slightly different in the sense, that I had a major bid before, during and after, which impacted my ability to blog in a timely manner. So apologies this blog series is a couple weeks late. Better late than never!

The Trip

Saturday the 16th September and the journey begins! Since last OCW, we’ve decided to get a kitten and it seems like he wanted to come with me, as he wouldn’t get off my suitcase 😂

All packed and ready to leave Manchester for Las Vegas OCW23 😎 The same gruelling 16 hours trip as last year.

The first leg is an 8 hour long flight to New York via Virgin Atlantic!

This time is was Fearless Lady that had the pleasure of taking me 😉 Bye bye Manchester!

Landed in New York, and similar to last year, I had to go through immigration, baggage collection/drop off and get to gate for connection flight all within 1.5 hours! 😬

Last year was close call, making it to the gate just in time, but this year was bad! The immigration queue was an hour apparently. I advised I needed to be at my gate in an hour, they kept just saying “let’s hope you make it” 🤦🏽‍♂️

It got to about 15 minutes to boarding, and only then they put me to the front of the queue! There were other people in similar situation, that had been waiting for some time. One person had totally missed his flight due to the long queues. I was fortunate, I had made it through immigration, picked and dropped my bag off and headed to gate, but the final hurdle was the security check which was another long queue! At this point I only had 5 minutes left, and the lady manning the queue said just go to the front and tell people you need to board. So that’s what I did and another lady followed me. We both made it through security, at which point I realised she was also on my same flight and also going to OCW23! 😲 We both had to “leg it” to the gate which took us about 15 minutes! We were worried we may miss the flight but they were still boarding when we arrived at gate, phew!

So now the next leg is 6 hours to Las Vegas, I was lucky my fare was economy+, so I had nice comfortable seat, some snacks and most important free WiFi!

Finally made it, 16 hours later in Las Vegas. It was 2pm when I left the UK and arrived in Las Vegas 9pm local time but back home was 5am! Surprisingly wasn’t feeling the jet lag like I did last year.

My place for the week is Sahara, which is the place I stayed last year. It’s reasonably priced, decent hotel and is at the end of the Monorail (Southbound), so easy to get to the conference in the middle of the strip.

One final thing before going to bed, was to have dinner. So I went to Mcdonald’s which is just across the road from hotel. I didn’t realise when I asked for a large Filet-O-Fish meal, I’d get a double filet, fries that are double the size of UK and a 1 litre drink! 🤯

Tomorrow due to my bid work, will be working in the day and then attending the Oracle EMEA Partner Reception Event in the evening.

You can view my day 1 here.

If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this oracle blog via WordPress/e-mail.

Thanks

Zed DBA (Zahid Anwar)

If you missed my day 6, you can view it here.

My Oracle CloudWorld trip is now well and truly over, and all that was left, was to return back home to the UK. I had a 3 leg journey home, Las Vegas to Los Angeles, Los Angeles to Paris and finally Paris to Manchester. Despite the 3 legs, it was the shortest route back that day.

Return Journey

My flight wasn’t till 3pm, so I spent few couple of hours packing, watching Manchester United on TV and having breakfast.

On the way to the Harry Reid International Airport, I could still see the strip as the airport is only 3 miles away from the strip.

Check in was relatively simple, so I spend a couple of hours browsing the shops to try find gifts for the family. No joy, so decided to have lunch before boarding the plane. When I asked for a large meal I didn’t realise the drink is a whooping 1 litre! (excuse the punt)

Once boarded the plane, the pilot mentioned it was a really choppy flight in from Los Angeles and expected it to be the same if not worse going back. So we was instructed to not leave our seats and keep belts on whole journey. It had been pretty sunny and hot for the whole week but that morning it was cloudy and pretty windy. A concert that people all over US had travelled to see got cancelled, quite a lot of guest were in my hotel for the concert and were not happy. I was gutted for them but I didn’t think anymore, clearly it was getting worse as I looked out the window and I couldn’t see the strip anymore as visibility reduced.

Still looking gloomy and we’re stuck on the tarmac as air traffic control staggers the flights in and out.

Then my iPhone and Apple Watch went berserk to get my attention. It was an Emergency Alert, I didn’t event know these existed! Was quite a scary message with emotive words of “Stay Alive!”.

Clearly a dust storm was approaching. We was delayed by an hour and I was getting worried as I was scheduled to land in Los Angeles at the point but was still in Las Vegas! I only had 1.5 hours to get my flight to Paris! We eventually took off at that point as we flew out the dust storm, but it was a pretty hairy take off with the plane immediately banking 20-30% and then the pilot correcting with it banking the other way. Pilot ascended pretty rapidly with a lot of stomach churching drops as the turbulence was the worse I’ve ever experienced.

We arrived at Los Angeles and I had only 30 minutes to get my next flight. I truly believed I wouldn’t make it, but I had to give it a go and pretty much legged it all the way to the gate! What a huge airport as I arrived at the gate 5 minutes before takeoff. At this point I was adamant I had missed the flight, but to my surprise they were still boarding. So I managed to make the flight, albeit a bit bothered and sweaty 🥵

It was a long 11 hours flight, but it wasn’t too bad as I manged to have dinner, then get about 4-6 hours of broken sleep before having breakfast. Arrived in good time at Paris, did some more browsing and managed to get the family some gifts this time. Then it was on to the final leg to Manchester!

I had clearly made it onto the flight to Paris within the 30 minutes I had but my luggage clearly didn’t as it was still showing in Los Angeles via Apple AirTag.

The final flight from Paris to Manchester was pleasant and quick. And I was finally back to home town of Manchester 😎 I filled in the form for delayed baggage and left the airport to go home. Was really looking forward to seeing the family.

It been a brilliant trip, many thanks to Oracle Ace Program for the CloudWorld ticket and to my employer Version 1 for covering travel, accomodation and time out the office.

Till CloudWorld 23, take care and I hope you enjoyed reading this blog post series and apologies for the delay in writing it all up 🙄

If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this Oracle blog via WordPress/e-mail.

Thanks

Zed DBA (Zahid Anwar)

If you missed my day 5, you can view it here.

The Oracle CloudWorld conference had finished, but before I went home I had one last thing to do! Attend the Oracle Ace Adventure, whereby Oracle Aces courtesy of the Oracle Ace Program get taken to Grand Canyon 😎

Grand Canyon

So it was an early start with a 6:25am coach!

This was out tour guide/comedy Anthony

All eagerly listening to the facts that Antony was telling us

This was the first glimpse of the Colorado river 😎

First glimpse of the Grand Canyon! 👍🏽

Sai, Philippe, and Suraj, looking fresh!

The eagle in the Grand Canyon at eagle point. Can you see it? 🤷🏽‍♂️

And here’s all the Oracle Aces/Oracle employees that went on the Ace Adventure! 😎

Osama, Basheer, and Sai.

With Osama at the highest point in Grand Canyon at Guano Point!

Appreciating the beautiful view of Grand Canyon!

On the way back, we got to see Hoover Dam!

The white area is where the water used to be against the Grand Canyon wall. There is a water shortage in Las Vegas as they consume more water then is received and hence the waterline has been failing over the years! Anthony said the statue of liberty could fit in the height of the water area, showing how much water has actually drop down!

Final photo of the Oracle Ace Adventure as we headed back to Las Vegas strip.

Many thanks for Jennifer and the Oracle Ace Program for a wonderful day with wonderful company! 😎

Tomorrow will be my longggg journey back home to UK.

You can view my day 7 here.

If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this Oracle blog via WordPress/e-mail.

Thanks

Zed DBA (Zahid Anwar)

If you missed my day 4, you can view it here.

The main bulk of the conference was over, with all the keynotes presented. Today was more Oracle, partners, customers and end users sessions to wrap up the conference.

20x Faster Analytics, 25x Faster Machine Learning with MySQL HeatWave on AWS

I’m not so familiar MySQL and I hadn’t heard of HeatWave this CloudWorld, so I thought I’d try something different and went to this session. Mandy Pang, Senior Principal Product Manager at Oracle explained how MySQL HeatWave is one database for OLTP, OLAP and Machine Learning.

She went on to explain the continuous innovation in MySQL HeatWave.

It was here where I came to fully understand that MySQL HeatWave is the traditional MySQL database for the backend but has a in-memory layer on top called “HeatWave” which effectively accelerates OLAP and Machine Learning.

It’s very similar to the Oracle Autonomous Database as in many common tasks are automated and it has extreme performance.

Next Nitin Kunal, Director, Software Development at Oracle explains how MySQL HeatWave is faster then RedShift, Snowflake, Big Query and Synapse.

It’s also better price performance than Redshift, Snowflake, Big Query and Synapse.

He also went onto explain:

Innovative in-memory hybrid columnar engine

Massive Parallel Architecture using high-fanout partitioning

Multi engine query optimisation

Zone map

Lazy decompression

Auto Query Plan Improvement

Auto Scheduling, reducing wait time for mixed (OLTP & OLAP) workloads

Auto Data Placement, ML prediction of optimal in-memory partitioning column

After the session I had a wonder in the DevNucleus area and saw the RedBull racing simulators and the world’s largest Raspberry Pi cluster!

Using Machine Learning Models to Assist Programming of Cochlear Implants

My next session was one that was an interesting topic as my parents are both profoundly deaf, so I was intrigued to how Machine Learning Models could assist programming of cochlear implants.

It was early days but Max Storr, Data Analytics Engineer from DSP-Explorer explained how a cochlear implant has 22 channels and that they need to be fine tuned which a highly skilled clinical staff would do over several appointments. With the Machine Learning, they were able to predict the settings reducing the overall tuning period. As still early days, there was more proving and convincing the National Institute for Health Research for the Machine Learning to be incorporated into the process and helping patients.

Oracle Database Service for Microsoft Azure Best Practices

Next session was one I was interested in, as would give me better insight into the more recently new services of Oracle Database Services in Azure.

Suzanne Holliday, Senior Principal Product Manager, Oracle Cloud Database Services and Tammy Bednar, Senior Director of Product Manager, Oracle Cloud Database Services presented this one.

The services effectively allows Azure customers to provision an Oracle Database in OCI directly from Azure. It allows direct access to the database over private Azure-OCI interconnect, unlocking all the benefits of Oracle database Services to Azure customers.

All the networking is provisioned automatically, and the Azure ExpressRoute and OCI FastConnect data and port charges are all included.

Some pre-provisioning best practices in both Azure and OCI.

In summary, a lot of automation simplify the user experience, single sing-on using Azure AD credentials, manage from Azure portal with integrated monitoring and finally get collaborative support from Microsoft and Oracle for any issues.

AutoUpgrade 2.0: Internals and New Features

Next session was about AutoUpgrade tool, talking about new features.

Rodrigo Jorge explains the first of many new features, the ability to apply Release Updates via AutoUpgrade.

Next Daniel Overby Hansen, explained how AutoUpgrade can now handle encryption but a keystore needs to be configured.

Next Rodrigo explains when you have multiple PDBs and RAC cluster with low number of CPUs per node, then distributed upgrades of the PDBs can be done over 2 nodes to parallel run PDB upgrades to reduces the overall time by utilising 2nd node CPUs.

Finally went over some new console commands.

Automatic Index Management in Oracle Database

The penultimate session, about Automatic Index Management, which is an exclusive Exadata feature.

Explaining how managing indexes has become a specialist skillset and how we rely on experts to manage.

What Automatic Indexing does, is being that “expert” 24 by 7 at no extra cost.

It works in the background without inputs or action but does allow for preferences and give ability to check activity through reports.

Similar to how manual indexing is done, identify potential new indexes, verify they give better execution plans, decide to implement, validate whilst invisible, then if validated then make visible and monitor for usages. If not used for 3 months, drop index.

Encryption is Easy – Make Key Management Easy Too with Oracle Key Vault

The final session of Oracle CloudWorld is about Oracle Key Vault.

Oracle Transparent Encryption (TDE) has been around since 2005 and has been getting easier over time.

TDE innovations over time, online encryption, column encryption, split TDE in Data Guard, etc.

Encryption introduces key management needs of key governance and compliance, secure key sharing and archiving such as in RAC, key management at scale!

Oracle Key Vault resolve all this with a High Availability and Diester Recovery architecture, so it doesn’t become a single point of failure. No keys no data!

This now concluded Oracle CloudWorld, and it was starting to get empty at The Venetian.

Time to take one last photo!

Also getting empty at the Caesars Forum!

The date for next year, 18th to 21st of September 2023. Hopefully I’m back!

As I go to the monorail to take me back to my hotel, I pass through Hall A-D as they already start to get cleared up!

The conference may have ended but tomorrow is the Oracle Ace Adventure and we’re off to Grand Canyon 😎😁👍🏽

You can view my day 6 here.

If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this Oracle blog via WordPress/e-mail.

Thanks

Zed DBA (Zahid Anwar)