1 / 10

Database Management for d0onprd Status and Performance

Explore the database management status and performance of d0onprd including tablespace usage, backup strategies, supported access software, and considerations for user support. Utilize Statspack Viewer 8.1.7 for monitoring performance and access databases through supported software tools.

cicely
Télécharger la présentation

Database Management for d0onprd Status and Performance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Online Databases Status V.Sirotenko, 11/1/2002 • Oracle 8i Servers, release 8.1.7.3 • Platform: Compaq Tru64 UNIX V5.1 (Rev. 732) • Production DB d0onprd, on d0olc, 64 users, • 34Gb allocated, 15Gb used • 79Gb disk space available, RAID-1 • Development DB d0on, server on d0olb, 105 users, • 24Gb allocated, 4Gb used • 36Gb disk space available, RAID-1

  2. User Applications • Platforms: Linux,OSF1 Unix,Windows • d0onprd: • 1) Detectors calibration and download APIs with online • to offline transfer tools ( smt,cft,muon,cal ) • EPICS hardware database (HDB) toolkit • RUNS database APIs : runGrabber/runPusher • Monitoring daemon: dbMonitor • d0on: • Solenoid Hall probes DB API (solGrabber) • FPD pot position/alarms DB API • historyDB (hisDB) toolkit : slow EPICS archiver

  3. Major schemas and tablespace usage in d0onprd TABLESPACE USED MB FREE MB TOTAL PERCENT USED ------------------------------ ---------- ---------- ---------- ------------------------------------------------------------------------------- CAL_CALIB 3006 994 4000 75 CFT_CALIB 2942 1058 4000 74 HDB_01 196 304 500 39 MUON_CMSC_CALIB 6 194 200 3 MUON_FMSC_CALIB 12 188 200 6 MUON_MDT_CALIB 3 197 200 2 MUON_PDT_CALIB 8 192 200 4 RUNS 389 1611 2000 19 SMT_CALIB 6387 2612 9000 71

  4. Tablespace size dynamics

  5. Tablespace size dynamics (2)

  6. Backup strategy • Oracle Backup: /db/backup 142 Gb available • - d0onprd • - rman ( every day, keep 3 days, 1 set = 21 Gb ) • - export (every other day, keep 2 days, 6 Gb each ) • - d0on • - rman ( every day, keep 3 days, 1 set = 7 Gb ) • Backup to tape: • DLT8000 tape drive mounted in a automated tape library with a 26 • tape capacity in two 13 tape cartridges, almost 2 weeks of • unattended backup • Tape pool – 200 tapes, 12 week (3 month) rotation • full backup : /db (every Friday, 2 tapes) (d0onprd) • /usr (every Monday, 1 tape) (d0on) • incremental: every day • every 3 months week long backup is kept forever

  7. Performance: d0onprd Use Statspack Viewer 8.1.7 to monitor performance, every two weeks plots are posted on the web ( Online Computing)

  8. Performance: d0onprd (2)

  9. Performance: d0onprd (3)

  10. DB access software currently supported • From Python: Dcoracle and Dcoracle2 • From C++ : d0om_oracle • It’s OK if user is using d0om, but if not? • For online people use mostly python, but sometime there is • a need to access DB from C/C++ programs • Should we consider to provide support to users from • generic C++ based on OTL (Oracle Template Library) ? • Or OCI library? • MisWeb: add graphics capability (?)

More Related