Questions about optical disks with database servers

From: Linda A. Hutt <lhutt_at_relay.nswc.navy.mil>
Date: Mon, 25 Jul 1994 18:11:35 GMT
Message-ID: <1994Jul25.181135.16978_at_newserver.uucp>


My organization supports an Oracle database that resides on a CDC 4680. The CDC 4680 Operating System is EP/IX 2.1.1AB, and the Oracle Release is 7.0.12.2.0. Our database is currently 7 Gb and will be growing to 40 Gb over the next three years. As the database grows, we are looking for ways that we can move some data that is only occasionally accessed to higher volume, less costly storage devices than our internal disk drives. However, we do not want to move these files to a backup media where we will have to restore them to disk when the data is needed again.

I have been reading about optical disks and related software, and this looks like it might be one solution. It sounds like the optical disks can be configured to look like Unix filesystems. If this is the case, I would like to keep a separate live database on the optical disks and store the less frequently accessed data in that database. I am not too concerned about lower performance when referencing data from optical disk, but would like an idea of performance issues associated with doing this with an Oracle database since the related database files can be rather large.

I am interested in knowing if anyone else has tried to do something similar. Your suggestions or lessons learned are welcome. Also, we are most interested in products that are on GSA. Linda Hutt
lhutt_at_relay.nswc.navy.mil Received on Mon Jul 25 1994 - 20:11:35 CEST

Original text of this message