- Where is the tablespace of the table? Shared disk with temp or index
tablespace?
Its on a different mountpoint (and disk) from the index or the temp
tablespaces
- Check your SORT_AREA_SIZE on both systems.
Its 1 Mb. I have done the tests with as much as 250M but same results
- Do some basic disk I/O tests. On both the Compaq and Solaris, move a
large file from one drive to another, just to see what time it takes. If
the
Solaris system is significantly slower, discuss this with your system
administrators.
If I do a simple cp, I am not able to see any big performance difference
Thanks a lot...
Babu
DENNIS WILLIAMS
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
UCH.COM> cc:
Sent by: Subject: RE: performance issues on sun
[EMAIL PROTECTED]
02/25/03 10:14 AM
Please respond to
ORACLE-L
Babu - I would recommend checking:
- Where is the tablespace of the table? Shared disk with temp or index
tablespace?
- Check your SORT_AREA_SIZE on both systems.
- Do some basic disk I/O tests. On both the Compaq and Solaris, move a
large file from one drive to another, just to see what time it takes. If
the
Solaris system is significantly slower, discuss this with your system
administrators.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, February 25, 2003 8:11 AM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
