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

Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk.Disk Corruption will be very less.

Interview Candidate
Sep 6th, 2004
3
2095

Memory Management

Answer

Showing Answers 1 - 3 of 3 Answers

prashatt
Profile Answers by prashatt

Jun 24th, 2008

Raw devices are controlled by the database engine so the OS kernel can be bypassed when using raw devices. System files reside on filesystem, filesystem is addressed by the kernel. So everytime a database request comes the kernel handles the request to fetch data from the system file. The kernel activities are done directly by the database engine in raw devices.