Oracle-L: performance issues on sun

From: <babu.nagarajan_at_Cummins.com>
Date: Tue, 25 Feb 2003 06:11:09 -0800
Message-ID: <F001.00558696.20030225061109@fatcity.com>

All

We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues.

I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take < 20 min on T64.

I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES. The index tablespace and the temporary tablespace are on separate mountpoints which reside on separate disks.

I am doing a "truss" on the session and see that its doing the following

kaio(AIOWAIT, 0xFFFFFFFFFFFFFFFF)               Err#22 EINVAL
pread(364, "\b02\0\0\v\099E1 f h ECB".., 1048576, 0x26784000) = 1048576
kaio(AIOWAIT, 0xFFFFFFFFFFFFFFFF)               Err#22 EINVAL

lwp_cond_wait(0xFFFFFFFF7CED7F70, 0xFFFFFFFF7CED7F80, 0x00000000) = 0

pwrite(408, "0602\0\0\nC41007 f h SDD".., 49152, 0x10401C000) = 49152
pwrite(408, "0602\0\0\nC410\n f h SDD".., 49152, 0x104028000) = 49152
pwrite(408, "0602\0\0\nC410\r f h SDD".., 49152, 0x104034000) = 49152
pwrite(408, "0602\0\0\nC41010 f h SDD".., 49152, 0x104040000) = 49152
pwrite(408, "0602\0\0\nC41013 f h SDD".., 49152, 0x10404C000) = 49152
pwrite(408, "0602\0\0\nC41016 f h SDD".., 49152, 0x104058000) = 49152
pwrite(408, "0602\0\0\nC41019 f h SDD".., 49152, 0x104064000) = 49152
pwrite(408, "0602\0\0\nC4101C f h SDD".., 49152, 0x104070000) = 49152
pwrite(408, "0602\0\0\nC4101F f h SDD".., 49152, 0x10407C000) = 49152
pwrite(408, "0602\0\0\nC410 " f h SDD".., 49152, 0x104088000) = 49152
pwrite(408, "0602\0\0\nC410 % f h SDD".., 49152, 0x104094000) = 49152
pwrite(408, "0602\0\0\nC410 ( f h SDD".., 49152, 0x1040A0000) = 49152
pwrite(408, "0602\0\0\nC410 + f h SDD".., 49152, 0x1040AC000) = 49152
pwrite(408, "0602\0\0\nC410 . f h SDD".., 49152, 0x1040B8000) = 49152
pwrite(408, "0602\0\0\nC410 1 f h SDD".., 49152, 0x1040C4000) = 49152
pwrite(408, "0602\0\0\nC410 4 f h SDD".., 49152, 0x1040D0000) = 49152
fdsync(408, O_RDONLY|O_SYNC)                    = 0
pwrite(408, "0602\0\0\nC410 7 f h SDE".., 49152, 0x1040DC000) = 49152
pwrite(408, "0602\0\0\nC410 : f h SDE".., 49152, 0x1040E8000) = 49152
pwrite(408, "0602\0\0\nC410 = f h SDE".., 49152, 0x1040F4000) = 49152
pwrite(408, "0602\0\0\nC410 @ f h SDE".., 49152, 0x104100000) = 49152
pwrite(408, "0602\0\0\nC410 C f h SDE".., 49152, 0x10410C000) = 49152
lwp_cond_wait(0xFFFFFFFF7CF0DF70, 0xFFFFFFFF7CF0DF80, 0x00000000) = 0
lwp_cond_signal(0xFFFFFFFF7CF0DF70)             = 0

pread(364, "\b02\0\0\v\09A ! f h ECB".., 16384, 0x26884000) = 16384

I think it is trying to do a KAIO call and failing. Then it attempts a synchronous PWRITE call.

But our SAs are not able to help us to confirm this. Have any of you seen this issue?

Any inputs would be greatly appreciated. I'll gladly provide you with addl info if you need.

Thanks in advance

Babu

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). Received on Tue Feb 25 2003 - 08:11:09 CST