Online databases s krzywdzinski v sirotenko february 14 2002
Download
1 / 3

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


  • 61 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

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


ad
  • Login