Hotsos Revisited 2013

(1)

KvK Utrecht 30114159 Statutair gevestigd te Enschede

Edisonbaan 15 3439 MN Nieuwegein Postbus 24 3430 AA Nieuwegein T +31(0)30 6016000 F +31(0)30 6016001 E [email protected] Wwww.amis.nl CO MM IT TE D TO IC T. IN V O LV ED I N P EO PL E.

Hotsos Revisited 2013

Datum

dinsdag 2 april 2013

Tijd

16.30 – 21.30 uur

Locatie

AMIS, Edisonbaan 15 te Nieuwegein

Kosten

gratis toegang

Van 3 t/m 7 maart vindt in Irving, Texas, voor de elfde keer het internationale Oracle Performance Symposium Hotsos plaats. Het symposium belooft dit jaar wederom inhoudelijk hoogstaande presentaties en discussies, want naast presentaties van Tom Kyte, Cary Millsap, Maria Colgan en Steven Feuerstein over performance, staan er onderwerpen op de agenda zoals Big Data, noSQL, XML, Statistische toepassingen over performance, Agile (beheer), beheer in de (Oracle) Cloud, Exadata en Oracle 12c.

Dit jaar is het vijf Nederlanders gelukt om mee te mogen doen. De heren Toon Koppelaars, Gerwin Hendriksen, Jacco Landlust, Frits Hoogland en Marco Gralike hebben niet alleen het genoegen om ter plekke te zijn, maar geven ook zelf een presentatie over hun favoriete onderwerp.

Speciaal voor diegene die niet in Texas kunnen zijn, organiseert AMIS op dinsdagavond 2 april

‘Hotsos Revisited 2013’. Deze avond kan je de sfeer van Hotsos komen opsnuiven en geven de bovenstaande sprekers nog één keer hun presentatie.

Programma

16.30 Ontvangst

17.00 Welkom & introductie sprekers

17.10 SQL plan Management

Gepresenteerd door Toon Koppelaars

18.15 Diner

19.00 Parallelsessie 1

Creating Structure in Unstructured Data

Gepresenteerd door Marco Gralike

About Multiblock Reads

Gepresenteerd door Frits Hoogland

20.10 Parallelsessie 2

"Method GAPP" Used to Mine OEM 12c Repository and AWR Data

Gepresenteerd door Gerwin Hendriksen

Lessons Learned while Pushing the Limits of SecureFiles

Gepresenteerd door Jacco Landlust

21.10 Afsluiting & borrel

*De sessies worden in het Nederlands gegeven.

(2)

CO MM IT TE D TO IC T. I N V O LV ED I N P EO PL E.

Plenaire sessie

17.00 – 18.00 uur

SQL Plan Management Toon Koppelaars

This presentation will introduce the audience to the SQL Plan Management (SPM) feature. First, the general concepts and tooling around SPM will be discussed and demonstrated, and the audience will be made aware of a few SPM oddities showing it is not a silver bullet (yet?). The overview of SPM will constitute the majority of the talk. However, at the end, we will also discuss why and how SQL Plan Management was introduced into a large back-office application.

Parallelsessie 1

19.00 – 20.00 uur

Creating Structure in Unstructured Data

Marco Gralike

The energy and performance drain needed to get something useful out of unstructured data is enormous. Organizations want to do more with all their structured, semi-structured or

unstructured data, and when this phenomenon ends up in your database, it will become a serious performance headache. The presentation makes use of the English XML MediaWiki data set (freely available on the internet) and the Oracle 12c database.

This data set, on which this presentation demonstrates its findings, contains enormous amounts of those structured, semi-structured and unstructured components, and consists of more than 10+ million free text XML documents. The presentation will show and demonstrate how to get this data, performance-wise, under control via applying logical and physical design principles. Results are shown and discussed, what the effects are if you add partitioning, securefile storage and specificially crafted domain index methods to this performance-draining monster.

About Multiblock Reads

Frits Hoogland

This presentation focuses on multiblock reads, the IO method for full scans for every version of the Oracle database. Whilst being a very old and common IO method, different functionality of this method has silently been introduced with the version 11 of the database. Also new

functionality with multiblock reads have been made default behavior and available with version 11 and again with version 11.2

(3)

Parallelsessie 2

20.10 – 21.10 uur

"Method GAPP" Used to Mine OEM 12c Repository and AWR Data

Gerwin Hendriksen

This session will first briefly demonstrate how to use "Method-General Approach Performance Profiling" (Method-GAPP), which was introduced at Hotsos Symposium in 2008, to profile end-user response times and predict performance in multi-tier architectures. Business processes are influenced by many components like web servers, portal servers, Oracle Internet Directory servers, database servers, application servers, etc. The power of "Method-GAPP" is its ability to help you manage environments of arbitrary complexity, regardless of which technologies you've implemented.

This session will mainly focus on the value of data inside the OEM 12c repository and the available AWR data. This data is used by the Method, to see what is important for your specific business process response time for the end-user. By using the Method to mine the data, you will be able to find the most involved tiers in your architecture, what the most important SQL is, and what the most involved events are. After creating a model, by the use of "Method-GAPP", the end-user performance can be predicted based on the mined data.

The presentation will show results from actual customer experiences in SOA-based systems with more than three nodes. Also a complete case from the most recent "Method-GAPP" white paper will be explained and shown. The session will further show how the Method works and how important relations between available mined data and end-user response times can be found. The session will also show how the results can be used for your optimizations effort.

Lessons Learned while Pushing the Limits of SecureFiles

Jacco Landlust

With the introduction of the new Oracle 11g feature SecureFiles, more and more content will be stored in Oracle databases. Fusion Middleware applications are depending heavily on clobs for their transactional data, also.

This session is all about sharing findings on SecureFiles while implementing a WebCenter Content system, that stores 100 million documents (over 35TB) in SecureFiles servicing 65K employees. These findings vary from concurrency, load- to size-related issues. All findings will be dcemonstrated with repeatable test cases.

(4)

Biografie van de sprekers

Marco Gralike

Marco Gralike, working for AMIS 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 in finding working, performing solutions.

Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance. He is an Oracle XMLDB enthusiast. 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 is a frequent speaker at conferences like Oracle OpenWorld, UKOUG, RMOUG, ODTUG, BGOUG and local user group seminars in Holland. He has been awarded the Oracle ACE title for his work in the Oracle XMLDB area (2007) and has been since 2009 a member of the OakTable network.

In 2010, he was awarded the Oracle ACE Director status and was asked to become a member of the Oracle XMLDB Customer Advisory Board for the next major release. He has been the AMIS Oracle beta lead for database versions 11.x and 12.1.

Frits Hoogland

Frits Hoogland is an IT professional specializing in Oracle database performance and internals. Frits makes frequent Oracle technical presentations in the Netherlands, UK, Denmark, Slovenia and the United States. He actively contributes to the Oracle community.

In 2009, he received an Oracle ACE award from the Oracle Technology Network and a year later became an Oracle ACE Director. In 2010, he joined the OakTable Network. In addition to developing his Oracle expertise, Frits works with MySQL, Postgre SQL, Oracle's Application Server Suite, the Apache web server, and relevant operating systems. Frits recently presented at Enkitec E4, UKOUG Technology and E-Business suite conference and the OUG Scotland

conference in Linlithgow.

Gerwin Hendriksen

Gerwin Hendriksen has been working with Oracle technologies for more than fifteen years. He started work as a DBA at a consulting company in the Netherlands. After this, he worked for five years for Oracle in the role of Advanced Resolution Engineer. In this role, he specialized in performance and high availability for the Oracle database and Oracle E-Business Suite. In his time at Oracle, he gave several training classes in different countries. Later, Mr. Hendriksen joined IBM, and worked there for two years. At IBM, he worked as a Technical Consultant for several projects in different countries. He also gave training classes in the IBM JSC in Montpellier, and at several customer sites.

(5)

Currently, he is employed by codecentric in the Netherlands, where he is working as a

Performance Architect. He has given several presentations about Oracle database performance and Oracle E-Business Suite performance. He has also given presentations for the Oracle User Group Holland, at the DBA Symposium in Holland (Planboard), at Oracle Open World 2008, at the Hotsos Symposium (2008, 2009, 2011) and at the UKOUG 2011 symposium. During these last mentioned presentations, he presented on his developed performance method "Method-GAPP". Gerwin is very busy with performance management, capacity planning, and E-Business Suite Performance.

Toon Koppelaars

Toon Koppelaars is a long-time Oracle technology user and has been involved in application development as well as database administration.

Toon's special interest areas include: the Oracle Optimizer (SQL tuning), technical application architectures (from a performance and maintainability perspective), and the specification and implementation of data integrity rules (aka business rules). He is a frequent speaker at Hotsos Symposia, ODTUG, UKOUG and the Dutch Oracle User Group.

Together with Lex de Haan, he has co-authored "Applied Mathematics for Database Professionals" (Apress, June 2007).

In 2007, Mr. Koppelaars decided to go independent and founded his own company RuleGen B.V. Toon is an Oracle ACE.

Jacco Landlust

Jacco Landlust, working as an independent consultant in the Netherlands, has been working with Oracle software since 2000 (RDBMS Oracle 7.3, AS 1.0.2). His strong knowledge of the Linux operating system, J2EE application servers and RDBMS's makes him an all-around Oracle technician.

In 2006, Jacco was granted an Oracle ACE award. Jacco's main areas of focus is currently designing infrastructural architectures and troubleshooting stability and performance issues in clustered environments.