1 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Contents
1. Windows 7 vs Windows XP Windows 7 Windows XP Employee FF 64 Self Service Bytes Packets ime jte View Payslip 0 77 93 282 94 0 90 93 991 F 98 380 97 0 93 96 960 Order FF Management Bytes Packets 2S sales Orders 11 0 236 900 369 9 2 237 395 9 4 238 900 36 7 7 9 238 086 ORACLE 14 Copyright 2012 Oracle and or its affiliates All rights reserved Client Tuning Multiple Java Issue The application requires an earlier version of Java Do you want to continue Occurs when you have the version called by the EBS Web Server And a later JRE Huge number of numbe of applications turns chatty Refer to Deploying Sun JRE Native Plug in R12 Doc ID 393931 1 111 Doc ID 290807 1 ORACLE Client Tuning Browsers e Have as many HTML based screens open as you like e Only IE allows multiple Forms sessions e g PO and GL open at the same time or even 11i and R12 E 1 cookie per browser session FF 1 cookie per desktop Important for productivity and saves mixing menus e Multiple sessions dont work in IE8 Used to be able to use new browser sessions C Program Files Internet Explorer iexplore exe noframemerging Mozilla offers an Extended Support Release ESR https wiki mozilla org Enterprise Firefox ExtendedSupport Proposal ORACLE 16 Copyright 2012 Oracle and or its affiliates All rights re2. E Limit each packet to 65535 bytes Buffer size 1 z megabyte s Capture Filter host1921681 3 Compile BPF Capture File s Display Options File V Update list of packets in real time T Use multiple files V Automatic scrolling in live capture Next file every 1 megabyte s Next file every 1 Iiminutels 7 Hide capture info dialog Ring buffer with 2 files Name Resolution Stop capture after 1 file s 7 Enable MAC name resolution Stop Capture r E after s H packetis Enable network name resolution C after 1 gt megabyte s 7 P5 V Enable transport name resolution after 1 minutefs 33 Copyright 2012 Oracle and or its affiliates All rights reserved aa aa aaxeea veroFs QQQH FUBx B Websit zy Website Visit the project s website t5 User s Guide The User s Guide local version if installed di Security Work with Wireshark as securely as possible Profile Default nl ORACLE Wireshark PO defaulted Uniconize ines Save Approve 4 Go Capture Analyze Statistics Telephony Baxz summary or Name Size Date modified more an alysis PO defaulted Uniconize Enter 5 lines Save 65KB 14 03 2012 20 51 m Fille name Transaction Part Not closing Forms PO defau Save as type Wireshark Acpdump libpcap pcap cap 2
3. 1 rm gt xK AA o o LL H E a E F lag oO g 9 o o oO s 2972 22555 gt Suu o gt gt omes EE I oM Soz 2 2 8 Val ey E AH EN c Oo D gt e D o Put o E o lt x v oj amp ao o O xe c 19 o o 190 joa O el T N B en o rum gt Q O O N T 30 25 20 15 10 5 0 spuooes T g dijsheg MoIA 991499 JIS J E U G G Jd O O oT uojsiH uonoeJoju 40u0 n2 u ye 0 i Jaju99 usea Wo 4 Sjuo waah y Buoyjny sj2e4 uo 991199 2e ju02 uoune Buuoun y sj2e4 u0 991199 ysonboy 9914 99 93299 quo uoeDeue N sowojsng WJO J 93499 263002 uouaqy1o M Aug 19pJQ9 s3509 waji uojuoAu uouaqy1oM 12ofoJg sjeuunof Ja6pa7 jessues rT C u9uaqu10M Jap4Q eseuoJng Minbuj uoueqy1o0 M 9310AU So qe ed D Y Tv nua esf odng juoweBbeuey apio nue sobeuey uonnqisig pue Bulsnyoesnueyy nua quo uoDeue N Joss y osuud1o u3 ing t Tun Memory Utilization Comparing Memory WS for Oracle E Business Suite Releases 11 and 12 nuaw sojqe eg nua urew u99J2g uiBo7 len josyo 10sMog O D 28 DD oO Co Q G aw Howay Oo D gt e D o Put o E o lt v oj amp ao o O xe c 19 o o 190 joa O el N B en o rum gt Q O O op T
4. Past 7 Days v Global v Optimized v Bi Directional Off Port Reduction LAN Data WAN Data Traffic Total Optimized Traffic 46 2 TB 13 2 TB 80 HTTP 83 15 7 TB 6444 0 GB 33 91 445 CIFS TCP Ga 80 99 5462 0 GB 1038 6 GB 11 54 21 FTP f 54 09 3260 3 GB 1496 9 GB 6 89 10566 SnapMirror Gam 1 86 87 2856 1 GB 375 1 GB 6 04 139 CIFS NetBIOS period recom 873 rsync Past 7 Days v Global 443 SSL 68 Copyright 2012 Oracle and or its affiliates All rights reserved C 23 0 0094 Type 2050 FlexCache Port LAN Data 8080 webcache Total Passthrough Traffic C 3X0 0096 50 5 TB NC 0 00 10 5 TB 2049 NFS C 31 0 0094 7256 3 GB 22 ssh c K0 00 7116 4 GB 25 smtp C 3X 0 009 4434 1 GB 2003 2 GB Traffifs Pass Through Bi Directional WAN Data 50 5 TB 10 5 TB 7256 3 GB 7116 4 GB 4434 1 GB 2003 2 GB Go Uncompressed Refresh Off v Go Traffic Yo 20 75 14 02 13 75 8 57 3 87 ORACLE Problem Definition Baseline now e Current Performance Profile the network from remote users ping amp network screen ime a few repeatable critical transactions Obtain a clear definition of the problem e Analyze ime related problem s performance bad all the time When is it better or worse Location related problem e Identify network devices pr
5. Oracle and or its affiliates All rights reserved Network Concepts Manual Oracle E Business Suite works very well with average latencies up to 300ms and is usually found to give acceptable performance with latencies up to 500ms Note that periods when forms are being loaded for example on startup may be an issue in cases where latency is marginal A consequence of this is that the newer HTML based Applications which do not use Forms may give better performance than the traditional Forms based Applications ORACLE Network USA y M 4 Vancouver i j This diagram shows the performance on our internal dedicated network and not the performance over the Internet between these locations It does not depict the network design the hops or traffic _ j P path sites are connected by many different network access types ry X 155ms Salt Lake 52ms Colorado ORACLE 24 Copyright 2012 Oracle and or its affiliates All rights reserved Network Europe ESTONIA LATVIA LITHUANIA UNITED KINGDOM 2 UITIS BENI London Berlin Barcelona Paris o RN San Fransisco 17 184 200 170 184 300 UKRAINE Austin 130 170 170 140 164 235 40 48 11 di UK Ch amt EGYPT f THE BAHAMAS ORACLE 25 Copyright 2012 Oracle and or its affiliates All rights reserved Network Rest of th UNITES KINGDOM s m Aust
6. Pinging 192 168 808 197 with 32 bytes of data Reply from 192 168 0 197 bytes 32 time lt ims TTL 128 Reply from 192 168 0 197 bytes 32 time lt ims TTL 128 Reply from 192 168 0 19 7 bytes 32 time lt ims TTL 128 Reply from 192 168 0 197 bytes 32 time lt ims TTL 128 Ping statistics for 192 168 8 19 Packets Sent 4 Received 4 Lost z loss Approximate round trip times in milli seconds Minimum ms Maximum ms Average Ams o gt ping 192 168 080 197 Pinging 192 168 6 197 with 32 bytes of data Request timed out Request timed out Reply from 192 168 0 197 bytes 32 time 2417ms TTL 64 Reply from 192 168 0 197 bytes 32 time 1460ms TTL 64 Ping statistics for 192 168 6 197 Packets Sent 4 Received 2 Lost 2 58 loss Approximate round trip times in milli seconds Minimum 1466ms Maximum 2417 ms Average 1938ms GeN gt ping 192 168 0 197 Pinging 192 168 0 19 7 with 32 bytes of data Reply from 192 168 9 197 bytes 32 time 3862ms TTL 128 Reply from 192 168 808 197 bytes 32 time 302ms TTL 128 Reply from 192 168 800 197 bytes 32 time 363ms TTL 128 Reply from 192 168 8 197 bytes 32 time 363ms TTL 128 Ping statistics for 192 168 6 197 Packets Sent 4 Received 4 Lost z loss Approximate round trip times in milli seconds Minimum 382ms Maximum 383ms Average 302ms CEN ithout WANem ANem Stabilizing 150ms Each Way 46 Copyright 2012 Oracle and or i
7. gt Q O O T T o uo Oo 2 8 3 DES nua sejqe eq gt SO 90 m 2 gt gt gt S e o Toes nua ure eC 0 Ww N EH NEN uu cere In mp 3g BI ID GIN Ow DNE WdMI T 7 7 T N N N O55 o m amp usados uiBo1 v SO P 5 e e ce e e e e e e e e e c eo ce LI wT eo Cv v spuooes u uequ10M sjeuur d uteu Ajddns c arts eyeq uM O uouaqy1oM qor 2331951G HM n ORACLE W404 u ueqx1oM a sjeuue d uieu Ajddns 5 103sIHl uon e4e3u Ja u1035n2 1e3ue ulse W404 S3ueuieeJD y Buuoun y s32043u02 e31AJ8 S spenuog youne BULOYINY s3 e3u0 2 39195 ysenbay sas 930812 zua ueBeue Je uo3sn2 493U8 J 1203002 Forms nu3 1ep1o 1502 way 1o3ueAu uonee12 yfodd sjeuinof 1eB pe 7 jeseues u uaqx1oM 48p4Q eseyoing Ambuj u ueqx1o0M 9210AUu se qe ed pacoquseq Jua ueBeue A uoudeje punoquj ens pueoquseq Jua uieBeue A D jue WIN 48 u03sn2 jue wabeucy e uesqy HX Jk x ROM S EU N N A NYA 7 di s e MBA lt PILogyusep sajes OAF HTML Scr uea12s ie3eg Minbuj yess lt uee15S nd Auinbuy jessy ee nua asn dns qua weBbeuey Japo nue JeBeuey uonnquasiq pue Buynjoesnuey ND nue A ua ureBeue A C jess y esuidiejug nua sejqe e d fi dated Jars nue A ute A uals uibo rre sas mosi vu uc 0 X QD o NA o O T gt 7 C gt
8. 21 21 21 21 21 2 2 2 B og 9 8 Wa e Ol File Z __ ATG Webcast GL Socket Serviet Packets 246 Displayed 246 Marked 0 Load time 0 00 015 Profile Default ORACLE 34 Copyright 2012 Oracle and or its affiliates All rights reserved Network Tools Simulating WAN Latency e WANem native or VM http wanem sourceforge net Open Source GNU General Public License Compatibility issues Works on XP VMWare 3 0 Problematic on Win7 VMWare 3 1 3 e Good user manual ORACLE 35 Copyright 2012 Oracle and or its affiliates All rights reserved Network WANem pa kaaa 1073 9 77777 99 Aa aa aa PC Laptop WANem Apps DB Rou PPS Help 192 168 0 10 ORACLE 36 Copyright 2012 Oracle and or its affiliates All rights reserved Client Tuning WANem Home ud WANem v2 1 ud VIS1213 VMware 37 Copyright 2012 Oracle and or its affiliates All rights reserved Welcome to VMware Player Create a New Virtual Machine Create a new virtual machine which will then be added to the top of your library Open a Virtual Machine Open an existing virtual machine which will then be added to the top of your library Upgrade to VMware Workstation Get advanced features such as snapshots record replay teams developer tool integration and more Help View VMware Player s help conte
9. ORACLE Performance Tuning Oracle E Business Suite Part 2 Client and Network Tuning Andy Tremayne Senior Architect Applications Performance Oracle Development Agenda Client Tuning e Network Tuning ORACLE 3 Copyright 2012 Oracle and or its affiliates All rights reserved Client Tuning A Very In Depth Paper Oracle E Business Suite 11i and R12 PC Client Performance whitepaper Doc ID 557259 1 Do need CPU memory or both s alow specification client usable Is there a difference in client requirements between 11i and R12 Plots Self Service screen and Oracle Form opening times Provides network traffic analysis ORACLE Client Tuning Measuring Memory Process Explorer Process Explorer Sysinternals www sysinterne Memory Secs File Options View Process Find DLL Users Help PQ WorkingSet Private Bytes Private Bytes History Peak Working Set WS Private WS Shareable 3600 je adinda oe 30940K 2648K 3 116 K 3856 32 408 K 13 332 K 32612K 11480K 20 928 K 1216 22 508 K 19404 K i 22844K 15392K 7116K 1948 41 140 K 31 272 K 41 324 K 20 534 K WS Total i Mapping WS Private WS Shareable ieapfitr dat Microsoft Phishing Filter Data File f Data OK 2 384 K mshtml dil Microsoft R HTML Viewer Image 2 224 K mesi dii Windows Installer Image 72K ieframe dil D alc Image dd Oshrd dii Browser Add ons ORACLE 5 Copyright 2012 Oracle and or i
10. dth Satellite ORACLE 62 Copyright 2012 Oracle and or its affiliates All rights reserved Satellite GEO vs LEO e GEO 22 400 miles above the equator 89 600 miles for 1 packet and ACK 1 round trip Physics gt 550 ms latency Prone to packet loss due to network interference Higher but more reliable e LEO Tends to lose signal every 5 mins e Especially if not tracking fast enough Not generally used for bulk data continuous signal ORACLE satellite Optimize Everything e What you can control Amount of traffic and compressibility e g XML PDF Set MTU to avoid packet assembly disassembly T CP window size Minimize number of hops firewalls routing Schedule transfers outside peak periods CM delivery options Optimal route land line and one satellite hop vs multi sat sat hops What you can ask for from the vendor Object level caching other acceleration QoS variant HTTP prefetching Bandwidth optimization data deduplication and compression ORACLE Symmetric Network Acceleration Paper R12 Doc ID 967992 1 e Symmetric two compression devices gt Hardware lt gt Hardware or software client ypes of traffic c HTTP S Bulk reports Java Forms TCR e Modes Compression caching pattern matching for deduplication e Does not tend to be a fix all technology Tested using 300ms 1Gbps ORACLE Symmetr
11. es up to 40 less bandwidth than Forms servlet mode e Connection mode Socket Direct socket connection to the Forms Listener process fient verification issues on open metwo outokKor secure networks Se normes Ji gblaerabiedes Wakana wakaaji ctions Protocol hedaekewi lsg eurcnetwork team 111 Doc ID 201340 1 default socket section 6 for dual mode R12 Doc ID 384241 1 default servlet Use SSL with socket in 11i or with servlet in R12 SSL 11 Doc ID 123718 1 R12 Doc ID 376700 1 ORACLE Tuned vs Standard Entry Servlet N B Predicted Tuned 5 Line PO from ice 12 1 3 6u30 servlet 120 100 F sae amp 100Mbps S 1 K K amp 1Mbps z rii Mi gp amp 512Kbps E 40 E g amp 256Kbps 20 i 128Kbps Fi E E x i if i 56 6Kbps amp 100Mbps E 1Mbps i 512Kbps E 256Kbps i 128Kbps i 56 6Kbps T 1 X We 1 100 200 300 400 500 600 700 800 Latency ms ORACLE 57 Copyright 2012 Oracle and or its affiliates All rights reserved Purchase Order 5 line Socket vs Servlet Packets Time Bytes Tuned Socket am J Defaulted Servlet 2z4 Ez Standard Entry Servle 973 155 ET Socket vs Servlet Tuned is more 5995 Suctetininetedu 5 Line Purchase Order Using Defaults efficient than untuned Tuned Defaulted Socket ore 5296 efficient tfan Servlet Socket Defaulted Servl
12. et Defaulted MN Gas yi tf ji 1 Time seconds ORACLE 58 Copyright 2012 Oracle and or its affiliates All rights reserved Self Service View Payslip Employment and Vacation Screens Login 120 View Payslip View Employment Screen 100 View Vacation Logout 3 d amp 100Mbps S 1Mbps 9 60 iM 512Kbps A 40 m amp 256Kbps 20 li 128Kbps O0 T iM 56 6Kbps 1 400 Latency ms ra HN Asin AA d AA IExpenses Login t 180 Enter 3 expense lines and submit ind Logout amp 100Mb 120 p 9 100 tal 1Mbps 80 i 512Kbps 60 E 256Kbps 40 26 iM 128Kbps o WW 56 6Kbps 1 100 200 300 400 500 600 700 800 Latency ms ORACLE 59 Copyright 2012 Oracle and or its affiliates All rights reserved Query PO and GL Journal Confirmed this test using an a E 100Mbps E 1Mbps M 512Kbps E 256Kbps E 128Kbps E 56 6Kbps Latency ms ORACLE VPN Packets Time Bytes Average Worst Case Forms LAN 998 48 620240 Query PO and GL Journal VPN 1119 74 657577 C 6 7 6 e Other Metrics JRE 7 vs JRE 6u31 0 SSL 10 20 Bytes ORACLE 61 Copyright 2012 Oracle and or its affiliates All rights reserved Agenda Client Tuning e Network Tuning Tools Tuning for High Latency Low Bandwi
13. face eth0 a Haud Dy Choose BW Other v Other Specify BW Kbps 0 Delaytime ms 0 Modem 9600 bps Level 1 cable 20 Kbps DS 0 Pulse Code Modulation 64 Kbps hot execute them ISDN 128 Kbps T 1 DS 1 North America 1 544 Mbps E 1 DS 1 Europe 2 048 Mbps us IDS 1c 3 152 Mbps Standard ADSL downstream 6 144 Mbps T 2 DS 2 North America 6 312 Mbps E 2 Europe 8 448 Mbps Thin Ethernet CAT 3 cable 10 Mbps Token ring LAN 16 Mbps CAT 4 cable 20 Mbps E 3 Europe 34 368 Mbps T 3 DS 3 North America 44 736 Mbps OC 1 STS 1 51 84 Mbps CDDI FDDI Fast ethernet 100 Mbps OC 3 STS 3 CAT 5 High speed ADSL downstream 155 52 Mbps OC 9 466 56 Mbps OC 24 1244 Gbps IT e Internet ORACLE 44 Copyright 2012 Oracle and or its affiliates All rights reserved Network Advanced Mode WANEM The Wide Area Network Emulator Windows Internet Explorer go E http 192 168 0 10 WANerm http 4 192 168 0 10 WANem ag I http 4 192 168 0 10 WANem gg x os WANEM The Wide Area Network Emulator fe D EPa Po 2 WANem TATA CONSULTANCY SERVICES The Wide Area Network Emulator Performance Engineering Research Centre Stop WANem Adare ser Appi sana eee ORACLE 45 Copyright 2012 Oracle and or its affiliates All rights reserved Network Checking Latency ca C WINDOWS svstem3 cmd exe GtN gt ping 192 168 909 197
14. gt n mt gt nuaw sejqeAed 2 QR 00 8 re T T N nue uien 2 F m SS x O 2982 z oO a As uea12g uio JesMolg 8 LI Oo o e 9 N spuo2eg u uequioM s1euue d uieu Ajddns arts ezeg uM u ueq 140M qor asig E C C ORACLE W104 uoueqx10M sJeuue d uya Ajddns 5 A03s1H uonoesazuj sawong 1ejue DBursee uo J s3ue waah y Buuotn y s35643u02 adas 5j2t43u0 u une 1 BULIOYIN y SIILJUO 9 ad1Ases ysanbay 391435 332319 yua wabruew sawong au 9 JORJUOD Forms Anuga Japo s1509 waji Mojuaru uonea12 yoaloid sjewinor 4eB pe 7 eje ue c All Clients eS po u ueqx1o0M JepJQ eseyoing Auinbuj u ueqx1o0M amp 21oAu se qe e d paecoquseq jua ueBeue A uotudeje punoqu pacoquseq Jua ueBeue A jue wjn awona N juawaBbeuey asuasqy 2 C C O dijs e q MelA v 2 oO x A UO o wA o S TS gt 2 v 2 gt o bes kwa o v o I EF UT o l pieoqysep sajes OAF HTML Screens uaa12S pezaq Auinbu yess lt x uae15s ng Auinbuy jessy nuaj Jase dedns jus uefeue A Japo nuaj sabeu uonnqisiq pue Guinjoejnue A nuaj ua ue feueh o C ass y esudjeyu3 FNN g dated JARs already used Oo D gt e D o Put o E o lt x v oj amp ao o O xe c 19 o o 190 joa O el T N B en o rum
15. hark Network Analyzer Wiest 165 GN Re 20423 rom riis NN ee File Edit View Go Capture Analyze Statistics Telephony Tools Internals Help at gt TE amp ea eaetmmi x30 v Expression Clear Apply iet Ctri K Ctri E Ctri E Sau lost Popular Network Protocol Analyzer Rev 40429 from trunk 1 6 n pup li Wireshark Capture Filter Profile Default S 9 jme Sm Edit Capture Filter E Interface List Live ist of the capture interfaces Counts incoming packets IP address 192 168 1 3 Start capture on interface Ee Intel R 82577LM Gigabit Network Conne ER Microsoft ER Microsoft nl Capture Options Start a capture with detailed options Capture Help BG How to Capture 1 Ready to load or capture No Packets Profile Default ORACLE 32 Copyright 2012 Oracle and or its affiliates All rights reserved Wireshark uu The Wireshark Network Analyzer Wireshark 1 6 5 SVN Rev 40429 from trunk 1 6 File Edit View Go Capture Analyze Statistics Telephony Tools Internals Help Filter r Pression Clear Appl M were SSO e Capture Interface Local im Intel R 82577LM Gigabit Network Connection Device NPF_ 1D00 IP address 192 168 1 2 Link layer headertype Ethernet Wireless Settings V Capture packets in promiscuous mode 5 n Remote 5ettings Capture packets in pcap ng format
16. his Test Scenario Below the minimum 366MHz Pentium II Equal to the 700MHz Pentium III um Oracle minimum 1 6GHz Pentium l Nearest to 1 8GHz T2400 Mobile Core Duo Recommended Most have at least this spec ORACLE 9 Copyright 2012 Oracle and or its affiliates All rights reserved yousqyioy SJeuue d uieu fiddng amp exa WIM CO uoueqy1oM qof 33193 JIM woy YOUAqYJONA sjeuue d ureu Ajddng 5 ORACLE KOSIH UO12J9 U awong Joju99 Duisee1 O Y C oO lt 2 D e gt gt woy sjueujee1by Buuotpny senu eai es sjoejuo youne Buuotpny sj2e11u0 991495 jsenbe 991498 9 2919 jueureDeue Jawojsni J9 U99 9e u0 y Previous Forms Anuz Japio Convergence S0 waji 40 ueAu uneasy yal01g sjeuinor 1ebpe jeieuas ients Onl Oo t o IN Oo N y 2 c 9 3 oueqy1oM 19p10 eseyoing v s oo Ambuj youaqyJony eli E PONSON pyeoquseq yueuieBeue y e eo O Kuoudeje punoqu 2 0 pon peoquseq juawafheue majazi ETO OQ yu tujiyn Jeulojsn QJ pe gt O 2 C 7 jueuieBeue eouesqy a a dijs eg Mel aid lt I SAeg MIA d pyeoqusep sajes Ta z g uee1os eje Ambuj Qy E 8 uselog ng Ambuj jessy 2 QU muy lesqledng 2 Q jueuieDeue y JopJQ nue sebeuey uonnquisig d pue Buunjoejnuejy or is Qo Seko nuejyjueueDeue E ame 2228 jssyesudigug D 5 E uM
17. ic Network Acceleration Paper R12 300ms ion imizat IAN Opt T t gt _ Q 2 e 9 ed o 3 o Q ac h j i O 3 Q Z Z gt u E e e e S N ci ac w 5 VY u u w u 2 Lu o O Servlet Socket JOWUOW Snje1S MOYHION dSf lN LH J6w u21eJ9IH 2 Y 19 yojddy jeiseds JD LMEYD pueg sjsonbay jua11n23uo 5 ejeq ullo J ejeq esf on AVI JoyUOW snjel1s MOUHIOM dSfP TW LH JDIAI u21e19IH 2 V 19 jeidd y jeroeds EN E RI pe a i Jolneu2 pueg sjsonbaM yuan UND ejeqg i i ee EN ioa SWJO 4 iz der j sua 3VO TALLH snuo A ulbo7 Ww in st 95 jue ureA 01dui ju9218 d ORACLE 66 Copyright 2012 Oracle and or its affiliates All rights reserved Wan Recommendations symmetrical Network Acceleration Paper Doc ID 967992 1 Compression is a complimentary technology Without acceleration compression e PDF uses 40 of the bandwidth of HTML or Excel format With acceleration compression Use uncompressed formats such as HTML or Excel formats e Download ftp reports during non peak periods Smaller links are cheaper Cost of compression vs cost of infrastructure upgrade ORACLE 67 Copyright 2012 Oracle and or its affiliates All rights reserved Riverbed Compression Report by Protocol Period Group Type Traffic Refresh
18. itor H 28 8 96 8kHz U 58 8 76 8Hz 1824x768 888x688 648x488 Modes Zetc fstab eth de Di i l starte setup_ T Entering runlevel 3 Do you want to configure all interfaces via DHCP y n 39 Copyright 2012 Oracle and or its affiliates All rights reserved Network Configuration Network IP ADDRESS NETMASK DEFAULT GW ESC to Exit To direct input to this virtual machine press Ciri G 40 Copyright 2012 Oracle and or its affiliates All rights reserved Configuration Conf iqured 192 168 4 19 255 255 255 248 192 168 8 1 Save and Exit S Network Status 255 255 255 ineto addr teou 89 E Pepe Sain UP BROADCAST RUNNING MULTICAST MTU 1588 Metric RX packets 8 errors 8 dropped B ouerruns BH frame TX packets 2B8 errors 8 dropped 8 overruns carrier 8 collisions B txqueue len 1888 RX bytes 2172 2 1 KiB TX bytes 4148 4 6 KiB Interrupt 16 Base address 8x1488 Link encap Local Loopback inet addr 127 8 8 1 Mask 255 4 8 8 inet6 addr 17128 Scope Host UP LOOPBACK RUNNING MTU 16436 Metric 1 RX packets 2 errors B dropped B ouerruns B8 frame 8 TX packets Z errors B dropped 8 ouerruns B carrier 8 collisions 8 txqueuelen RX bytes 188 188 8 B TX bytes 188 188 8 B Press any key to continue To direct input to this virtual machine press Ctd G 41 Copyright 2012 Oracle and or its affiliates All rights reserved Network Status Kernel IP routing table Des
19. net Browsing ther Traffic ORACLE 29 Copyright 2012 Oracle and or its affiliates All rights reserved Network Tools Network lest Network Test Latency Bandwidth Tias 9 Trials 5 Iterations 100 Iterations 10 Notes Clear Old Test Data Current Iteration Results Test Date 26 NOV 2007 13 53 52 Batch Latency Results Bandwidth Results Round Trip Time milliseconds Data Rate Bytes per second Client Form Server DataBase Client Form Server DataBase Min Avg Ma Min Avg Mar Min Avg Mar Min Avg Mar 34 7 34 9 35 2 1 1 1 6762 5 7373 0 7714 3 HESEHHHS AHHHRHHA HEHHE HI ORACLE 30 Copyright 2012 Oracle and or its affiliates All rights reserved G Form Latency m Network lest Form Latency vs Network Latency 1400 1200 TS 0 0 100 200 300 Network Latency ms 31 Copyright 2012 Oracle and or its affiliates All rights reserved Form Ping Network Network Test Utilities Best Practices 556738 1 Network Ping times Test Form Network Apps Tier 32 and 1472 normal No change Slower 1472 slower than 32 No change Slower 32 and or 1472 slower No change 2 x Network Offset e 2048 Kbps m 1024 Kbps t 512 Kbps 256 Kbps 128 Kbps 36 ms 45 ms 64 ms 108 ms 188 ms Slower O D 69 09 amp 0 ORACLE a Wireshark M The Wires
20. nts ORACLE Network WANem Boot SCree VON O pee el Ww KNOPPIX 5 3 Please press ENTER to start Linux from DVD f you do not want to boot from DVD please remove this DVD from the drive and restart your computer F2 or F3 for help Press keys F2 or F3 for help and boot options KNOPPIX U5 3 1 CD http www knoppix de RELEASE 2888 83 25 2888 85 28 J boot _ To direct input to this virtual machine press Ctri G ORACLE 38 Copyright 2012 Oracle and or its affiliates All rights reserved Network Boot Procedure _ Welcome to the KNOPPIX live GNU Linux on CD 2 6 24 4 513972kB 584768kB hdc UMware Virtual IDE CDROM Drive devvhdc cloop Initializing cloop v2 624 opt cloop total_offsets 16958 cloop normal format noncomp 8 cloop tblunit size OK cloop Direct read 1 2 OK cloop largest block size 65562 cloop chunk check OK cloop kthread setting OK imary KN X ji imac cdrom KNOPP X KNOPP IX ramdisk shared memoru Accelerated AUTOCONFIG INSTALL Accelerated XSESSION INSTALL INIT version 2 86 booting mf i ing inux Keri AN LING 15 9 ac battery button container dock fan processor sbs sbshc thermal video nanage udeu i udeu udev ware Autoconf iguring devices Done Mou ImPS 2 Generic Wheel Mouse dev input mice Accelerated MKXORGCONFIG lider UMware Inc Abstract SVGA II Adapter ing Xorg vmuare Server Generic Mon
21. onnection 2 connected UMware Network Adapter UMnet connected UMware Network Adapter UMnet8 Ping with small and large packets 35ms vs 5ms ORACLE 20 Copyright 2012 Oracle and or its affiliates All rights reserved Network How much traffic e Network metrics Different modules forms screens Different connection modes socket servlet H TML SSL Amount of data Result sets LOVs Keep forms open Avoid blind queries User adeptness and Application tuninc Don t use leading 96 l Keep LOVs small i Application and work load mix Use defaults later in this session Concurrency Make report parameters mandatory Type of report XML PDF Install Vision and test Ask for a network capture next time you have a product demo ORACLE 21 Copyright 2012 Oracle and or its affiliates All rights reserved Network How much traffic On Demand Technical and Operational standards Doc ID 784666 1 Provides a starting point if you don t have one Oracle E Business Suite self service applications 4 6 kbps Oracle E Business Suite forms applications 10 12 kbps Oracle Business Intelligence amp Applications On Demand 12 kbps Oracle recommends minimum link bandwidth is128 kbps These vary depending on business and workflow Customer must determine peak usage Recommend upgrade if network link gt 8096 during peak usage ORACLE 22 Copyright 2012
22. ork City Bil To V1 New York City Currency USD Buyer Stock Ms Pat Status Approved Total 37 00 i 1 Description Price Reference Reference Documents More Agreement Temporary Labor Num Type Item Rev Job Category Description UOM Quantity Price Bi Goods sss MISC MISC Sentinal Multimedia Each 37 4 gt Item 0000 Sentinal Multimedia Catalog Currency Terms Shipments ORACLE 53 Copyright 2012 Oracle and or its affiliates All rights reserved Application Tuning Purchase Order Form Comparison Stereo eEytry Enter Supplier B otbat TAB Enter Item 880000A4IA Select 0001 0120H ror LOV Enter Qty 1 Enter Price 1 Click Shipments Enter Org V2 TAB Enter Ship To A TAB select Addison TX ro Lov Enter Need By Click Distributions Save Approve Ok 54 Copyright 2012 Oracle and or its affiliates All rights reserved ORACLE Packets Time Tuned 111 Standard Entry 316 Application Tuning Single Line PO Servlet mode Bytes 42 247 109 334 Tuned is 62 more efficient 20 53 Oracle E Business Suite 12 1 3 Start with minimized form Tuned vs Standard Entry Purchase Order Tuned Save and Approve Sin gl e Lin e Std Entry 30 25 20 Bis J x 10 4 MV AVA 0 4 Sn a 0 5 10 15 20 Thea Goncondi 30 35 40 45 50 ORACLE 55 Copyright 2012 Oracle and or its affiliates All rights reserved Socket vs Servlet Socket Mode us
23. otocols and route s e Compare the Network Test Form results ORACLE 69 Copyright 2012 Oracle and or its affiliates All rights reserved Summary Checklist Keep forms open PC and users yt lesion usage Consider deploying faster tuned F Keep LOVs small rain the users Use defaults where possible Avoid multiple Java versions Make report parameters mandatory Application Type of report XML PDF Tune the application concurrent report parameters and output Socket Servlet OAF HTML screens small menus Network Java version Minimize network latencies routing using landlines vs satellite Consider network acceleration ORACLE 70 Copyright 2012 Oracle and or its affiliates All rights reserved Generic 69565 1 PC 557259 1 Network 967992 1 socket Serviet 201340 1 384241 1 Certification 285218 1 389422 1 290807 1 393931 1 1077728 1 271555 1 71 Copyright 2012 Oracle and or its affiliates All rights reserved Useful Documents A Holistic Approach To Performance Tuning Oracle Applications Systems Release 11 and 1 1i Oracle E Business Suite 11i and R12 PC Client Performance oymmetrical Network Acceleration with Oracle E Business Suite R 12 Using Forms Listener Servlet with Oracle Applications 1 1i Using Forms Socket Mode with Oracle E Business Suite R12 Recommended Browsers for Oracle E Business Suite 1 1i Recommended Browsers for Oracle E Bu
24. ralia Australia China Singapore Melborne Sydney Beijing Chai Chee San Fransisco 185 160 200 190 Austin 230 205 245 235 Japan 290 265 107 108 Hong Kong 160 135 62 32 Sydney 20 200 105 Melbourne 20 180 92 26 Copyright 2012 Oracle and or its affiliates All rights reserved E e World MTHUANA Taiwan rai Japan India South Africa Taipei Osaka Hyderabad Capetown 150 125 290 370 185 160 250 370 50 50 170 22 60 80 230 240 150 230 240 140 MONGOLIA 220 180 ORACLE Network Customer Averages PF UKRAINE KAZAKHSTAN MONGOLIA Se f UNITEO INDONESIA EX AUSTRALIA ORACLE 27 Copyright 2012 Oracle and or its affiliates All rights reserved Agenda Client Tuning e Network Tuning Tools Tuning for High Latency Low Bandwidth Satellite ORACLE 28 Copyright 2012 Oracle and or its affiliates All rights reserved Network Tools Quality Of Service QoS Aset of features and tools aims to prioritize mission critical traffic Classifies traffic enabling differentiated service levels Usually implemented in routers arn Mission Critical pplications Congestion management Packet Classification Packet Shaping Rate Limiting Priority Queuing Administration overhead Email Internet Browsing Other Traffic Shaped Traffic Mission Critical Applications Email Inter
25. rge LOV s Concurrent Requests Tight parameters gt Smaller report to transfer Report Type PDF vs XML e Tune the Application Default as much information as possible ORACLE Operating Unit PO Rev Supplier Baxter Health Ship To cx Num Item L PO Account Descriptions Application Tuning Purchase Order Form Standard Entry O Purchase Orders Vision Operations Created 03 MAR 2012 23 21 08 0 Type Standard Purchas Site Bil To V1 New York City Buy Shipments 6032 Descripti v CO Distributions 56032 More 1 1 Expense Charge Operations Vision Operations In Equipmen Accrual Operations Vision Operations In Accounts Budget Variance Operations Vision Operations In Equipmen Lines And Shipment Details Line Num 1 Shipment Num 1 52 Copyright 2012 Oracle and or its affiliates All rights reserved m Gl ry nod rite Select 0001 0120H from LOV Enter Qty 1 TR ind E terree 1 Click Shipments Enter Org V2 TAB ee Enter Need By Destination Account Descriptions Click Distributions ave Approve Ok AV T ORACLE Application Tuning Purchase Order Form Tuned Purchase Orders 6031 EB n E3 Operating Unit Vision Operations Created 03 MAR 2012 23 06 58 PO Rev 6031 0 Type Standard Purchase Order P Card Supplier Global ing Site GLOBAL GA Contact Ship To Vv1 New Y
26. served Client Tuning Low Specification PC Clients Lots of Small Steps e Benchmark clients with the applications that you use e Memory is much more important than CPU e Dont have lots of other applications running e Minimize the browser memory footprint Toolbars themes extensions plug ins helper applications and phishing controls Use low spec clients for Self Service and some Oracle Forms e Old memory is cheap but might not be cost effective ORACLE R12 Client Performance Tips Major Gains e JRE6 uses less cache amp therefore network than JRE5 Avoid 6u10 6u13 e Use OAF HIML where possible smaller memory profile e Do not minimize E Business Suite forms Keep Forms open e Keep menus small more later A few combine menus but profile options can be problematic Move odd fields to prevent opening multiple screens Fast clients can help compensate for poor networks But only up to a point ORACLE Agenda y LIP LL VON ees Client Tuning e Network Tuning Tools Tuning for High Latency Low Bandwidth Satellite ORACLE 19 Copyright 2012 Oracle and or its affiliates All rights reserved Network Tuning That Old Ping Again Pi LAT ya Administrator C windows syste connected Loopback Pseudo Interface 1 disconnected Wireless Network Connection connected Local Area Connection disconnected Wireless Network C
27. siness Suite R 12 Deploying Sun JRE Native Plug in for Windows Clients in Oracle E Business Suite 1 1i Deploying Sun JRE Native Plug in for Windows Clients in Oracle E Business Suite R12 Using Microsoft Office 2007 and 2010 with Oracle E Business Suite 11i and R12 Hecommended Set Up for Client Server Products with Oracle E Business Suite 11i and R12 ORACLE 72 Copyright 2012 Oracle and or its affiliates All rights reserved Hardware and Software Engineered to Work Together ORACLE ORACLE
28. ss 1008 This example 4 6MB YA oy 31 Mar 2009 lay 1 Common Jar Files OMR RUND yal Up JRE 1 5 11i 10 6 MB m T AAEN JRE 6u31 11i 5 1MBG2 1 3 6 5MB gt JRE 6u31 50 more efficient than JRE 1 5 ORACLE 7 Copyright 2012 Oracle and or its affiliates All rights reserved Client Tuning Minimum Specification 798258 Win XP 233MHz 64MB min 128MB recommended CPU speed Win 7 1GHz 1GB 32 bit or 2GB 64 bit Oracle recommends at leas 350 MH2proce sors You Will experience significant pertormanc MS Word 2003 67S tO open a doc Note that the minimum requirements will oro l Your requirements may be higher Office 2007 500MHz 512MB il Many features grammar and spelling Memory won t work with lt 1GB Consider the minimum requiremsg ts for the operating system Oracle recommends at leas Of RAM for Microsoft Windows Apple MAC clients If running with other apps you will experience better performance with additional memory When considering CPU and memory consider the minimum requirements for the OS other software that runs concurrently and external factors such as the network characteristics Check that the configuration is sufficient to achieve the throughput necessary to sustain your business model Your requirements may be higher than the minimum specification ORACLE 8 Copyright 2012 Oracle and or its affiliates All rights reserved Client Tuning Clients Used in t
29. tination Gateway Genmask Flags Metric Ref Use Iface 192 168 8 8 4 6 6 8 255 255 255 246 U B 8 B eth8 B B 8 8 192 168 8 1 4 4 6 8 UG 4 H B eth fipache running SSH Server Enter IP Address to test reachability q to skip 192 168 6 197 192 168 8 197 reachable WaNemContro l PERC gt _ To direct input to this virtual machine press Ctd G 42 Copyright 2012 Oracle and or its affiliates All rights reserved Network ome 7 WANEM The Wide Area Network Emulator Windows Internet Explorer Gc yy http 192 168 0 10 WANem We EU GE WANEM The Wide Area Network Emulator T gt TATA TATA CONSULTANCY SERVICES Performance Engineering Research Centre 43 Copyright 2012 Oracle and or its affiliates All rights reserved WANem The Wide Area Network Emulator WANem v2 0 Copyright 2007 Tata Consultancy Services Ltd WANem is an open source Wide Area Network emulator WANem is distributed under GNU GPL v2 WANem New Release New Release of WANem can be downloaded from here amp Internet em sy Page 3 Tools ORACLE Network Basic Mode 7 WANEM The Wide Area Network Emulator Windows Internet Explorer Gc J http 192 169 0 10 WANem we Ge RE WANEM The Wide Area Network Emulator es WANem TATA CONSULTANCY SERVICES Ihe Wide Area Network Emulator Performance Engineering Research Centre XU ARIakAs VW A_Naivzer gt Cu dear ___Inter
30. ts affiliates All rights reserved Client Tuning Avoid Minimizing Applications on Low Memory Clients i Performance E File Action Visu Favorites Weirdos Help he t AX L C l O WAS x e mea Om verry Private Bytes 1425 Form is M inim ize the 1350 n AP remains static 1200 _ amp 4 Wa Working Set does o 1050 A ml g2 Run further not recover for a es 5 D gt 2 E M axim ize all Queries sas 2 dQ amp a Explorer Windows long time Sean g X p M OW 675 FA Bh 5 3 600 S A g 525 450 i i gt gt M axim ize the 375 Y Form W indow 300 225 Runan Open Ouery 150 Working Set 14 75 lt R estore the Form 678625278 Average 554137270 Minimum nni Working Set iexplore _ Process DELLLAP 0 0000100 Private Byt iexplore Process WA DELLLAP Memory optimizers ORACLE 6 Copyright 2012 Oracle and or its affiliates All rights reserved Client Tuning Normal Usage Jar File Validation vs Revalidation Already on PC l l Z Java Cache Vi wa I BRL 73 First time use or on upgrade 2a S ec Common JARs f Cache Ste 66 Sets JAR file fndforms jar Validated NA download fndaoljar g Oni Use 65MB mJ le fndformsi 18n jar 102KB 0 la fndutil jar 156KB 07 Sep 20 e fndewt jar 2449KB 03 Sep 2010 07 Sep 2010 Other JARs HP A a
31. ts affiliates All rights reserved ORACLE Agenda Client Tuning e Network Tuning Tools Tuning for High Latency Low Bandwidth PC e Oracle E Business Suite issues e Tuning between the Keyboard and chair Satellite ORACLE 47 Copyright 2012 Oracle and or its affiliates All rights reserved Tuning for High Latency Low Bandwidth Smoke and Mirrors e Windows XP TcoWindowSize GlobalMax IcoWindowSize 256KB Tcp13230pts e 1 faster 3 only for VERY lossy connections e Windows 7 Don t disable Nagle s algorithm Dont disable TCP IP autotunning e netsh int tcp show global Receive Window Auto Tuning Level normal ORACLE Tuning for High Latency Low Bandwidth Oracle E Business Suite Issues Forms will not start after 300 seconds Bug 6644380 Relates to both latency and available bandwidth e Swan Color Scheme in R12 Doc ID 786582 1 has a workaround Bug 5612353 e Keep menus small seen on the PC comparison chart Bug 6329486 ORACLE Tuning for High Latency Low Bandwidth Oracle E Business Suite 111 Menus Typical Menu Login Screen ORACLE 50 Copyright 2012 Oracle and or its affiliates All rights reserved Tuning for High Latency Low Bandwidth User raining e Keep screens open Use multiple sessions if necessary Browsers slide 16 Teach users to query efficiently avoid leading Yo Minimize the use of la
Download Pdf Manuals
Related Search