Online databases s krzywdzinski v sirotenko february 14 2002
This presentation is the property of its rightful owner.
Sponsored Links
1 / 3

Online Databases S. Krzywdzinski, V. Sirotenko February 14, 2002 PowerPoint PPT Presentation


  • 52 Views
  • Uploaded on
  • Presentation posted in: General

Online Databases S. Krzywdzinski, V. Sirotenko February 14, 2002. Oracle 8i Server, release 8.1.7.2 Development DB d0on , server on d0olb, 105 (41) users, 11Gb allocated, 2Gb used, 35Gb disk space available, RAID-1

Download Presentation

Online Databases S. Krzywdzinski, V. Sirotenko February 14, 2002

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Online databases s krzywdzinski v sirotenko february 14 2002

Online DatabasesS. Krzywdzinski, V. SirotenkoFebruary 14, 2002

  • Oracle 8i Server, release 8.1.7.2

  • Development DB d0on, server on d0olb, 105 (41) users, 11Gb allocated, 2Gb used, 35Gb disk space available, RAID-1

  • Production DB d0onprd, server on d0olc, 64 (19) users, 30Gb allocated, 11Gb used, 79Gb disk space available, RAID-1

  • Backup: 71Gb available, 73% full, every night, d0onprd (rman and export), d0on (rman), keep last 3 (2) backups for d0onprd (d0on).

  • Recent DBA activity:

    • complete recovery test of d0on: oracle software, patches, network/admin setup, database instance, rman data loaded from backup tape; took 12 hours (Dec 01).

    • migration test: moved d0on server from node d0olb to d0ola and back, took < 30 min each way (Feb 02).

      Plan to move d0onprd to dedicated d0ola for good.

    • databases cleanup: relocated cal_calib indexes, changed storage parameters

    • checked security vulnerability: turn off extproc on both d0onprd, d0on databases

  • Application software: test version of DCOracle2 with Python 2.x is available on OSF1, Linux and Windows NT


D0onprd performance monitoring online computing documentation database

D0onprd Performance Monitoringonline_computing -> documentation -> database

% of read requests satisfied by cache data buffer (> 95%)

% of PL/SQL code executed from library cache


Db applications

  • HDB Epics

    • DB, status: in use

    • HDB Batch Utilities, status: in use

    • WebHDB status: in use

  • RUNS

    • DB, status: in use

    • RunsWWW interface, status: in use

    • RunGrabber status: in use

    • RunPusher status: in use

  • Transfer calibration data from online DB to offline DB

    • onl_calDbTransfer, status: in use

  • Calibration/Electronic DB

    • CAL_CALIB, on d0onprd

    • SMT_CALIB, on d0onprd

    • CFT_CALIB, on d0onprd

    • MUO_CALIB, on d0on

  • FPD_ONL , status: in use on d0on

  • Luminosity DB

    • DB, status: schema ready

    • LumReader, status: under development

    • LumPusher, status: under development

  • SMT_MONITORING, status: under development

  • EPICS_ARCHIVING, status: under development

DB Applications


  • Login