Top 60 Oracle Blogs

Recent comments

Upcoming Events

OUG Scotland Conference 2012

Event date: 
Wed, 2012-06-13

Six topic areas, 30 sessions, several Oak Table speakers, and a keynote from Tom Kyte.

Understanding Storage Masterclass with James Morle

Understanding Storage Event April 24/25 2012
Event date: 
Tue, 2012-04-24 - Wed, 2012-04-25

Scale Abilities have announced the first UK dates for James Morle's Understanding Storage Masterclass.
If you have ever been confused about how your storage interacts with Oracle, or frustrated at always losing 'discussions' with your storage team, this seminar is for you!  
If you would like to gain a better understanding about the storage tier and be able to communicate well with your storage administration colleagues when there are problems, 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 con- figurations. 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.

Day One: 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

Day Two: 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.
Forthcoming Schedule

  • April 24/25 2012 – Prospero House, London. BOOK HERE (UKOUG Members are eligible for £100 discount)


Oracle XML Training With Marco Gralike

Oracle XML Training With Marco Gralike
Event date: 
Tue, 2012-03-27 - Wed, 2012-03-28

With great pleasure we announce a very interesting 2-day seminar with Marco Gralike about XML titled "Oracle XML Database Training". The course will deal in depth with performance problems, design, set-up, architecture and troubleshooting.
Marco Gralike, member of OakTable and Oracle ACE Director si know as the top expert for XML in Oracle database.
The seminar will take place on March 27-28 2012 in Ljubljana, Slovenia, at Poslovna hiša Unija, Tržaška cesta 515, 1251 Brezovica pri Ljubljani.   The seminar is organized by DbProf d.o.o. in cooperation with SIOUG, Slovenian Oracle User Group.

Seminar description:
XML is nowadays in use all around us. XML is part of Microsoft Office documents, reports, service orientated architectures and in mobile devices. The urge to do more with all this XML data, becomes very important or the need to do this more efficiently. The core Oracle database functionality which deals with XML in the database, called "XMLDB", a so called "no cost option" functionality of the database, is becoming popular as a solution to deal with these huge amounts of this semi-structured data.
Delivered XML data can be consumed via XMLDB and transformed into relational data or relational data will be used as a basis for XML to service the needs of the outside world. Oracle XMLDB functionality supports all W3C standards defined while dealing with XML. The Oracle XMLDB functionality can not only be used to generated and consume XML, but also to create Native Database Web Services (out-of-the-box web services), or support for HTTP, FTP or WebDAV. The Oracle XMLDB environment has his own file/folder environment and is relied upon, also by Oracle, heavily regarding Oracle tool reporting, interfacing or database security.
Seminar Goals:
Besides the introduction of the history of XMLDB, an overview and concepts, the course will deal in depth with performance problems, design, set-up, architecture and troubleshooting. The main goal of this seminar is to get necessary understanding how this technology can be used to the maximum extent like efficiently consuming or generating XML files. Also real life customer use-cases will be demonstrated and explained, regarding their drawbacks and benefits in the solutions.
The training has been designed for everyone (architects, developers or database administrators) who are involved in using XMLDB functionality. The seminar provides a quick start for people who will have to consume, generate or manage XML or want to use database build-in XMLDB functionality.

Expected knowledge

  • Basic knowledge of the Oracle database
  • Basic understanding of SQL and PL/SQL knowledge
  • Basic understanding of XML knowledge

The training is using Oracle's freely provided and downloadable OTN Developer Days VirtualBox virtual machine training environment. The extra training material, which will be needed for this course, like supporting documents, pdf's, examples and code, will be provided at the beginning of the course.
Training Goals
Will offer a holistic overview of the Oracle XML database functionality
Will offer an in depth overview and reasoning on how to handle XML data to come to performing, working, solutions
Will offer insight in the architectures and mechanisms in Oracle's database solutions to deal with XML problems
Will offer ways to avoid and troubleshoot problems
Will demonstrate to get the best, regarding performance and functionality, out of this XML database functionality
The training material will be deliverd in electronic form.
After this training, attendees are able to make balanced decisions regarding choices of how to setup and implement the XMLDB database functionality and its architecture. It will help them in choosing the right choices among possible methods for consuming, generating or storing XML. It will demonstrate how easy it can be to open up propriety relational environments to service orientated architectures and also when one should not use this functionality.

Training Agenda:

Day one
An introdcution of XML in the database
XML DB architecture:

  • The Protocol Server
  • The XDB Repository
  • XDB Repository Events

XML DB structures:

  • API's supporting XML interfacing, URIType-functionality
  • The XMLType datatype

XML en XML Schema Design and best practices
Storage of XML in the database:

  • XMLType CLOB Storage
  • XMLType Object Relational Storage
  • XMLType Binary XML Storage
  • XML Partitioning

Indexing of XML in the database:

  • BTree Index usage in regards to XML structures
  • Function based Index usage in regards to XML structures
  • Oracle Text Index usage in regards to XML structures
  • The Unstructured XMLIndex
  • The Structured XMLIndex

