Kart, Check the below step by step to find out the devices of the datafiles where it is placed. Step 1:- In My environment, Data files situated at "/u03" mount point. NAME -------------------------------------------------------------------------------- /u03/oradata/mydb/hrapp_tde.dbf /u03/oradata/mydb/poapp_tde.dbf /u03/oradata/mydb/polarge_tde.dbf /u03/oradata/mydb/psindex_tde_01.dbf Step 2:- From OS, give below command using the mount point. oracle@oracle-ckpt> df -h /u03 Filesystem Size Used Avail Use% Mounted on /dev/mapper/vgemc5-lvu03 1.5T 904G 499G 65% /u03 oracle@oracle-ckpt> Step 3:- From root user, run "pvscan" command [root@oracle-ckpt ~]# pvscan |grep vgemc5 PV /dev/emcpowere1 VG vgemc5 lvm2 [1.47 TB / 0 free] [root@oracle-ckpt ~]# Step 4:- use "powermt" command to check I/O paths. [root@oracle-ckpt ~]# powermt display dev=emcpowere Pseudo name=emcpowere Symmetrix ID=000192602126 Logical device ID=2DE9 state=alive; policy=SymmOpt; priority=0; queued-IOs=0 ============================================================================== ---------------- Host --------------- - Stor - -- I/O Path - -- Stats --- ### HW Path I/O Paths Interf. Mode State Q-IOs Errors ============================================================================== 3 qla2xxx sdi FA 9fB active alive 0 0 2 qla2xxx sdl FA 8fB active alive 0 0 [root@oracle-ckpt ~]# Step 5:- As usual use "iostat" command to check [root@oracle-ckpt ~]# iostat -xn |egrep 'sdi|sdl' -x and -n options are mutually exclusive Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sdi 0.00 0.00 0.00 0.00 0.00 0.00 21.65 0.00 0.57 0.57 0.00 sdi1 0.00 0.00 0.00 0.00 0.00 0.00 10.75 0.00 0.19 0.19 0.00 sdl 0.00 0.00 0.00 0.00 0.00 0.00 21.36 0.00 0.69 0.68 0.00 sdl1 0.00 0.00 0.00 0.00 0.00 0.00 10.75 0.00 1.25 1.25 0.00 [root@oracle-ckpt ~]# From "iostat" command you can see the variance between sdi & sdl devices. If you found any thing weird statistics, Then we can assign to Storage team. :-) Hope this helps. Thanks & Regards, Nassyam Basha. www.oracle-ckpt.com On Mon, Feb 25, 2013 at 7:54 PM, K R <kp0773@xxxxxxxxx> wrote: > All, > I am observing one of the device doing high i/o . is there a way > where i can map to which oracle datafile is on this device . > > appreciate any suggestions > > thanks > Kart > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Thanks & Regards, Nassyam Basha. -- //www.freelists.org/webpage/oracle-l