RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration
maxservers Already to a High Value i.e. 400 as can be seen below . %wio nevertheless Continues to be about 40-45% After applying the patch 8.1.7.4 , I shall Let you folks know about the %wio Figure NOTE - cpu_count = 18 Async_io: lsattr -E -l aio0 minservers 10MINIMUM number of serversTrue maxservers 400 MAXIMUM number of serversTrue maxreqs16384 Maximum number of REQUESTS True kprocprio 39Server PRIORITY True autoconfig available STATE to be configured at system restart True fastpath enableState of fast path True Paging Daemon : maxperm=40.0% of real memory minperm=20.0% of real memory Thanks indeed though for the advice -Original Message- Sent: Thursday, July 11, 2002 7:38 PM To: Multiple recipients of list ORACLE-L "The fsync() blocks the process until all the dirty pages are written to the physical disks" - maybe this is a problem with async i/o ? How many async i/o servers are configured on the AIX box (use "smitty aio" to check). As a start point set to the maximum to Number of CPU's * 10 and set the min to half the max. Just a thought... Ade -Original Message- Sent: Wednesday, July 10, 2002 8:49 PM To: LazyDBA.com Discussion After migration from Oracle ver 7.3.4 to 8.1.7.2 (32-bit) , %wio (%iowait) on Database Machine Exceedingly High i.e. about 60 % . NOTE - This is a Live Production Site . AIX 4.3.3 Storage Box = SSA Class Storage (7133-D40 Model) Machine S85 P-Series Application - Banking (Hybrid) SAMPLE Output Below %iowait = 60.5 % - (Detailed Output file Attached ) tty: tin tout avg-cpu: % user% sys % idle% iowait 1.2 10.0 8.9 21.88.9 60.5 Disks:% tm_act Kbps tpsKb_read Kb_wrtn hdisk0 0.7 4.0 0.8 0 240 hdisk1 1.1 5.8 1.0 12 336 hdisk3 0.0 0.0 0.0 0 0 hdisk9 0.0 0.0 0.0 0 0 hdisk6 0.0 0.0 0.0 0 0 hdisk2 1.0 4.0 0.8 0 240 hdisk4 0.0 0.0 0.0 0 0 hdisk5 0.0 0.0 0.0 0 0 hdisk11 80.4 449.1 66.6 22292 4656 hdisk7 91.0 964.4 145.9 37868 19996 hdisk10 65.5 491.5 78.4 22916 6576 hdisk13 95.5 914.3 127.2 25656 29200 hdisk14 93.5 869.1 129.5 22824 29320 hdisk15 97.9 960.8 152.6 35620 22028 hdisk16 98.4 1382.8 174.7 53112 29856 hdisk8 75.0 802.9 119.4 40816 7360 cd0 0.0 0.0 0.0 0 0 COMMENTS of Hardware Engineer :- === >From the perfpmr data collected on July 5th and it has been analysed by our Labs. The performance degradation is caused by fsync() routines called by Oracle processes. In 5 secs trace, fsync was called 276 times and consumed 21.39% CPU system time. The fsync() blocks the process until all the dirty pages are written to the physical disks. We checked the old perfpmr data collected with Oracle 7.3.4.5, it doesn't have this issue. Oracle has a fix to address the fsync problem on 8.1.7.2 (64-Bit) & 8.1.7.4 (32-Bit). - WE HAVE INITIATED WITH ORACLE CORP FOR A PATCH ON 8.1.7.2 32-BIT. Nevertheless Any Other Ideas just in case the Patch Does NOT bring Down the %wio Enough ? NOTE - High %wio has been Observed only on AIX O.S. (NOT Other O.S.) post migration to Oracle 8.1.7.2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration
"The fsync() blocks the process until all the dirty pages are written to the physical disks" - maybe this is a problem with async i/o ? How many async i/o servers are configured on the AIX box (use "smitty aio" to check). As a start point set to the maximum to Number of CPU's * 10 and set the min to half the max. Just a thought... Ade -Original Message- Sent: Wednesday, July 10, 2002 8:49 PM To: LazyDBA.com Discussion After migration from Oracle ver 7.3.4 to 8.1.7.2 (32-bit) , %wio (%iowait) on Database Machine Exceedingly High i.e. about 60 % . NOTE - This is a Live Production Site . AIX 4.3.3 Storage Box = SSA Class Storage (7133-D40 Model) Machine S85 P-Series Application - Banking (Hybrid) SAMPLE Output Below %iowait = 60.5 % - (Detailed Output file Attached ) tty: tin tout avg-cpu: % user% sys % idle% iowait 1.2 10.0 8.9 21.88.9 60.5 Disks:% tm_act Kbps tpsKb_read Kb_wrtn hdisk0 0.7 4.0 0.8 0 240 hdisk1 1.1 5.8 1.0 12 336 hdisk3 0.0 0.0 0.0 0 0 hdisk9 0.0 0.0 0.0 0 0 hdisk6 0.0 0.0 0.0 0 0 hdisk2 1.0 4.0 0.8 0 240 hdisk4 0.0 0.0 0.0 0 0 hdisk5 0.0 0.0 0.0 0 0 hdisk11 80.4 449.1 66.6 22292 4656 hdisk7 91.0 964.4 145.9 37868 19996 hdisk10 65.5 491.5 78.4 22916 6576 hdisk13 95.5 914.3 127.2 25656 29200 hdisk14 93.5 869.1 129.5 22824 29320 hdisk15 97.9 960.8 152.6 35620 22028 hdisk16 98.4 1382.8 174.7 53112 29856 hdisk8 75.0 802.9 119.4 40816 7360 cd0 0.0 0.0 0.0 0 0 COMMENTS of Hardware Engineer :- === >From the perfpmr data collected on July 5th and it has been analysed by our Labs. The performance degradation is caused by fsync() routines called by Oracle processes. In 5 secs trace, fsync was called 276 times and consumed 21.39% CPU system time. The fsync() blocks the process until all the dirty pages are written to the physical disks. We checked the old perfpmr data collected with Oracle 7.3.4.5, it doesn't have this issue. Oracle has a fix to address the fsync problem on 8.1.7.2 (64-Bit) & 8.1.7.4 (32-Bit). - WE HAVE INITIATED WITH ORACLE CORP FOR A PATCH ON 8.1.7.2 32-BIT. Nevertheless Any Other Ideas just in case the Patch Does NOT bring Down the %wio Enough ? NOTE - High %wio has been Observed only on AIX O.S. (NOT Other O.S.) post migration to Oracle 8.1.7.2 Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAI
RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration
We are Considering Upgrading from 8.1.7.2 to 8.1.7.4 on AIX 4.3.3 Any Do's,Cares to be Taken ? Any Advice / Serious Bugs known on this Patch Version ? Thanks -Original Message- Sent: Wednesday, July 10, 2002 8:49 PM To: LazyDBA.com Discussion After migration from Oracle ver 7.3.4 to 8.1.7.2 (32-bit) , %wio (%iowait) on Database Machine Exceedingly High i.e. about 60 % . NOTE - This is a Live Production Site . AIX 4.3.3 Storage Box = SSA Class Storage (7133-D40 Model) Machine S85 P-Series Application - Banking (Hybrid) SAMPLE Output Below %iowait = 60.5 % - (Detailed Output file Attached ) tty: tin tout avg-cpu: % user% sys % idle% iowait 1.2 10.0 8.9 21.88.9 60.5 Disks:% tm_act Kbps tpsKb_read Kb_wrtn hdisk0 0.7 4.0 0.8 0 240 hdisk1 1.1 5.8 1.0 12 336 hdisk3 0.0 0.0 0.0 0 0 hdisk9 0.0 0.0 0.0 0 0 hdisk6 0.0 0.0 0.0 0 0 hdisk2 1.0 4.0 0.8 0 240 hdisk4 0.0 0.0 0.0 0 0 hdisk5 0.0 0.0 0.0 0 0 hdisk11 80.4 449.1 66.6 22292 4656 hdisk7 91.0 964.4 145.9 37868 19996 hdisk10 65.5 491.5 78.4 22916 6576 hdisk13 95.5 914.3 127.2 25656 29200 hdisk14 93.5 869.1 129.5 22824 29320 hdisk15 97.9 960.8 152.6 35620 22028 hdisk16 98.4 1382.8 174.7 53112 29856 hdisk8 75.0 802.9 119.4 40816 7360 cd0 0.0 0.0 0.0 0 0 COMMENTS of Hardware Engineer :- === >From the perfpmr data collected on July 5th and it has been analysed by our Labs. The performance degradation is caused by fsync() routines called by Oracle processes. In 5 secs trace, fsync was called 276 times and consumed 21.39% CPU system time. The fsync() blocks the process until all the dirty pages are written to the physical disks. We checked the old perfpmr data collected with Oracle 7.3.4.5, it doesn't have this issue. Oracle has a fix to address the fsync problem on 8.1.7.2 (64-Bit) & 8.1.7.4 (32-Bit). - WE HAVE INITIATED WITH ORACLE CORP FOR A PATCH ON 8.1.7.2 32-BIT. Nevertheless Any Other Ideas just in case the Patch Does NOT bring Down the %wio Enough ? NOTE - High %wio has been Observed only on AIX O.S. (NOT Other O.S.) post migration to Oracle 8.1.7.2 Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: High %wio on AIX O.S. DB Server after Oracle 8i Migration
1) use raw disk 2) use Veritas Quick IO Jared "VIVEK_SHARMA" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/10/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:High %wio on AIX O.S. DB Server after Oracle 8i Migration After migration from Oracle ver 7.3.4 to 8.1.7.2 (32-bit) , %wio (%iowait) on Database Machine Exceedingly High i.e. about 60 % . NOTE - This is a Live Production Site . AIX 4.3.3 Storage Box = SSA Class Storage (7133-D40 Model) Machine S85 P-Series Application - Banking (Hybrid) SAMPLE Output Below %iowait = 60.5 % - (Detailed Output file Attached ) tty: tin tout avg-cpu: % user% sys % idle% iowait 1.2 10.0 8.9 21.88.9 60.5 Disks:% tm_act Kbps tpsKb_read Kb_wrtn hdisk0 0.7 4.0 0.8 0 240 hdisk1 1.1 5.8 1.0 12 336 hdisk3 0.0 0.0 0.0 0 0 hdisk9 0.0 0.0 0.0 0 0 hdisk6 0.0 0.0 0.0 0 0 hdisk2 1.0 4.0 0.8 0 240 hdisk4 0.0 0.0 0.0 0 0 hdisk5 0.0 0.0 0.0 0 0 hdisk11 80.4 449.1 66.6 22292 4656 hdisk7 91.0 964.4 145.9 37868 19996 hdisk10 65.5 491.5 78.4 22916 6576 hdisk13 95.5 914.3 127.2 25656 29200 hdisk14 93.5 869.1 129.5 22824 29320 hdisk15 97.9 960.8 152.6 35620 22028 hdisk16 98.4 1382.8 174.7 53112 29856 hdisk8 75.0 802.9 119.4 40816 7360 cd0 0.0 0.0 0.0 0 0 COMMENTS of Hardware Engineer :- === >From the perfpmr data collected on July 5th and it has been analysed by our Labs. The performance degradation is caused by fsync() routines called by Oracle processes. In 5 secs trace, fsync was called 276 times and consumed 21.39% CPU system time. The fsync() blocks the process until all the dirty pages are written to the physical disks. We checked the old perfpmr data collected with Oracle 7.3.4.5, it doesn't have this issue. Oracle has a fix to address the fsync problem on 8.1.7.2 (64-Bit) & 8.1.7.4 (32-Bit). - WE HAVE INITIATED WITH ORACLE CORP FOR A PATCH ON 8.1.7.2 32-BIT. Nevertheless Any Other Ideas just in case the Patch Does NOT bring Down the %wio Enough ? NOTE - High %wio has been Observed only on AIX O.S. (NOT Other O.S.) post migration to Oracle 8.1.7.2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).