Re: Raw vs filesystem for database tablespaces

From: Todd Richmond <todd_at_storm01.aadt.com>
Date: Mon, 4 Oct 1993 19:23:37 GMT
Message-ID: <CEE0JD.2yn_at_uunet!aadt>


In article <19931004.110556.660_at_almaden.ibm.com>, alanb_at_vnet.IBM.COM (Alan Beal) writes:
|> Does anyone have any experiences using raw devices for Oracle7?
|> If I disregard performance, is there any reason why I should use
|> a raw device instead of a UNIX file for tablespaces and transaction
|> log files? How does using raw devices impact administration, backup,
|> and recovery? Are there any words of wisdom or rules of thumb in
|> this area? Thanks.
|>
|> Alan Beal alanb_at_vnet.ibm.com
|> (607)751-2026

We have used raw devices for sometime on one of our 7x24 applications. This is with version 7.0.12 on HP. After one year of using raw devices we are going back to filesystems. The reason is that we have seen no performace increase and backups are a pain.

-- 
================================================================
| Todd E. Richmond            |"Kicking and screaming will the |
| American Airlines           | foolish be dragged into the    |
| Decision Technologies, Inc. | 21st century . . ."            |
| E-mail: todd_at_aadt.com       |                                |
| Voice:  817-967-1872        |                                |
================================================================
Received on Mon Oct 04 1993 - 20:23:37 CET

Original text of this message