RE: INSERT Performance in Benchmark ? ... Basic Qs

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
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

Original text of this message