Resume: Oracle 7: any1 using it?

Replies received following a request about sites running Oracle V7 in production. Inquiries include:

• The kind of application
• How big the site is
• What kind of equipement/OS you are using
• What you found specially easy or difficult with V7
• Any tips and tricks?

Information gathered from the Internet, july 28th to august 2nd 1993

I include a summary of meaningfull received answers, please send me any other information you might find usefull.

Client/Server:		SCO Unix
Production since:	april 1993
Task:			migrating V6 applications and writting V7 new programs
			using database triggers.
Inquiry:		- How to manage developement. Who should write database
			  triggers? DBA group or DEV group?
			- How to control access on corporate tables on
			  distributed databases?
Positive:		Database triggers are great
Negative:		Database administration is not easy.
Bugs/Problems:		There seems to be some bugs with the tools on MS-DOS
			in client-server
Contact:		Jean-Marc Boivin, jmboivin_at_cti.ulaval.ca
			Computer Analyst
			Laval University, Quebec, Quebec
			Voice: (418) 656-3632


------------------------



Client/Server:		VAX/VMS
Production since:	first week of May 1993
Task:			College administrative applications: Financial Aid and
			Computer Store, Computing Center internal applications:
			Project Tracking, Data Dictionary
Comment:		Small site
Contact:		J.Amon bamon_at_ocvaxc.cc.oberlin.edu


------------------------



Client/Server:		VAX/VMS, MS-DOS and MS-Windows, Sun/Unix
Production since:	
Task:			Development shop migrating applications from V5 and
			developping new ones.
Bugs/problems:		None!
Comment:		Big site, many employees, hundrer of hosts, several db
			instances
Contact:		Dave Mausner dlogics!dlm_at_uu.psi.com
			Sr Consultant, Datalogics division of Frame Technology


------------------------



Client/Server:		Network of Sun Sparcstation 10 / Model 51
Production since:	3rd week of july
Task:			Migrating application from V6
			Telemarketing Real Estate, 100k transaction per day
Positive:		Converted to V7 within a month
Comment:		20 users, 10 batch jobs, 2 programmers
Contact:		"Please do not use our name or company"...


------------------------



Client/Server:		Unknown
Production since:	still waiting...
Task:			Migrate 2 databases from V6: one 15Gb and one 7Gb
Comment:		Posted an inquiry about V7 several months ago and
			received no answer...
Contact:		Cindy Mumford cindy_at_dataprompt.com


------------------------



Client/Server:		Unknown
Production since:	still waiting...
Task:			Migrate from V6 and create new applications using
			propietary interface (i.e. not SQL*Forms).
Contact:		David Thornewill von Essen ttg242_at_newton.sps.mot.com
			Motorola ASIC Division

--
---

 Stephane Hamel, Sysadmin *.mais.hydro.qc.ca  Hydro-Quebec TDSB, Montreal, Quebec
 E-mail: shamel_at_mais.yydro.qc.ca Voice: (514) 858-7882 Received on Mon Aug 02 1993 - 15:55:17 CEST