Dataguard Network Tuning Tvd Layout 01

Please download to get full document.

View again

of 8
6 views
PDF
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Document Description
ìnfoQtrìvudìs.com . www.trìvudìs.com . lnfo-1oí. 0800 87 482 347 . Duto 16 Cct. 2007 . Fugo 1 / 8 Data Guard in SYNC modc - docs my Dß suffcr from nctwork wcakncss ! Yunn Nouhuus Sonìor Consuítunt 16 Cctobor 2007 Data Guard nctwork tuning is aIways a big and nicc chaIIcngc which shouId bc takcn scriousIy. lor instancc, my Grid ControI consoIc is oftcn poIIutcd by warnings about wait cvcnts of thc nctwork cvcnt cIass : ls my Data Guard sctup rcaIIy suffcring from po
Document Share
Documents Related
Document Tags
Document Transcript
     !   #$%&%'()%'*  ! ##$  %    +,%!&-%&%.*&&//&.0&/1233454!64-%$.+/5&%!&&%7*&!8%.!%-%10%&+&,%9+:0&/%/,,&6%/%!/!1  ping ttchp02 PING ttchp02.ttc.trivadis.com: (172.16.65.7): 56 data bytes64 bytes from 172.16.65.7: icmp_seq=0 ttl=255 time=0 ms64 bytes from 172.16.65.7: icmp_seq=1 ttl=255 time=0 ms64 bytes from 172.16.65.7: icmp_seq=2 ttl=255 time=0 ms 3;7&/!&&&/8%7&&69.&///&:<%=&%*/,1  ping 172.17.38.8     !  PING 172.17.38.8 (172.17.38.8) 56(84) bytes of data.64 bytes from 172.17.38.8: icmp_seq=4 ttl=64 time=0.339 ms64 bytes from 172.17.38.8: icmp_seq=5 ttl=64 time=0.424 ms 6>+&?9:>@@@9-* : 9!*,:?A@&$)/&&+1A@8&/,*,1 RECV_BUF_SIZE=375000SEND_BUF_SIZE=375000 2.%&&/)$B<3#9/%,:&*=/,CDB&&/C,D1 TCP.NODELAY=yes &/&&&&&!9:/.!*,&*,&%!&/.&$!!!&&*&!/!&/,*/&.%EF*/2*%&$!!!&$93&%!&&/%*&%,=/:1&/1 .  244!/3;7&/%%!&%!8%(&)8%%!&1 no -o ipqmaxlen=100 (&/%%1&/1 /%***%* / 4G( =* /%! /&HI tcp_sendspace = 131072tcp_recvspace = 65536 &*/&*!%!&,&-)!%&*%/*%,9&%:1 SYS@STAGPRD1 > select sysdate from dual;SYSDATE--------------------25-SEP-2007 16:07:15SYS@STAGPRD1 > select startup_time from v$instance;STARTUP_TIME--------------------22-SEP-2007 19:28:40 0,,&&&!&/1 set lines 130select * from V$SYSTEM_WAIT_CLASSorder by 5/     !  WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS TOTAL_WAITS TIME_WAITED------------- ----------- ------------------- ----------- -----------4217450380 1 Application 1472 4343875070507 4 Concurrency 1178 13383290255840 2 Configuration 1097 52503386400367 5 Commit 3512 69814166625743 3 Administrative 4906 111527 2000153315 7 Network 2549790 3250161740759767 8 User I/O 1384276 4274404108307767 9 System I/O 3151272 6464151893977003 0 Other 251373 22075662723168908 6 Idle 3720999 639262672 5/1JKJKG JIK(, JK&JK$.&*7/%-)7,&/*LM53)<3((2B6)4N(6#1 select BEGIN_TIME, END_TIME, DBTIME_IN_WAIT, TIME_WAITED WAIT_COUNTfrom V$WAITCLASSMETRIC_HISTORY where WAIT_CLASS# = 7; BEGIN_TIME END_TIME DBTIME_IN_WAIT TIME_WAITED WAIT_COUNT-------------------- -------------------- -------------- ----------- ----------25-SEP-2007 11:00:54 25-SEP-2007 11:01:54 21.0387822 2143.1923 1926225-SEP-2007 10:59:54 25-SEP-2007 11:00:54 51.2713653 2147.2517 1904725-SEP-2007 10:58:54 25-SEP-2007 10:59:54 55.8887214 2480.2726 1840525-SEP-2007 10:57:53 25-SEP-2007 10:58:54 44.2017456 2374.9075 2122325-SEP-2007 10:56:53 25-SEP-2007 10:57:53 33.1204214 2676.6979 2833625-SEP-2007 10:55:53 25-SEP-2007 10:56:53 37.3184263 3498.7629 3096525-SEP-2007 10:54:54 25-SEP-2007 10:55:53 27.779576 3130.5472 2940325-SEP-2007 10:53:54 25-SEP-2007 10:54:54 26.117611 2752.5801 23430 $,,E/&&-1 Database Time Spent Waiting (%) is at 88.26568 for event class Network <F&.&/,3!&&///&2.7&C<$((B$6BOD&8%&!9&//!&*,*:1J&-%<$(/&/%*/.&-%60(/&*,*0E!&2+<$(%%/.&60(/&*,J&60(/&*!*,<$(  %&' 9/%&,*:J60(/.!*.<$(&&&*.J<$(/<-56&&&&*%%,.*,&*,LM(#(B24BLB$&&&%,&%1 select EVENT, TOTAL_WAITS, TOTAL_TIMEOUTS, TIME_WAITED, AVERAGE_WAITfrom v$system_event     !  where event like '%LNS%'or event like '%LGWR%'/EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT------------------------- ----------- -------------- ----------- ------------LNS ASYNC archive log 4 4 391 97.69LNS wait on ATTACH 1 0 18 17.68 LNS wait on SENDREQ 125643 0 156673 1.25 LNS wait on LGWR 126038 0 78 0LGWR wait on LNS 126038 56 162221 1.29LGWR-LNS wait on channel 277751 113394 162651 .59LGWR wait for redo copy 12923 12 198 .02 +&=/7!&&//<$((B$6BO&&%/*,<$(/&./&&!<$(B3)N&&%/*,<$(/60(<-56<$(&&%/*,&!9<-56:/!!<$(/<$(<-56&&%/*,<$(/!!&!9<-56:/<-56<$(&&&%/*,&!9<-56:/&<$(/!!07&&P<-56<$(&P.*%/,&&<$(&<-56/!!&*,/&9:7,&<$( 60(1 select EVENT, TOTAL_WAITS, TOTAL_TIMEOUTS, TIME_WAITED, AVERAGE_WAITfrom v$system_eventwhere event like '%RFS%'order by 4/EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT------------------------- ----------- -------------- ----------- ------------RFS sequential i/o 5 0 8 1.7RFS attach 3 0 260 86.59RFS close 200 0 1231 6.16RFS create 201 0 3595 17.88RFS random i/o 125265 0 113224 .9RFS dispatch 129537 0 114332 .88 RFS write 125270 0 121825 .97 RFS ping 3863 0 349625 90.51 
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks