ITOUG Tech Day

Milano – 11 Novembre 2016

 

Dopo il successo dell’OTN EMEA Tour tenutosi lo scorso 12 maggio a Milano, l’Italian Oracle User Group ha riproposto l’11 novembre una giornata dall’elevato contenuto tecnico, nuovamente in compagnia di speaker di fama internazionale, tra i quali Christian Antognini (Senior Principal Consultant, Trainer and Partner at Trivadis, Oracle ACE Director) e Mauro Pagano (Oracle ACE, Accenture Enkitec Group).

Nell’era della data explosion, in un settore in costante evoluzione, essere informati sulle ultime tecniche di amministrazione è un obiettivo fondamentale per tutti i professionisti del database.
I corsi ufficiali e la documentazione sono certamente la prima fonte di informazione, ma quando si conoscono già le tecniche di base, condividere le proprie esperienze con altri clienti e consulenti che lavorano quotidianamente nel nostro settore può fare la differenza.
L’ITOUG Tech Day ha proposto nella propria agenda una giornata ricca di presentazioni sui temi e le problematiche più comuni o impegnativi riguardanti il database Oracle.

L’evento (sala conferenze e catering) è stato sponsorizzato da:

icteam_logo

Agenda

Agenda

NOTA: L’agenda è semi-definitiva, potrebbero esserci cambiamenti minori che non altereranno la qualità dell’evento.

Luogo: Una Hotel Century, Via Fabio Filzi, 25/b, 20124 Milano
Data: 11 Novembre 2016

Inizio Fine Sessione Durata
08:45 09:15 Registration & Socializing 00:30
09:15 09:30 Welcome 00:15
09:30 10:15 [ITA] Migrating to 12c: 300 DBs in 300 days. What we learned.
Ludovico Caldara (Senior Consultant at Trivadis, Oracle ACE Director)
00:45
10:15 11:00 [ITA] Assessment Oracle Instance
Francesco Renne (CEO at ICTeam SpA, Oracle Specialist)
00:45
11:00 11:15 Break 00:15
11:15 12:00 [ITA] Designing for Performance: Database Related Worst Practice.
Christian Antognini (Senior Principal Consultant, Trainer and Partner at Trivadis, Oracle ACE Director)
00:45
12:00 12:45 [ITA] Adaptive Features or: How I Learned to Stop Worrying and Troubleshoot the Bomb.
Ludovico Caldara (Senior Consultant at Trivadis, Oracle ACE Director)
00:45
12:45 13:45 Lunch 01:00
13:45 14:30 [ITA] Identification of Performance Problems Without the Diagnostic Pack
Christian Antognini (Senior Principal Consultant, Trainer and Partner at Trivadis, Oracle ACE Director)
00:45
14:30 15:15 [ITA] SQLd360: SQL Tuning Diagnostics Made Easy
Mauro Pagano (Infrastructure Senior Principal at Accenture Enkitec Group, Oracle ACE)
00:45
15:15 15:30 Break 00:15
15:30 16:15 [ITA] OBIEE 12c Upgrade Experience At Liberty Global Case Study
Francesco Tisiot (Principal Consultant at Rittman Mead)
00:45
16:15 17:00 [ITA] Oracle Statistics by Example
Mauro Pagano (Infrastructure Senior Principal at Accenture Enkitec Group, Oracle ACE)
00:45
17:00 17:15 Conclusione 00:15

Christian Antognini

christianSince 1995, Christian Antognini has focused on understanding how the Oracle database engine works. His main interests include logical and physical database design, the integration of databases with Java applications, the query optimizer and basically everything else related to application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland. If Christian is not helping one of his customers get the most out of Oracle, he is somewhere lecturing on application performance management or new Oracle Database features for developers. In addition to classes and seminars organized by Trivadis, he regularly presents at conferences and user-group meetings. He is a proud member of the OakTable Network and an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011).

Ludovico Caldara

ludovicoLudovico is a database specialist with more than 16 years of experience on the full Oracle stack (Clusterware, DataGuard, RAC, ASM, EM) but he also has deep knowledge of MySQL and other DBMS engines. He has administered literally thousands of databases in big datacenters so he has developed a natural leaning to automatization, monitoring and high availability. He is certified on Oracle (OCP 12c, OCE) and MySQL (OCP). He is a blogger and a confirmed community contributor, with the “RAC Attack 12c” project and his RACSIG, ITOUG and SOUG board membership. Ludovico is currently working as a senior consultant at Trivadis in Lausanne, Switzerland, where he can cultivate his passion for technology, bike, snowboard and family.

Mauro Pagano

mauroMauro is a database performance engineer with special interest in SQL Tuning and Wrong Results. He is an Oracle ACE and active member of the Oracle community, always willing to help or mentor other peers, and he enjoys giving back developing tools and presenting at Oracle User Groups conferences; he is the author of SQLd360 tool and the previous maintainer of other legacy tools like SQLTXPLAIN and SQLHC. Mauro has over a decade of experience in the Oracle world, from database tuning to applications development. Mauro currently works as a consultant for Accenture Enkitec Group, as a member of the Oracle database Health-Check team.

Francesco Renne

francescoFrancesco was born in 1962 in Como, Italy. He studied computer sciences at the University of Milan, and after graduating, he joined Olivetti, working on the development of the Unix operating system. Francesco has been interested in performance since the beginning of his professional career and has worked on Unix internals and Oracle environments in order to achieve the best possible performance in different environments (new products, benchmarks, international real applications on production, and so on). In 1994, he joined the Banca Popolare di Bergamo, the only bank in Italy that has rewritten its entire information system using Unix and Oracle. He has made major contributions to improve performance over the whole platform. In 1999, he co-founded ICTeam and is now the company’s CEO. He continues to work on performance, especially on Oracle data warehouse environments, for some of the largest companies in Italy. Francesco lives near Bergamo, Italy, with his wife, Adria, and their two daughters, Viola and Veronica. When not striving to improve something, he enjoys staying with his family, listening to progressive music, and taking pictures.

Francesco Tisiot

francescoFrancesco is a DW/BI principal consultant at Rittman Mead and an OBIEE enthusiast. Analyst, architect and developer, he built expertise with Oracle Data Integrator and Oracle Business Intelligence Enterprise Edition. He also delivers Oracle Business Intelligence trainings for Rittman Mead. Francesco is involved in the OBIEE community by providing support on Oracle Technology Network forums, blogging on the Rittman Mead website, speaking at various conferences – including the BIWA summit, OUG Scotland and Ireland – and being part of the beta program for the OBI Cloud release. Fields of expertise : Dimensional Modeling, ETL and Business Intelligence. Technologies : ODI, OBIEE and PL/SQL.

Christian Antognini

Designing for Performance: Database Related Worst Practices
Optimal performance is not simply a product one can buy but rather the results of accurate planning and a correct implementation. Given that applications should be designed for performance, it would be useful to cover an approach to doing that in great detail. However, for obvious reasons, it is not a subject that can be covered in a presentation. For this reason, I limit myself to briefly describing the top most common database-related design problems that frequently lead to suboptimal performance.

Identification of Performance Problems Without the Diagnostic Pack
Diagnostic Pack, which is an option available for the Enterprise Edition of Oracle Database only, gives access to a number of dynamic performance views and to the Automatic Workload Repository (AWR). Both are very useful for the identification of performance problems. On the one hand, dynamic performance views are mainly used for the analysis of performance problems while they are occurring. On the other hand, AWR is aimed at the analysis of performance problems that occurred in the past. The aim of this presentation is to describe how to perform analyses similar to those that can be carried out with the tools provided by the Diagnostic Pack even if you don’t have it.

Ludovico Caldara

Migrating to 12c: 300 DBs in 300 days. What we learned.
For a customer in Switzerland, we are in process of migrating 400 databases to 12c. We have migrated 300 so far, and we have had good and bad surprises. This session will show a few scenarios that we faced during the upgrade project.

Adaptive Features or: How I Learned to Stop Worrying and Troubleshoot the Bomb.
Adaptive Dynamic Sampling, Adaptive Execution Plans, SQL Plan Directives: these new features are the new performance troublemakers when migrating databases from 11g to 12c. The optimizer uses them to seek for the perfect execution plan, but does it always succeed? This session will focus on the first steps required to quickly troubleshoot performance issues due to the adaptive features.

Mauro Pagano

SQLd360: SQL Tuning Diagnostics Made Easy
SQL Tuning isn’t an easy task, especially when considering diagnostic collection and data analysis. SQLd360 is a new free tool built from the ground up with the idea of making diagnostics collection faster and easy without having to install anything in your database. At the same time, data analysis is made much easier with charts and graphs that help quickly answer even complex questions. This session will focus on how SQLd360 can be used to resolve real-life issues, showing how charts and graphs make SQL Tuning much easier.

Oracle Statistics by Example
Doesn’t matter if you are a DBA or a developer, new or with many years of experience – you keep hearing everywhere how important statistics are for good performance in an Oracle Database. But why? Why do you need to spend time and resources collecting them? How are those statistics used?
Come to this session to learn why stats are crucial to good performance, which stats are the most important, how the Cost-Based Optimizer uses them, and what happens when something goes wrong. The session will use demos to show the impact of statistics on the optimizer, how they can affect performance, and how to fix things when they go wrong.

Francesco Renne

Assessment Oracle Instance
Frequently we have the need to make the Oracle database assessment and the environment in which the database is located without clear indications of such application modules have problems.  In these cases we start with the macroscopic analysis of the existing situation and then arrive to the individual potential causes of the problems with the aim to identify the possible solutions, hardware, of configuration or more often applicative. The presentation show some strategies problems research using the diagnostic data collection that are available in an Oracle database, If you have available Diagnostic Pack license 🙂

Francesco Tisiot

OBIEE 12c Upgrade Experience At Liberty Global Case Study
What does an OBIEE 11g to 12c migration look like? What benefits and what options does it enable? Which tools can be used to speed up the process and guarantee the correct content migration? This session will guide you through the Liberty Global case study, a complete upgrade experience from 11g to 12c. A step by step explanation about procedures, server settings and tools used during the migration will be provided with particular focus on the Baseline Validation tool and how it can help accelerating the UAT phase.

Registrazione

L’evento è già passato, le iscrizioni sono chiuse.

Se vuoi essere informato sui prossimi eventi, inserisci comunque i tuoi dati qui sotto:

Fields marked with an * are required

Per iscriverti, inserisci i tuoi dati e invia questo form: