Re: solaris device to oracle datafile

  • From: Nassyam Basha <nassyambasha@xxxxxxxxx>
  • To: kp0773@xxxxxxxxx
  • Date: Mon, 25 Feb 2013 21:21:54 -0500

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


Other related posts: