# Presentation: 516429

## Online Databases Status	

-  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

- V.Sirotenko, 11/1/2002

## 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

## 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**

## Tablespace size dynamics

## Tablespace size dynamics (2)

## 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

## Performance: d0onprd

- Use Statspack Viewer 8.1.7 to monitor performance, every
- two weeks plots are posted on the web ( Online Computing)

## Performance: d0onprd (2)

## Performance: d0onprd (3)

## 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 (?)