OTN Appreciation Day : Summary

Yesterday was the OTN Appreciation Day. The plan was to mobilise the Oracle community to say #ThanksOTN for everything Oracle Technology Network (OTN) have done for the Oracle community over the years. You can obviously search on Twitter for #ThanksOTN, but I’ve compiled a list of blog posts here, so contact me if you’re missing! They are ordered chronologically, or at least in the order I found them. There are some posts with similar, or the same, name. Multiple people can have the same favourite feature. 🙂

  1. OTN Appreciation Day : Undo and Redo
  2. OTN Appreciation Day : 2016
  3. OTN Appreciation Day : The ORAchk and EXAchk Tools
  4. OTN Appreciation Day : Constraints
  5. OTN Appreciation Day : APEX Dynamic Actions
  6. OTN Appreciation Day : Functions returning record structures
  7. OTN Appreciation Day : Analytic Functions
  8. OTN Appreciation Day : LISTAGG
  9. OTN Appreciation Day : Function Result Cache
  10. OTN Appreciation Day : GeoJSON and SDO_GEOMETRY marriage in Oracle 12.2
  11. OTN Appreciation Day : 12C PRIVILEGE ANALYSIS
  12. OTN Appreciation Day : Oracle RMAN
  13. OTN Appreciation Day : Transportable tablespaces
  14. OTN Appreciation Day : A database that is reliable
  15. OTN Appreciation Day : Dataguard
  16. OTN Appreciation Day : ONLINE
  17. OTN Appreciation Day : In-Memory Column Store
  18. OTN Appreciation Day : Oracle Express Edition (XE)
  19. OTN Appreciation Day : Data Pump (expdp, impdp)
  20. OTN Appreciation Day : SQL Patch
  21. OTN Appreciation Day : PL/SQL
  22. OTN Appreciation Day : Error Hospital / Resiliency in SOA 12c
  23. OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  24. OTN Appreciation Day : Instrumentation
  25. OTN Appreciation Day : That wonderful no-cost option – APEX
  26. OTN Appreciation Day : Oracle Public Cloud Database – Schema as a Service
  27. OTN Appreciation Day : Super Cluster
  28. OTN Appreciation Day : MySQL 8.0 data dictionary
  29. OTN Appreciation Day : Flashback
  30. OTN Appreciation Day : APEX Metadata Repository
  31. OTN Appreciation Day : Flashback
  32. OTN Appreciation Day : Programatically Dismissing Popup
  33. OTN Appreciation Day : Dual Table
  34. OTN Appreciation Day : The Power of Combining Bitmap Indexes
  35. OTN Appreciation Day : WebLogic
  36. OTN Appreciation Day : My favourite thing from OTN
  37. OTN Appreciation Day : Partition your table online !
  38. OTN Appreciation Day : OBIEE’s Export to Excel Functionality
  39. OTN Appreciation Day : ASM
  40. OTN Appreciation Day : BREAKING BARRIERS…IN MEMORY
  41. OTN Appreciation Day : Developer Cloud Service
  42. OTN Appreciation Day : Oracle Multitenant
  43. OTN Appreciation Day : Prebuilt Developer VMs
  44. OTN Appreciation Day : The Recyclebin
  45. OTN Appreciation Day : OMCS Push Listeners
  46. OTN Appreciation Day : FlashBack Query
  47. OTN Appreciation Day : Restore and Recovery of database table in Oracle 12c
  48. OTN Appreciation Day : Experiences
  49. OTN Appreciation Day : The Oracle Universal Installer
  50. OTN Appreciation Day : How To Setup an Oracle DBaaS from Scratch
  51. OTN Appreciation Day : DBMS_ROLLING -12c
  52. OTN Appreciation Day : The Community
  53. OTN Appreciation Day : Oracle Text
  54. OTN Appreciation Day : ADVM
  55. OTN Appreciation Day : Oracle Wait Interface
  56. OTN Appreciation Day : Pre-Built Developer VMs
  57. OTN Appreciation Day : Automatic Storage Management (ASM)
  58. OTN Appreciation Day : Visual Analyzer
  59. OTN Appreciation Day : Oracle read/write consistency
  60. OTN Appreciation Day : DBMS_APPLICATION_INFO for Instrumentation
  61. OTN Appreciation Day : OBIEE’s BI Server
  62. OTN Appreciation Day : Oracle WebLogic 12c
  63. OTN Appreciation Day : SQL Profiles
  64. OTN Appreciation Day : Oracle Private/Hybrid Database Cloud
  65. OTN Appreciation Day : Oracle Text
  66. OTN Appreciation Day : SQLcl
  67. OTN Appreciation Day : Create Database Using SQL
  68. OTN Appreciation Day : Instrument Your Damned Code. Please!
  69. OTN Appreciation Day : Getting started with ODI
  70. OTN Appreciation Day : “Show Data As” in OBIEE pivot views
  71. OTN Appreciation Day : Oracle BI data sources
  72. OTN Appreciation Day : Oracle Database 12c (12.1.0.2.0) Multi-tenant New Features with Real Application Clusters (RAC)
  73. OTN Appreciation Day : Greetings from Copenhagen!
  74. OTN Appreciation Day : EPRCS EMBEDDED CONTENT FEATURE
  75. OTN Appreciation Day : Oracle Data Guard and DG Broker
  76. OTN Appreciation Day : tnsping
  77. OTN Appreciation Day : Looking for Change
  78. OTN Appreciation Day : Oracle JET Cookbook
  79. OTN Appreciation Day : Oracle Live SQL ¿Cómo no te voy a querer?
  80. OTN Appreciation Day : Multitenant
  81. OTN Appreciation Day : Oracle Data Integrator 12c – Flexibility
  82. OTN Appreciation Day : Thanks OTN
  83. OTN Appreciation Day : dbnodeupdate.sh
  84. OTN Appreciation Day : Oracle Data Guard Fast-Start Failover
  85. OTN Appreciation Day : 2016
  86. OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)
  87. OTN Appreciation Day : Alta UI
  88. OTN Appreciation Day : The Performance Schema of MySQL 5.6+
  89. OTN Appreciation Day : RAC
  90. OTN Appreciation Day : The Java VM in the Oracle Database
  91. OTN Appreciation Day : Regular Expressions (REG_EXP)
  92. OTN Appreciation Day : The Log Analysis Tool
  93. OTN Appreciation Day : Oracle Data Integrator 12c Flexibility
  94. OTN Appreciation Day : SQL Trace
  95. OTN Appreciation Day : PRAGMA UDF
  96. OTN Appreciation Day : ThanksOTN
  97. OTN Appreciation Day : Edition-Based Redefinition
  98. OTN Appreciation Day : Single And Multitenant Architecture
  99. OTN Appreciation Day : 2016
  100. OTN Appreciation Day : PUBLIC-YUM
  101. OTN Appreciation Day : #ThanksOTN Twitter feed with Oracle MCS and Oracle JET
  102. OTN Appreciation Day : Adding Invisible Column
  103. OTN Appreciation Day : Easy Execution Plans
  104. OTN Appreciation Day : Visualizing System Statistics in SQL Developer
  105. OTN Appreciation Day : Partitioning
  106. OTN Appreciation Day : Oracle Database Cloud Service
  107. OTN Appreciation Day : Top Activity Screen in EM
  108. OTN Appreciation Day : A Journey From Newbie to Veteran
  109. OTN Appreciation Day : Tom Kyte
  110. OTN Appreciation Day : A distributed system is the one that prevents you from working because of the failure of a machine that you had never heard of
  111. OTN Appreciation Day : WLST
  112. OTN Appreciation Day : ADF BC como tu BackEnd
  113. OTN Appreciation Day : Integration Cloud Service (ICS) On-Premises Connectivity Agent
  114. OTN Appreciation Day : DBMS_MONITOR
  115. OTN Appreciation Day : APEX
  116. OTN Appreciation Day : I Appreciate You
  117. OTN Appreciation Day : Recovery Appliance – Database Recovery on Steroids
  118. OTN Appreciation Day : OTN Community
  119. OTN Appreciation Day : OWSM y WS-Security. Autenticación por Username Token para SOAP y REST en OSB 12c
  120. OTN Appreciation Day : The Power of Oracle SQL
  121. OTN Appreciation Day : Oracle Business Rules
  122. OTN Appreciation Day : Developers, DBAs, Architects and Product Experts
  123. OTN Appreciation Day : Establish DevOps with Oracle Developer Cloud Service
  124. OTN Appreciation Day : Oracle Flashback
  125. OTN Appreciation Day : Oracle ADF Bindings

OTN Appreciation Day +1. 🙂

  1. OTN Appreciation Day : THE DAY AFTER – BPEL, SOASUITE AND SCA (IN THAT ORDER…)
  2. OTN Appreciation Day : Find performance issue for user session
  3. OTN Appreciation Day : Laura Ramsey Edition

Check out pieter v. puymbroeck, who wrote a script (here) to scrape the results from Twitter. Ruben Rodriguez did a similar thing using MCS and JET. I did it the long and painful way because I’m an old-timer. 🙂

Thanks to everyone that wrote a blog post. It was good to see some new, nearly new and returning faces, as well as the usual suspects. I was glad to see some of our Latin American community blogging in Spanish. What’s really cool is the diversity of stuff people posted. Some people took it in a completely different direction, which made it more interesting. Thanks to all those people that tweeted messages of support and retweeted content throughout the day. We got people joining in because they saw the buzz you helped create! And of course, #ThanksOTN. 🙂

Cheers

Tim…

Update: Some latecomers added. 🙂

OTN Tour of Latin America 2016 : Panama to Costa Rica

I had a broken nights sleep. My luggage turned up at midnight. At about 03:00 I did a blog post. Then at 05:00 I officially woke up to get ready for the taxi at 06:00. 🙂

There were no dramas at the airport. Debra and I got through bag drop and security with plenty of time, so we got some breakfast and chilled until the flight.

The boarding was a little chaotic, mostly because people heard one piece of hand luggage and one personal item, and understood that to mean four pieces of hand luggage and a donkey. Needless to say, the overhead lockers were short on space. 🙂

It was a 55 minute flight, with a rollercoaster landing. I actually got my luggage back this time as well, which was nice. 🙂 Another quick taxi ride and we were at the hotel.

I did a couple of hours of work, then headed off to the gym, which was great. The hotel gym is a small Golds Gym, so I was able to do proper weights. It was super hot, which made training really hard, but when I finished I did some stretching and it was awesome. I can’t remember the last time I’ve stretched in that temperature. I was super flexible.

I think I’m going to head off to the pool for a bit, then chill for the rest of the day.

The Costa Rica conferences starts tomorrow. See you there!

Cheers

Tim…

OTN Tour of Latin America 2016 : Panama

laotn16Panama and ORAUG PTY was the first leg in the OTN Tour of Latin America 2016 (Northern Leg). The event took place at the Wyndham Panama Allbrook Mall Hotel.

The day started with a general introduction by Edgardo Sanchez Diaz, then an introduction to OTN and the Oracle ACE Program by Pablo Ciccarello.

From there I presented three sessions back-to-back.

  • Improving the Performance of PL/SQL Function Calls from SQL
  • Pluggable Databases – What they will break and why you should use them anyway!
  • It’s raining data! Oracle databases in the cloud.

I think the sessions went well. People were a little shy at the start, but as the sessions progressed people got more confident about asking questions.

After lunch was Kamran Agayev speaking about “Oracle 11g Clusterware failure scenarios with practical demonstrations”. Kamran discussed lots of failure situations with video demos of them, which were pretty neat. He also discussed numerous test scenarios people should work through before they go live with a RAC system.

Next up was Debra Lilley presenting on “Pass4SaaS”. I’ve seen this presentation many times over the last couple of years, but it has evolved somewhat. This one had a live demonstration of Debra using the Application Builder Cloud Service, almost like she’s a developer! 🙂

Next up was Kamran again with “Oracle 12c ASM new features with practical demonstrations”. This was a quick run through the ASM new features, including a video demo of Flex ASM and ASM Disk Scrubbing.

That was the day done for me. There were other presenters speaking in Spanish, but after my three sessions and three others I was done for. 🙂

I was presenting for half of the day, so I didn’t get much time to film, which is why this video was so short.

Thanks to Edgardo and ORAUG PTY for inviting me to the event. I had a really good time and it cheered me up a lot after yesterday’s travel disaster. It reminded me why the travelling is worthwhile. 🙂

Cheers

Tim…

PS. All through the day I kept getting the hotel reception to ring the two numbers I was given for the KLM missing luggage service, but never got an answer. The online bag tracker they provide was useless. It just acknowledged your bag was marked as missing, with no idea of the location or ETA. Since I was planning to leave early the next day I was worried my luggage would arrive after I left, but had nobody to speak to about this. At about midnight there was a knock at my door and my luggage had arrived. Obviously I’m very happy about that, but the lack of communication was a nightmare! Judging by the tweets to KLM, I got lucky!

OTN Tour of Latin America 2016 : Birmingham to Panama

Where do I start with this day?

I arrived at Birmingham Airport about 2 hours and 20 minutes early. I was then presented with a huge queue to get to the queue for the bag drop. To be fair to the people at the desk, they seemed relatively efficient, but there were 2 floating staff who were chatting to each other and laughing, rather than handling the queue. There needed to be:

  • A specific “bag drop only” queue, which most people would have breezed through.
  • A “special cases” queue for those families that turn up with 45 cases and wonder why they can’t take them.
  • A “check in” queue, where people who have not already checked in can go.

Something simple like that would have meant the queue moved much quicker and the floating staff could have organised that easily if they could be bothered and weren’t morons. Of course, that couldn’t happen because we are talking about the Air France / KLM gate, so you know it’s going to be terrible. I sent a few tweets to both KLM and BHX that contained lots of expletives. Sorry if that offended anyone, but tough!

Eventually I got through the “queue to the queue” for bag drop, then I joined the “queue for the queue” for security. Yes, there was a queue to get to the place you normally queue! Once again, an obvious case for sorting your staff out. They know when they will be busy in advance, so they should staff accordingly.

I finally got to the boarding gate and could see the plane, but they were unloading for ages. Turns out there were a team of Para-Olympic athletes on the plane and the ground staff did not anticipate how long it would take to get them and their wheelchairs off. Once again, bad planning. We took off 40 minutes late, which was a worry since I had a very short connection at Amsterdam for the next flight. Just before we landed they announced some people had missed their connections, but mine was still possible if I legged it. Fortunately for me, the next flight was delayed also, so I made it!

I sat on the flight from Amsterdam to Panama, sighed with relief, then got a massive headache. I thought I was going to have one of my puking episodes, but I managed to down some paracetamol and sleep for a bout 10 minutes, which was enough to take the edge off.

I arrived in Panama, but my luggage didn’t. After a queue to deal with my lost luggage, I queued for about 40 minutes to get through the bag check, without my bags.

After a death-race taxi ride to the hotel and the travel was over. At that point, if I had the option to got straight home I would have done. The flights themselves were fine, as were the flight staff. It was the chaos on the ground that was the problem, which left me feeling like I never want to fly again. It was a terrible day!

I met up with Debra so she could watch me eat cheese and talk me down. Then it was bed and the hope that I would never remember this day!

Tomorrow is ORAUG PTY, the first event of the OTN Tour of Latin America 2016 (Northern Leg).

Cheers

Tim…

PS. The video is dedicated to Mark Rittman, who loves my travel videos, describing them as “boring” and saying, “nothing happens in them”, which is of course the whole point of doing them. 🙂