Re: Oracle8 performance problems under NT

From: Josh Sale <jsale_at_tril.com>
Date: 2000/06/23
Message-ID: <U1L45.527$482.177919@den-news1.rmi.net>#1/1

I should have made this clear in my original posting but we're not using ODBC. We use OCI for Oracle and Open Network (or whatever the heck they call it) for SQL Server. So in both cases, we're using the database's native call interfaces.

Here is a sample from the SQL trace:

SELECT CNTADM.Lev_PRODUCTLINE.Member_Key, CNTADM.Lev_PRODUCTLINE.Member_ID,   CNTADM.Lev_PRODUCTLINE.Member_Name,
  CNTADM.Lev_PRODUCTLINE.Member_Description, CNTADM.Lev_PRODUCTLINE.Sequence FROM
 CNTADM.Hry_PROJECT1,CNTADM.Lev_PRODUCTLINE WHERE

  CNTADM.Lev_PRODUCTLINE.Member_ID=CNTADM.Hry_PROJECT1.PRODUCTLINE AND
  CNTADM.Hry_PROJECT1.Member_Key=94516 ORDER BY
  CNTADM.Lev_PRODUCTLINE.Member_ID


call     count       cpu    elapsed       disk      query    current

rows
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

Parse 2 0.02 0.02 0 0 0 0
Execute 2 0.00 0.06 0 0 6 0
Fetch 2 0.00 4.17 0 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 6 0.02 4.25 0 6 6 2

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20

Rows Row Source Operation
------- ---------------------------------------------------

      0  SORT ORDER BY
      0   NESTED LOOPS
      0    TABLE ACCESS BY INDEX ROWID HRY_PROJECT1
      2     INDEX RANGE SCAN (object id 5667)
      0    TABLE ACCESS FULL LEV_PRODUCTLINE

****************************************************************************

---

SELECT Member_Key, Member_ID, Member_Name, Member_Description FROM
 CNTADM.Att_CUSTOMER WHERE Member_ID='COAST GUARD'

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.01 0 0 3 0
Fetch 1 0.00 0.01 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 3 0.01 0.03 0 0 3 0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20

Rows Row Source Operation
------- ---------------------------------------------------

      0 TABLE ACCESS FULL ATT_CUSTOMER Received on Fri Jun 23 2000 - 00:00:00 CDT