Luca.Canali@cern.ch - Home page
Talks at conferences and workshops:
Modern Linux Tools for Oracle Troubleshooting, UKOUG Tech14, Liverpool,
December 9th, 2014,
A Closer Look at CALIBRATE_IO, UKOUG Tech14, Liverpool, December 9th,
Introduction on Data for Physics at CERN and Deep Dive into Oracle ASM,
Enkitec E4 2014, Dallas (TX), June 2014,
Picture is Worth a Thousand Storage Metrics, Hotsos 2014, Dallas (TX),
March 4th, 2014, slides
Lost Writes, a DBA's Nightmare?,
UKOUG Tech13, Manchester, December 4th,
Storage Latency for Oracle DBAs,
UKOUG Tech13, Manchester, December 2nd,
Active Data Guard at CERN,
UKOUG Conference 2012, Birmingham, December
4th, 2012, slides
Testing Storage for Oracle RAC 11g with NAS, ASM, and SSD Flash Cache, UKOUG
Conference 2011, Birmingham, December 6th, 2011,
IT-DB Deployment, Status, Outlook, ESA-GAIA DB Workshop, ISDC, Geneva, March 2011,
ACFS Under Scrutiny, UKOUG Conference 2010, Birmingham, Nov 2010,
Data Lifecycle Management Challenges and Techniques, Userís Experience, UKOUG Conference 2010, Birmingham, Nov 2010,
CERN DB Services for Physics - 2010 Report, Distributed Database
Workshop, CERN, Nov 2010,
Overview of the CERN DB Services for Physics, Orcan Swedish Oracle Users group Conference, Stockholm, May
Compressing Very Large Data Sets in Oracle, UKOUG
Conference 2009, Birmingham, Dec 2009,
Evaluating and Testing Storage Performance for Oracle DBs, UKOUG
Conference 2009, Birmingham, Dec 2009,
ASM configuration review, Distributed Database Operations Workshop, CERN,
- Storage for data management, 'after C5' CERN-IT presentation, CERN, May 2009.
Data Lifecycle Review and Outlook, Distributed Database Operations
Workshop, Barcelona, April 2009
- Database Operations Security Overview, Distributed Database Operations
Workshop, Barcelona, April 2009.
Overview of Storage and IT-DM lessons learned, IT-DM technical group
meeting, CERN, March 2009.
Implementing ASM Without HW RAID, Userís Experience, UKOUG Conference 2008,
Birmingham, Dec 2008,
Data lifecycle management ideas, WLCG Database Workshop, CERN Nov 2008.
- Workhops_8_Jul_case_PVSS_LC: Oracle performance tuning case study,
PVSS archiver, Database Developers Workshop, CERN 8-7-2008.
- Workhops_8_Jul_perf_for_developers_LC: Oracle performance tuning
ideas for developers, Database Developers Workshop, CERN 8-7-2008.
Storage Performance Studies: Scalability tests of VLDBs with RAC
and ASM for Physics DB Services, WLCG Workshop, CERN, Apr 2008.
A Closer Look Inside Oracle ASM, UKOUG
2007, Birmingham, December 2007,
- WLCG_Oracle_perf_for_admin: Oracle Performance for
Administrators, WLCG Reliability Workshop, CERN November 2007.
DB workshop, January 2007.
Database Services at CERN with Oracle 10g RAC and ASM on Commodity HW, UKOUG
RAC SIG meeting, London, October 2006,
Oracle and RAC for Physics DB June 2006
- DB services at CERN HEPIX 2006: "Database Services for Physics at CERN with
Oracle 10g RAC", HEPIX Conference, Rome, April 2006.
- DB_Serv_Meeting_ASM_Perf: "ASM-based storage to scale out Database Services for Physics",
- 3D_RAL_Mar_06: "Oracle 10gR2 configuration", 3D DB Workshop at RAL (UK), March 2006.
Scripts and resources (including PerfSheet4,
OraLatencyMap, PyLatencyMap, etc):
(pdf), ASM metadata and
related X$ tables.
(pdf), ASM support
utilities, metadata management (kfed, amdu).
- Articles in peer-reviewed journals:
Sequential data access with Oracle and Hadoop: a performance comparison,
Zbigniew Baranowski, Luca Canali and Eric Grancher, 2014 J. Phys.:
Conf. Ser. 513 042001
ATLAS database application enhancements using Oracle 11g, G
Dimitrov, L Canali, M Blaszczyk and R Sorokoletov, 2012 J.
Phys.: Conf. Ser. 396 052027
ATLAS Data Management Accounting with Hadoop Pig and HBase, Mario
Lassnig, Vincent Garonne, Gancho Dimitrov and Luca Canali, 2012 J.
Phys.: Conf. Ser. 396 052044
Structured storage in ATLAS Distributed Data Management: use cases and
experiences, Mario Lassnig, Vincent Garonne, Angelos Molfetas,
Thomas Beermann, Gancho Dimitrov, Luca Canali, Donal Zang and Lisa
Azzurra Chinzer, 2012 J. Phys.: Conf. Ser. 396 052045
Technologies for Scalable ATLAS Conditions Database Access, R Basset, L
Canali, G Dimitrov, M Girone, R Hawkings, P Nevski, A Valassi, A
Vaniachine, F Viegas, R Walker and A Wong, 2010 J. Phys.: Conf. Ser. 219 042025
- Contributions at
Oracle IOPS workload
(pdf): using Oracle to measure IO
subsystem performance numbers (custom scripts).
- Testing with Orion
(pdf): Getting started with Orion for I/O performance
- SQLPython: a CLI
alternative to SQL*Plus. Links to the latest version in the 'cheese shop'.
- Contacts: my mail address and phone number.
Last updated, Feb 2015.