Re: enterprise manager Network

Posted by Roshan on Jun 27, 2016; 11:48am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/enterprise-manager-Network-tp1092p1093.html

SQL> select name from v$event_name where wait_class = 'Network';
 
 
NAME
----------------------------------------------------------------
remote db operation
remote db file read
remote db file write
ARCH wait for net re-connect
LGWR wait on ATTACH
ARCH wait on ATTACH
ARCH wait for netserver start
LNS wait on ATTACH
LNS wait on SENDREQ
LNS wait on DETACH
LGWR wait on SENDREQ
 
 
NAME
----------------------------------------------------------------
LGWR wait on DETACH
ARCH wait on SENDREQ
ARCH wait on DETACH
ARCH wait for netserver init 2
LNS wait on LGWR
LGWR wait on LNS
ARCH wait for flow-control
ARCH wait for netserver detach
TCP Socket (KGAS)
virtual circuit wait
dispatcher listen timer
 
 
NAME
----------------------------------------------------------------
dedicated server timer
SQL*Net message to client
SQL*Net message to dblink
SQL*Net more data to client
SQL*Net more data to dblink
SQL*Net more data from client
SQL*Net message from dblink
SQL*Net more data from dblink
SQL*Net vector data to client
SQL*Net vector data from client
SQL*Net vector data to dblink
 
 
NAME
----------------------------------------------------------------
SQL*Net vector data from dblink
TEXT: URL_DATASTORE network wait
 
 
35 rows selected.
 
 
SQL>
 
SQL> select event, count(*) FROM v$active_session_history where sample_time='27-JUN-16 04.00.42.147 PM' and wait_class = 'Network' group by event;
 
 
EVENT                                                              COUNT(*)
---------------------------------------------------------------- ----------
virtual circuit wait                                                      3