Sometimes there are these days that I need to remember why…
AMIS is spending a lot of effort keeping our people up-to-date with the latest knowledge needed to help our customers the best way we can. Traditionally we also always try to share our knowledge with customers and others, via social media or conferences, and while abroad learning from others at the same time. It is not always possible to go to those international events to learn from the best, so that’s why we invite, from time to time, those special people over here in Holland. After being able to organize special sessions with Oracle ACE Directors Doug Burns, Pete Finnegan and others, I am now honored to announce a two day masterclass with Oracle ACE Director James Morle on Thursday 6th and Friday 7th of June 2013.
Oracle ACE Director James Morle
Database administrators, architects and others, know how big the impact on performance is when the underlying architecture and storage structures are not optimal. More and more database administrators are confronted with, relying on or are responsible for technologies like Oracle Automatic Storage Management (ASM), Cluster configurations, SAN of NAS storage, Oracle dNFS, etc.
So it is of utmost importance to have a good understanding of these methods to avoid problems and get the best performance while applying those techniques. That is why we asked James Morle to give his masterclass on site, as being one of the best out there understanding and teaching about these Oracle related techniques.
Besides being one of the founding fathers of the OakTable Network and being awarded by Oracle as Oracle ACE Director, he is also a frequent blogger on his company website and author of several books, articles and whitepapers over the years regarding storage and connection management. More information can be found on James’ company website www.scaleabilities.co.uk or on the OakTable Network member info site
Understanding Storage Masterclass
If you would like to gain a better understanding about the storage tier, make sure to attend this two-day masterclass by James Morle. The seminar is focused on the component of the database platform that is probably the least understood—the storage tier.
The storage tier is often shrouded in mystery, frequently managed by other teams, and more often than not performing very badly. This seminar aims to deconstruct the storage tier and demystify the operation of the myriad components within it. Starting with the moment Oracle determines a need to go to disk until that requirement is fulfilled, we look in detail at all the processes and technology that lie in between. You will also learn some vital theory topics to help you gain a better understanding of what you can expect, and specific nuts and bolts explanations of how an I/O request is requested and serviced in many different configurations. As well as static slides, we will look at some examples of Oracle doing I/O and show some diagnostic techniques so that you can find out what is happening in your specific case.
- Understand the theory and practice of I/O.
- Understand the components that interact to comprise and I/O.
- Learn to break open the black box and troubleshoot I/O performance problems.
- Be able to make informed decisions about designing storage systems for Oracle databases.
The first day is the ‘theory day’. It is vital to understand this theory in order to make informed decisions about architecture and performance diagnostics.
- Unit 1 – Fundamentals: The Memory Hierarchy, Latency, Bandwidth
- Unit 2 – Connectivity: Fibre Channel, Ethernet, SAS, SATA, PCIe, Infiniband
- Unit 3 – The Physics of Disk Storage
- Unit 4 – The Anatomy of a Storage Array
The second day is more practical, and you are welcome to bring along your laptop (with Oracle installed) if you want to try some of the diagnostic techniques presented here.
- Unit 5 – The Server View of I/O: How does the Operating System issue and report on I/O (Linux/UNIX based)
- Unit 6 – How Oracle Performs I/O, part one: Direct I/O, Async I/O, Oracle I/O request types by process, buffered I/O, direct path I/O
- Unit 7 – How Oracle Performs I/O, part two: ASM internals, Direct NFS
- Unit 8 – The Latency Revolution: Flash storage and emerging technologies
Note: This masterclass is constantly being developed and improved and the exact content is subject to change.
If you are interested in this 2-day Masterclass and/or want to pre-order, then you can send a mail to Wieteke Gaykema. The price for this 2 day Masterclass with James Morle, to be held on the AMIS premisses in Nieuwegein, will be 1195 Euro‘s (lunch and training materials included). The course will be given in English. Available seats for this Masterclass will be limited, so be on time.
If you register before the 4th of April, the “early bird” price for this 2 day Masterclass will be 1095 €.
More follow-up information about this Masterclass and/or direct registration details will follow shortly.
See you there!
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning.
It has been a while that I have been attending Hotsos, although that is how it feels. In 2011 I flew to Hotsos to see, among others presentations from Maria Colgan, but I ended up being sick the whole week while learning on my hotel room to enjoy American TV. In 2012 I skipped Hotsos (10th year anniversary) thinking my schedule was too full with international presentations, but alas, that agenda cleared up expectantly, so in the end I missed out on some big conferences as a presenter and/or attendee.
You don’t know the Hotsos Symposium? The Hotsos Symposium is, in my honest opinion, is one of the most interesting best symposiums/conferences out there, when you goal is learning all about (Oracle) performance. This yearly happening takes place in Irving, Texas, in an Hotel on an isolated location somewhere nearby a highway some miles from Dallas downtown. When I read that Maria Colgan would do the Hotsos Training Day (an extra symposium option), without even seeing the rest of the symposium agenda, I knew I had to attend. Maria is a very natural gifted speaker and with her comfy way of addressing (difficult) problems and solutions, she nowadays easily attracts the same huge audiences like people out there, like Oracle promoter and enthusiast, Thomas Kyte. I don’t like promoting the difference between developers and DBA people (there isn’t one – believe me – or at least there shouldn’t be one), but Maria is for DBA, what Tom is for Developers (or that is how it feels sometimes).
Anyway… Looking forward to the symposium while being on the eve before my flight. This year I will be going with my colleague Remco (van Rijn). I hope that he will enjoy the symposium as much as I do: returning packed with (practical) ideas and stuff learned applicable for our AMIS customer challenges. I will be presenting once again during this years Hotsos symposium, along side some friends, people I admire and a bunch of Dutch people, that met the harsh criteria to be even “allowed” to present. Mark your (Dutch) agenda’s when we Dutch guys will be doing our “Hotsos Revisted – 2013” (free) mini conference.
Creating Structure in Unstructured Data?
For this years Hotsos symposium I set my own expectations once again a little bit higher, creating a new presentation. With all the buzz going on regarding “Big Data” and its focus on getting unstructured data under control, trying to make use of all this information, I pinpointed on making sense of Wikipedia data. The Wikipedia data is freely available as an XML data dump file on the internet. I picked the biggest data set possible, that is, the full Wikipedia English XML dump file. Last December 2012, it contained over 10 million pages of information. Every “string” (=Wikipedia page) contains structured and unstructured data elements and various from a few KB up to bigger the a few MB. All these pages are distributed in 1 big XML file.
My challenge in all of this was to get this data under control: loading it efficiently in an Oracle database, index the bits and pieces I was interested in and make it searchable for use. “Searchable for use” would focus on, the structured (fixed) bits and pieces of info, but also the completely unstructured data. The bits and pieces of info we most of the time are interested in while searching Wikipedia for knowledge. What made the challenge extra interesting was trying to do all this on my own personal computer. A computer which is limited in resources, running the actual used virtual machine environment, running a database that was limited to “only” 4G RAM of memory at its disposal. In all a daunting task trying to consume a single (XML) string (file) of 42.5 GB of data. From time to time I questioned myself, since I started building up to my new presentation in early December 2012, why I set my goals so high, but then again…that’s what Hotsos is all about.
I gathered a lot of data for my presentation, since those cold December nights, while attempting to create “Structure in Unstructured Data”, fiddling with the huge amount of Wikipedia information. An hour presentation time , in all, is too short to fit the lessons learned spend during my evening hours, the last 3 months. On Monday 12:00 AM (EST) I will know, based on the feedback of the Hotsos audience, if my attempts too handle the data will pay off and they liked the content. I will be happy if the people attended will feel it as “an hour well spend”. After that I can relax and start enjoying Hotsos and the presentations of all those other very knowledgeable people.