OraFAQ Forum: Networking and Gateways » Configuring network packed size

Home » RDBMS Server » Networking and Gateways » Configuring network packed size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Configuring network packed size [message #130991]

Wed, 03 August 2005 14:38

mjschwenger
Messages: 137
Registered: July 2005
Location: US

Senior Member

I need help in configuring network packed size.
I have a lot of SQL*Net waits in inserts and some selects.
The advise given to me is to increase it, but I do not know how - Is this the same like the array size?
here is a piece of the trace file:
INSERT INTO ADDRESS(ADDR_ID, ADDR1, ADDR2, ADDR3, ADDR_HASH, ADDR_LEFTOVRS,
ADDR_STAT, ADDR_STAT_DT, ADDR_TYPE, CARRIER_ROUTE, CITY, COMPANY_NAME,
COUNTRY, COUNTRY_CODE, DLV_PROB, DPBC, DSRC_ACCT_ID, ENTITY_ID, HIST_STAT,
HOUSEHOLD_ID, JOB_TITLE, LATITUDE, LONGITUDE, LOT_CODE, POSTAL_CODE,
QC_STAT, STATE, STATE_CODE, SYS_CREATE_DT, SYS_DELETE_DT, SYS_LSTUPD_DT,
USPS_RECTYPE, VALID_FROM_DT, VALID_THRU_DT)
VALUES
(:1, :2, NULL, NULL, :3, :4, :5, NULL, :6, NULL, :7, NULL, :8, NULL, NULL,
NULL, :9, :10, :11, NULL, NULL, NULL, NULL, NULL, :12, :13, :14, NULL, :15,
NULL, :16, NULL, :17, NULL)

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 12 0.01 0.00 0 0 0 0
Execute 12 0.01 0.08 9 12 174 10
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 0.02 0.08 9 12 174 10

Misses in library cache during parse: 0
Optimizer mode: FIRST_ROWS
Parsing user id: 67

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
read by other session 1 0.00 0.00
SQL*Net message to client 12 0.00 0.00
SQL*Net message from client 12 0.00 0.02
db file sequential read 9 0.01 0.05
SQL*Net break/reset to client 4 0.00 0.00
********************************************************************************

Thanks for the help.mj

Report message to a moderator

Previous Topic:	Oracle 9i Personal and Client - can they coexist?
Next Topic:	TNS-12514 Message connecting from XP to Unix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 21:05:34 CDT 2024