« Technical Interview & Viva Questions : KyaPoocha.com home page
« How will you estimate the space required by non-clustered tables?
What is a control file? »



Is it possible to use raw devices as data file 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 kernal while writing into disk.
Disk Corruption will be very less.



Explore posts in the same categories: SQL Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • How are devices represented in UNIX?
    • All devices are represented by files called special files that are locatedĀ in/dev directory. Thus, device files and other files...
  • Differentiate between .ear, .jar and .war files.
    • These files are simply zipped file using java jar tool. These files are created for different purposes. Here is the...
  • What is ‘inode’?
    • All UNIX files have its description stored in a structure called 'inode'. The inode contains info about the file-size, its...
  • What is the different between GUI map and GUI map files?
    • The GUI map is actually the sum of one or more GUI map files. There are two modes for organizing...
  • What is the difference between the File and RandomAccessFile classes?
    • The File class encapsulates the files and directories of the local file system. The RandomAccessFile class provides the methods needed...
  • What is the difference between the File and RandomAccessFile classes?
    • The File class encapsulates the files and directories of the local file system. The RandomAccessFile class provides the methods needed...
  • What is a Jar file?
    • Jar file allows to efficiently deploying a set of classes and their associated resources. The elements in a jar file...
  • What is the purpose of the File class?
    • The File class is used to create objects that provide access to the files and directories of a local file...
  • What are the characteristics of data files ?
    • A data file can be associated with only one database. Once created a data file can't change size. One or...
  • What is EJB client JAR file?
    • An EJB client JAR file is an optional JAR file that can contain all the class files that a client...

    Comments are closed.