A little known MOS note describes how you can potentially reduce downtime by a significant amount when migrating databases between systems with different endianness. Many sites are looking for ways to move their databases from big-endian platforms such as HP-UX, AIX or Solaris/SPARC to an Exadata system running Linux. In this webinar, Martin Bach will explain how implementing a cross-platform incremental backup in conjunction with cross-platform transportable tablespaces makes this possible.
Here is a compilation from E4 2012 featuring all presenters and abstract titles.
E4 2013 is already shaping up to be a great educational experience as well. Here is a short list of Exadata experts who have already committed to present:
Tom Kyte: Keynote
Call for Papers is currently OPEN – click HERE to submit an abstract.
Deadline: April 30, 2013
Exadata Snapper (also called ExaSnapper or ExaSnap) is a new tool by Tanel Poder, which allows to “peek” into some SQL Execution-related cell metrics without leaving the Oracle database session / sqlplus prompt. The current version 0.7 is a beta version and will likely be much improved and changed once it reaches v1.0.
The tool itself will be downloadable from enkitec.com (will update this post once it’s there).
Here are the videos, split into 3 parts:
- Part 1 – Introduction
- Part 2 - Smart Scan and IO activity in the cell
- Part 3 - Advanced Metrics and Q&A
Part 1 – Introduction
Part 2 - Smart Scan and IO activity in the cell
Part 3 – Advanced Metrics and Q&A
NB! The video is currently unavailable due to the service provider, blip.tv. I am going to upload the video to Vimeo instead and will mention this in my blog once done.
Here’s another hacking session video from last year:
- How do full table scans work?
- How and why do the “ORA-8103: object no longer exists” errors happen
- How does Oracle (11g) decide between a buffered full table scan and a direct path read scan (plus smart scan in Exadata)
- What’s the difference between an object_id and data_object_id?