You can obtain and display information about Quick I/O status and file attributes using various options of the ls command:
To list all files on the current file system, including Quick I/O files and their links
$ ls -al filename .filename
The following example shows how to use the -a option to display the absolute path name created using qiomkfile:
$ ls -la /snap_data11r2/FLAS11r2/.qfile01.dbf /snap_data11r2/FLAS11r2/qfile01.dbf lrwxrwxrwx 1 ora11gr2 dba 24 Jul 15 03:27 /snap_data11r2/FLAS11r2/.qfile01.dbf -> \ .qfile01.dbf::cdev:vxfs: lrwxrwxrwx 1 ora11gr2 dba 48 Jul 15 05:17 /snap_data11r2/FLAS11r2/qfile01.dbf -> \ /snap_data11r2/FLAS11r2/.qfile01.dbf::cdev:vxfs:
To determine if an Oracle datafile has been converted to Quick I/O
$ ls -lL filename
The following example shows how to determine if Quick I/O is installed and enabled:
$ ls -lL dbfile
crw-r--r-- 1 oracle dba 45, 1 Oct 2 13:42 dbfile
For AIX:
where the first character, c, indicates it is a raw character device file, and the major and minor device numbers are displayed in the size field. If you see a No such file or directory message, Quick I/O did not install properly or does not have a valid license key.
To show a Quick I/O file resolved to a raw device
$ ls -alL filename .filename
The following example shows how the Quick I/O file name dbfile is resolved to that of a raw device:
For AIX:
crw-r--r-- 1 oracle dba 45, 1 Oct 2 13:42 dbfile
$ ls -alL d* .d*
For Solaris:
crw-r--r-- 1 oracle dba 45, 1 Oct 2 13:42 dbfile