Home » RDBMS Server » Server Administration » Insert statements too slow
| Insert statements too slow [message #56918] |
Tue, 06 May 2003 03:50  |
Mike
Messages: 417
Registered: September 1998
|
Senior Member |
|
|
Hi,
When I check in my trace files I find these insert statements too slow.How can I speeden up these?
INSERT INTO ICPTC1 (RECNO,SNO,CO_ID,ICOCODE,TRNKID,CALLEDNO, CALLINGNO,
STARTDT,ENDDT,DURATION,CHARGEUNIT, CHARGEPERUNIT,CHARGE,MATCHDESCODE,
RATEDDT, FILENAME,CALL_TON,CALLFLAG,RPCODE,EXCHANGEID)
VALUES
(:hrecno,ICMAXVALUE_SEQ.NEXTVAL,:hco_id,:hicocode, :htrunkid,:hcallingno,
:hcalledno, to_date(:hstartdt,'yyyymmddhh24miss'), to_date(:henddt,
'yyyymmddhh24miss'), :hduration,:hchargeunit,:hCHARGEPERUNIT, :hcharge,
:hmatchdescode, SYSDATE,:hfilename,:hcall_ton,:hcallflag,:hrplreconcode,
:hexchangeid)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 331 0.11 0.18 0 0 0 0
Execute 330 0.34 1.48 9 346 1404 330
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 661 0.45 1.66 9 346 1404 330
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 17 (ICB)
Rows Execution Plan
------- ---------------------------------------------------
0 INSERT STATEMENT GOAL: CHOOSE
0 SEQUENCE OF 'ICMAXVALUE_SEQ'
TIA
Mike
|
|
|
|
| Re: Insert statements too slow [message #56919 is a reply to message #56918] |
Tue, 06 May 2003 09:37  |
Manoj Murumkar
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
Check if you have sequence cached. If not, cache it. Also, check if it is possible to select the value of the sequence in a bind variable before and use that variable in the VALUES clause. Hope you'll find this useful.
Manoj
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Dec 30 17:05:23 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
