RE: INSERT Performance in Benchmark ? ... Basic Qs
Date: Fri, 20 Jun 2008 21:42:33 +0530
Message-ID: <69E1360E54B50C4A828A136C158E474203AAE3EE00@BLRKECMBX02.ad.infosys.com>
Folks
Why the 13 RE-parses, when using Bind Variables?
Cheers
Sent: Thursday, June 12, 2008 4:57 PM
Folks
Benchmarking a Banking Java Application using Oracle thin driver to connect to the Database. OLTP Nature of Transactions NOTE - Dedicated Server process connections to Database.
INSERT INTO SaleBackEnd(SaleBackEnd.ATMPinStatus, ... VALUES ( :1, :2, ... )
Below is the SQL Trace taken under Tran. Load (10046 at Level 12). Qs Is the INSERT facing performance issues?
CONFIG:-
HP-UX
Oracle 10.2
Will share Detailed SQL Trace file, as needed.
Cheers & Thanks indeed
Vivek
P.S. SQL Trace under Load :-
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.20 0.57 0 29 184 13 Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 26 0.20 0.58 0 29 184 13
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 26 (CRMUSER)
Rows Execution Plan
------- ---------------------------------------------------
0 INSERT STATEMENT MODE: ALL_ROWS Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 13 0.00 0.00 SQL*Net message from client 13 0.30 0.35 **************** CAUTION - Disclaimer *****************This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 20 2008 - 11:12:33 CDT