Database Time Spent Waiting (%)" is at 100 for event class "Network"
606997Jan 6 2010 — edited Jan 8 2010we have 4 node Rac and we have 4 node stand by in oracle enter prise manager iam seeing the following issues
Database Time Spent Waiting (%)" is at 100 for event class "Network"
does this is causing due to dataguard
I have the follwing stats on primary node
select * from V$SYSTEM_WAIT_CLASS order by 5;
WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS TOTAL_WAITS TIME_WAITED
------------- ----------- ---------------------------------------------------------------- ----------- -----------
4166625743 3 Administrative 21 1842
3290255840 2 Configuration 25348 2463
4217450380 1 Application 801532 13059
3875070507 4 Concurrency 1416436 55897
3386400367 5 Commit 433387 730766
1740759767 8 User I/O 7487741 2697107
3871361733 11 Cluster 90347638 3446245
1893977003 0 Other 92803248 3933639
4108307767 9 System I/O 10416161 3974198
2000153315 7 Network 19792663 6952205
2723168908 6 Idle 672583426 1.2486E+10
11 rows selected.
SQL> select BEGIN_TIME, END_TIME, DBTIME_IN_WAIT, TIME_WAITED WAIT_COUNT from V$WAITCLASSMETRIC_HISTORY where WAIT_CLASS# = 7;
BEGIN_TIM END_TIME DBTIME_IN_WAIT WAIT_COUNT
--------- --------- -------------- ----------
06-JAN-10 06-JAN-10 100 142.3887
06-JAN-10 06-JAN-10 72.3936534 291.1971
06-JAN-10 06-JAN-10 50.9280019 262.1305
06-JAN-10 06-JAN-10 70.0208081 353.2993
06-JAN-10 06-JAN-10 46.6460545 262.1046
06-JAN-10 06-JAN-10 55.3589309 312.5976
06-JAN-10 06-JAN-10 53.8417652 299.6347
06-JAN-10 06-JAN-10 58.8617327 312.4276
06-JAN-10 06-JAN-10 53.0530489 287.0084
06-JAN-10 06-JAN-10 57.2724666 298.3923
06-JAN-10 06-JAN-10 46.070464 268.636
BEGIN_TIM END_TIME DBTIME_IN_WAIT WAIT_COUNT
--------- --------- -------------- ----------
06-JAN-10 06-JAN-10 45.1454895 276.4624
06-JAN-10 06-JAN-10 55.2583501 307.7248
06-JAN-10 06-JAN-10 60.8569329 339.4691
06-JAN-10 06-JAN-10 56.9249132 298.2237
06-JAN-10 06-JAN-10 40.9293944 247.431
06-JAN-10 06-JAN-10 46.6922583 217.7133
06-JAN-10 06-JAN-10 81.1483914 353.3769
06-JAN-10 06-JAN-10 50.1777048 261.8799
06-JAN-10 06-JAN-10 73.0408495 368.9137
06-JAN-10 06-JAN-10 76.1283774 356.3529
06-JAN-10 06-JAN-10 100 380.639
BEGIN_TIM END_TIME DBTIME_IN_WAIT WAIT_COUNT
--------- --------- -------------- ----------
06-JAN-10 06-JAN-10 68.2845308 287.41
06-JAN-10 06-JAN-10 82.5850823 362.8919
06-JAN-10 06-JAN-10 62.3142677 275.6767
06-JAN-10 06-JAN-10 84.3995442 361.5441
06-JAN-10 06-JAN-10 91.3496938 368.4441
06-JAN-10 06-JAN-10 68.4109542 299.1427
06-JAN-10 06-JAN-10 97.1309661 354.6034
06-JAN-10 06-JAN-10 58.9975635 276.5522
06-JAN-10 06-JAN-10 100 480.147
06-JAN-10 06-JAN-10 100 372.7108
06-JAN-10 06-JAN-10 84.7414812 281.6867
BEGIN_TIM END_TIME DBTIME_IN_WAIT WAIT_COUNT
--------- --------- -------------- ----------
06-JAN-10 06-JAN-10 100 301.1367
06-JAN-10 06-JAN-10 100 246.1841
06-JAN-10 06-JAN-10 100 262.2515
06-JAN-10 06-JAN-10 100 171.5708
06-JAN-10 06-JAN-10 100 126.8587
06-JAN-10 06-JAN-10 100 145.2138
06-JAN-10 06-JAN-10 100 135.857
06-JAN-10 06-JAN-10 100 138.2348
06-JAN-10 06-JAN-10 100 123.2375
06-JAN-10 06-JAN-10 100 126.9729
06-JAN-10 06-JAN-10 100 123.6096
BEGIN_TIM END_TIME DBTIME_IN_WAIT WAIT_COUNT
--------- --------- -------------- ----------
06-JAN-10 06-JAN-10 100 119.4667
06-JAN-10 06-JAN-10 100 132.8924
06-JAN-10 06-JAN-10 100 116.3798
06-JAN-10 06-JAN-10 100 115.5149
06-JAN-10 06-JAN-10 100 123.7321
06-JAN-10 06-JAN-10 100 112.4661
06-JAN-10 06-JAN-10 100 145.8468
06-JAN-10 06-JAN-10 100 130.6036
06-JAN-10 06-JAN-10 100 116.0382
06-JAN-10 06-JAN-10 100 115.7043
06-JAN-10 06-JAN-10 100 138.5449
BEGIN_TIM END_TIME DBTIME_IN_WAIT WAIT_COUNT
--------- --------- -------------- ----------
06-JAN-10 06-JAN-10 100 141.8431
06-JAN-10 06-JAN-10 100 123.172
06-JAN-10 06-JAN-10 100 133.8306
06-JAN-10 06-JAN-10 100 126.8597
06-JAN-10 06-JAN-10 100 115.651
06-JAN-10 06-JAN-10 100 127.464
61 rows selected.
SQL> select EVENT, TOTAL_WAITS, TOTAL_TIMEOUTS, TIME_WAITED, AVERAGE_WAIT from v$system_event where event like '%LNS%' or event like '%LGWR%';
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
---------------------------------------------------------------- ----------- -------------- ----------- ------------
LNS ASYNC end of log 196608583 196601806 211884734 1.08
LNS wait on ATTACH 3 0 257 85.61
LNS wait on SENDREQ 470317 0 6867460 14.6
LNS wait on DETACH 4 0 7 1.86
LNS wait on LGWR 1 0 0 0
LGWR-LNS wait on channel 274 272 294 1.07
LGWR wait for redo copy 14122 0 76 .01
7 rows selected.
SQL> select EVENT, TOTAL_WAITS, TOTAL_TIMEOUTS, TIME_WAITED, AVERAGE_WAIT from v$system_event where event like '%LNS%' or event like '%LGWR%';
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
---------------------------------------------------------------- ----------- -------------- ----------- ------------
LNS ASYNC end of log 196623317 196616539 211900611 1.08
LNS wait on ATTACH 3 0 257 85.61
LNS wait on SENDREQ 470350 0 6867912 14.6
LNS wait on DETACH 4 0 7 1.86
LNS wait on LGWR 1 0 0 0
LGWR-LNS wait on channel 274 272 294 1.07
LGWR wait for redo copy 14122 0 76 .01
7 rows selected.
plz advise me what i have to do now