It is possible to use raw devices as data files and what are the advantages over file system files

  • Interview Candidate
  • 3
  • 2440

Showing Answers 1 - 3 of 3 Answers

simakas

  • Oct 9th, 2007
 

Yes. Using raw files/devices for database can have a slight performance gain. Raw files are unformatted disk partitions that can be used as one large file. Raw devices have the benefit of no file system overhead, because they are unformatted partitions. To Oracle Database, raw files are no different from other Oracle Database files. They are treated in the same way by Oracle Database as any other file and can be backed up and restored through RMAN.
For raw devices use LVM in OS level, or Oracle ASM.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions