Oracle-L: RE: direct path read waits

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 20 Feb 2003 19:14:03 -0800
Message-ID: <F001.00553D5A.20030220191403@fatcity.com>

Get with your SAs and ask them to track the device names (/dev/dsk/xxxxx or /dev/hdiskXXXX) from file systems (logical volumes), all the way to the disk array. You will find your problem.

Kirti

-----Original Message-----
Sent: Thursday, February 20, 2003 4:43 PM To: Multiple recipients of list ORACLE-L

We actually had lengthy discussions with our SAs and convinced them that we need different mountpoints on different disks. We have our SA's guarantee that no physical disk is used by the two mountpoints...

Will try to get a "sar -d" output from them..

Babu

                                                                                                                                                    
                      John Kanagaraj                                                                                                                
                      <john.kanagaraj_at_h        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                
                      ds.com>                  cc:                                                                                                  
                      Sent by:                 Subject:  RE: direct path read waits                                                                 
                      root_at_fatcity.com                                                                                                              
                                                                                                                                                    
                                                                                                                                                    
                      02/20/03 04:45 PM                                                                                                             
                      Please respond to                                                                                                             
                      ORACLE-L

Babu,
You:
> All the tablespaces are on different disks - Sorry I should
> have mentioned
> this in the original post itself...

Me:
> Your answer was buried in the question itself. If the TEMP
> tablespace had to contend with Tablespace C on the same 'disk' then such
a
result is
> expected.

Note that I enclosed the 'disk' above within quotes. Different filesystems and mount points does not necessarily mean much in these days where a single
storage array may be shared among multiple servers. As long as you are not using JBODs, i.e. you are on a SAN/NAS, there is no physical guarantee that the disks are where they purport to be. Can your SA verify that these 'disks' are actually different? A 'sar -d' during that period may reveal some interesting results.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointment is inevitable, but Discouragement is optional!

The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: babu.nagarajan_at_Cummins.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 20 2003 - 21:14:03 CST