Home » RDBMS Server » Server Administration » Insert statements too slow
Insert statements too slow [message #56918] Tue, 06 May 2003 03:50 Go to next message
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

Report message to a moderator

Re: Insert statements too slow [message #56919 is a reply to message #56918] Tue, 06 May 2003 09:37 Go to previous messageGo to next message
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

Report message to a moderator

Re: Insert statements too slow [message #56920 is a reply to message #56918] Tue, 06 May 2003 12:22 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Check for any unused indexes on this table, or a way to make composite indexes. On insert Oracle has to also update the index which slows down the transaction progresively of the number of indexes.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Problem with creating NT service
Next Topic: Oracle Updating Table/Index Statistics
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:55:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.