Security and Folder handling
Troubleshooting and Performance
Day two
XML/SQL Operators
XML Packages, functions and procedures
XSL Transformations
XMLType Views
Troubleshooting and Performance

Marco Gralike, working for AMIS Services BV as a principal Oracle database consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like operating system administration and application servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB since 2003, focusing on his old love, database administration and performance. He has been an Oracle XMLDB enthusiast ever since.
He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco has presented among others in Holland, UKOUG, Oracle OpenWorld, Hotsos, MOW, and ODTUG Kaleidoscope. He has been awarded the Oracle ACE and ACE Director title for his work in the Oracle XMLDB area and has been a member of the OakTable Network since 2009. Currently he is also an Oracle Advisory Board member for XMLDB functionality in the next Oracle release.
Registration for the seminar:

Seminar Location:
Poslovna hiša Unija, Tržaška c. 515, 1351 Brezovica pri Ljubljani

Mastering Oracle Trace Data, March 9, Irving Texas

Mastering Oracle Trace Data by Cary Millsap, Method R Corporation
Event date: 
Fri, 2012-03-09

Mastering Oracle Trace Data
A one-day course taught by Cary Millsap
On March 9, Cary Millsap will teach his popular one-day Mastering Oracle Trace Data course in Irving, Texas. The date and location are ideal for people attending the 10th anniversary Hotsos Symposium, which will be held March 5–8, also in Irving.
Course registration includes a day of instruction with Cary, a new book, a T-shirt, and licenses for software that will help you get more out of your trace data the moment you get home from class. See I Can Help You Trace It, the story behind the course. You can register here.
For other Method R events, see the Method R Corporation calendar.

Hotsos Symposium 2012

10th Annual Hotsos Symposium 2012
Event date: 
Sun, 2012-03-04 - Thu, 2012-03-08

Join the world's top Oracle performance analysts including Tom Kyte, Jonathan Lewis, Tanel Põder, and Kerry Osborne at the tenth annual Hotsos Symposium, which is the conference dedicated to issues of Oracle system performance. The Symposium will be held March 4 — 8, 2012 at the Omni Mandalay Hotel in Irving, TX.

RMOUG Training Days 2012

RMOUG Training Days 2012
Event date: 
Tue, 2012-02-14 - Thu, 2012-02-16

One of the largest Oracle user group conferences in the world, the "Training Days 2012" conference presented by the Rocky Mountain Oracle Users Group ( is two days on Wednesday and Thursday (15-16 Feb), consisting of more than 140 presentations by more than 100 of the top speakers in the world.  Registration for this conference, from as low as US$265 - US$340 for early registration, is an incredible educational value.  Click here to register for this event.
Sixteen (16) Oak Table members are presenting at this event, along with dozens of Oracle ACEs and ACE Directors.  Oak Table member and ACE Director Cary Millsap will be providing the keynote address.  In addition to twenty high-end vendors exhibiting their products and services, the "RAC Attack" hands-on labs will be running in the exhibition area throughout the conference.
On the Tuesday preceding the conference (14-Feb), we also have five extended four-hour University sessions by some of the expert presenters at the conference.  Click here to register for these complimentary sessions, which runs from US$112.50 when registering for the 2-day Training Days conference as well, or US$125.00 when just registering for the University sessions alone.
Additionally, on the Tuesday preceding the conference (14-Feb), Oracle TechNet (OTN) is presenting their FREE full-day "Developer's Day" featuring top developers from Oracle Corporation.  Click here to register for this complimentary event.

UKOUG Annual Conference 2011, 5th - 7th Dec

Event date: 
Mon, 2011-12-05 - Wed, 2011-12-07

UKOUG Oaktable Sunday 2011

UKOUG Oaktable Sunday 2011
Event date: 
Sun, 2011-12-04

 Why not join us for OakTable day on Sunday 4th December?
In a smaller setting, you can attend a dedicated set of sessions directly from a selection of OakTable members away from any potential session contention of the main conference. The sessions will be presented in just two streams, and will also be repeated on the Wednesday of the main conference, allowing you two chances not to miss some of the top sessions of the conference. Participants of OakTable Sunday will also receive the exclusive chance to win a selection of signed books by various OakTable members, and the opportunity to join the OakTable for an informal panel session and a beer. Attendees will receive a commemorative shirt to mark the event.
Sponsored by Scale Abilities Ltd and Miracle A/S.

To view the presentations on offer visit the agenda grids.
To register click here.

UKOUG Special event: Security.

UKOUG Security event
Event date: 
Tue, 2011-09-13

A special UKOUG event on security held at the birthplace of computing, and featuring a presentation from Pete Finnigan (Oak Table).
A tour of this historic site will be available for attendees, but make sure you register early.

NoCOUG Summer Conference 2011

Event date: 
Thu, 2011-08-18

Now in its 25th year and 100th Conference
Three streams of technical information and a keynote by Jonathan Lewis