Introduction
Unfortunately, what Oracle calls "Network Waits" have little to do with Network but and almost exclusively to do with the time it takes to pack messeges for the network before they are sent.
Client = you, the tool, sqlplus, application
the shadow process is communicating to the client
The same events exist, but where the client is the shadow process and another database plays the roll of shadow process:
SQL*Net Wait Events
Idle EventWaiting for work from ClientIncludes network transmission times for messages coming from shadow Time it takes to pack a message to be sent to the clientDoesn’t include network timingsee Tanel Poder's analysis of SQL*Net message to client
Possibly set SDU=32768 as well as setting RECV_BUF_SIZE and SEND_BUF_SIZE to 65536.
CREATE TABLE T1 (C1 NUMBER);ALTER TABLE T1 ADD(CONSTRAINT T1_CHECK1 CHECK (C1 IN ('J','N')));ALTER SESSION SET EVENTS'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';INSERT INTO T1 VALUES (1);
PARSING IN CURSOR #2 len=25 dep=0 uid=0 oct=2 lid=0 tim=5009300581224 hv=981683409 ad='8e6a7c10'INSERT INTO T1 VALUES (1)END OF STMTPARSE #2:c=0,e=2770,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=1,tim=5009300581220BINDS #2:EXEC #2:c=0,e=128,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=5009300581418ERROR #2:err=1722 tim=512952379WAIT #2: nam= 'SQL*Net break/reset to client' ela= 31 driver id=1650815232 break?=1 p3=0 obj#=-1 tim=5009300581549WAIT #2: nam='SQL*Net break/reset to client' ela= 92 driver id=1650815232 break?=0 p3=0 obj#=-1 tim=5009300581662
Analysis and Tuning
There isn't much to do on the Oracle side for tuning. You can try optimizing the SDU and SEND_BUF_SIZE and RECV_BUF_SIZE.
For actually getting information on network speeds you will have to use something like
SDU
V10G = (DESCRIPTION =(SDU=32768)(ADDRESS = (PROTOCOL = TCP)(HOST = fuji)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = v10g)) )
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SDU=32768)(SID_NAME = v10g)(ORACLE_HOME = /export/home/oracle10)))
sqlnet.ora client.trc
RECV_BUF_SIZE and SEND_BUF_SIZE
V10G = (DESCRIPTION =(SEND_BUF_SIZE=65536)(RECV_BUF_SIZE=65536)(ADDRESS = (PROTOCOL = TCP)(HOST = fuji)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = v10g)) )
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SEND_BUF_SIZE=65536)(RECV_BUF_SIZE=65536)(SID_NAME = v10g)(ORACLE_HOME = /export/home/oracle10)))
RECV_BUF_SIZE=65536SEND_BUF_SIZE=65536
.
.
.
|
Oracle: Network Waits
最新推荐文章于 2023-03-25 15:20:54 发布