Luca.Canali@cern.ch - Home page

Talks at conferences and workshops:

• Active Data Guard at CERN, UKOUG 2012 conference, Birmingham, December 4th, 2012
• Testing Storage for Oracle RAC 11g with NAS, ASM, and SSD Flash Cache, UKOUG 2011 conference, Birmingham, December 6th, 2011
• CERN IT-DB Deployment, Status, Outlook - ESA-GAIA DB Workshop, ISDC, March 2011
• ACFS under scrutiny - UKOUG Conference 2010, Birmingham, Nov 2010
• Data Lifecycle Management Challenges and Techniques, a 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 2010
• 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, November 2009.
• 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, A User’s Experience, presentation at UKOUG Conference 2008, Birmingham Dec 2008.
• Datalifecycle_WLCG_DB_workshop_LC: 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.
• Oracle 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, talk on Oracle ASM internals and performance measurements at UKOUG 2007, Birmingham, December 2007.
• WLCG_Oracle_perf_for_admin: Oracle Performance for Administrators, WLCG Reliability Workshop, CERN November 2007.
• Oracle_CERN_Service_Architecture, CERN DB workshop, January 2007.
• UKOUG_RACSig_Oct06, UKOUG RAC SIG meeting, UKOUG RACSIG meeting, London, October 2006.
• T2_tutorials_Jun06_OracleRAC: 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", April 2006
• 3D_RAL_Mar_06: "Oracle 10gR2 configuration", 3D DB Workshop at RAL (UK), March 2006.

Technical blog: http://externaltable.blogspot.com

Scripts and resources

Miscellaneous links:

• ASM_Internals (pdf), ASM metadata and related X$ tables
• ASM_Utilities (pdf), ASM support utilities, metadata management, file access of unmounted diskgroups for troubleshooting (kfed, amdu)
• Disable server-side load balancing (pdf), how to create tnsnames aliases to bypass server-side load balancing in Oracle
• Querying AWR data for capacity planning, published at Oracle support site (see also this local copy)
• Oracle IOPS workload (pdf): using Oracle to measure IO subsystem performance numbers
• Testing with Orion (pdf): Getting started with Orion for I/O performance testing
• SQLPython: a CLI alternative to sql*plus. Links to the latest version in the 'cheese shop'
• Joint work with Atlas experiment
  • Advanced Technologies for Scalable ATLAS Conditions Database Access - Article: R Basset et al 2010 J. Phys.: Conf. Ser. 219 042025
  • Contributions at CHEP 2012
• Contacts: my mail address and phone number

Last updated, May 2013.