Re: solaris device to oracle datafile

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Mon, 25 Feb 2013 21:21:54 -0500
Message-ID: <CAABGLuJY6oFYte43cUu7=r_q2npWwBU-vooVQQA7CaN1S5_mWA_at_mail.gmail.com>

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_at_oracle-ckpt> df -h /u03

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/vgemc5-lvu03

                      1.5T  904G  499G  65% /u03

oracle_at_oracle-ckpt>

Step 3:-
From root user, run "pvscan" command

[root_at_oracle-ckpt ~]# pvscan |grep vgemc5

  PV /dev/emcpowere1 VG vgemc5 lvm2 [1.47 TB / 0 free]

[root_at_oracle-ckpt ~]#

Step 4:- use "powermt" command to check I/O paths.

[root_at_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_at_oracle-ckpt ~]#

Step 5:- As usual use "iostat" command to check

[root_at_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_at_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_at_gmail.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thanks & Regards,
Nassyam Basha.


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 26 2013 - 03:21:54 CET