Transcript Oracle at CERN DB Workshop Nilo Segura IT/DB/DBR

CERN/IT/DB
Oracle at CERN
DB Workshop
Nilo Segura
IT/DB/DBR
CERN/IT/DB
Agenda
•
•
•
•
•
•
Introduction
Oracle Software Distribution
CERN Database servers
Current technologies in place
Support at CERN
Figures
CERN/IT/DB
Introduction
• Every CERN user is an Oracle user
• Oracle technology has been successfully used and
deployed during many years (since the early 80s)
– Helped to build/deploy and operate LEP
• Present in all CERN sectors but physics data
– EDMS, EDH, BHT, Userreg, SL/PS Logging servers…
• Many technologies available
– XML, Java, EJB, JSP, PL/SQL,Pro*C/C++, OCCI...
• All LHC experiments (but one) are using Oracle
for non-physics data now
CERN/IT/DB
Software distribution
• Three client software repositories
– AFS (Solaris, Linux, Aix,Tru64, HPUX)
– Nice (95/NT/2000)
• Different versions available
– Users can switch from one to another
• People must test new releases before they
become the default production versions
CERN/IT/DB
CERN Database Servers
• Hosts are dedicated to run the database ONLY
• Access to the database is via network, no user has
local access (client-server)
– Excellent stability, reduced administrative tasks
• Servers run on Sun/Solaris hardware for all Oracle
services (a few exceptions)
– Normal setup with single host machines (two clusters)
• Clients can be any supported platform at CERN
– Client software and database software do not need to
match (up to a certain level)
CERN/IT/DB
CERN Database Servers
• Database upgrade policy
– Test all intermediate releases, go to Terminal releases
only
– Longer, better support from Oracle
• Patch Set Release (PSR)
– Bunch of bug fixes released every ~6 months fully
tested by Oracle
– Test first the Patch Set Releases (PSR) on
test/development server
– One-off patches also for specific problems
CERN/IT/DB
Current technologies in place
• Very very very heavy use of Server side
processing (Stored Procedures)
– PL/SQL (robust, stable, compiler available in 9i)
– Java coming at full speed (SL control is largest client)
• Lots of interest in Java & XML technologies,
many projects have started
• Precompilers (basically LEP/SPS, moving to Java
now), OCI (not a lot)
• Heavy use of Oracle tools to generate Forms,
Reports and Graphics from the database
CERN/IT/DB
CERN Support
• Main line of support for technical sector is
[email protected] (IT/DB/DBR)
• Interface with Oracle Switzerland
– Patches, bug reports …
• Dual role : DBA + System Administrator
– Better setup and tuning of the database hosts
• Helping users in the development of new
applications
– Advising on data models
– Technologies to be used
CERN/IT/DB
Figures
• IT Central production and development db servers
– 1319 user accounts, 187k objects
– 23.8Gb
• SL/Logging systems during LEP
– 35 user accounts, 4600 objects
– 41Gb
• AS systems, average size 30Gb
– Between 150 to 500 users, 25k to 225k objects
– Average size 30Gb (max 40Gb)