Re: Slow response of forms

From: Raj <rajeev.tomar_at_gmail.com>
Date: 29 Aug 2006 04:01:23 -0700
Message-ID: <1156849282.976315.152470@h48g2000cwc.googlegroups.com>

Hello,

Thanks for reply.

I enabled trace for the session where I was saving data through forms. In *.trf file I can see one section where I see some pointers for possible performance problems. That section from trf file is pasted below :

---

SELECT A.FPL_ID,A.PZUG_ID,A.PZV_KEY,A.EINBRUCHZEIT,A.STRECKE_ID,   A.BST_REIHENFOLGE,COUNT(*),B.ZN
FROM
 PZV_BSTKETTE A,PFPL_ZUG B WHERE (A.PZUG_ID = B.PZUG_ID ) GROUP BY A.FPL_ID, A.PZUG_ID,A.PZV_KEY,A.EINBRUCHZEIT,A.STRECKE_ID,A.BST_REIHENFOLGE,B.ZN   HAVING COUNT(*) > 1 call count cpu elapsed disk query current

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

---

Parse        1      0.00       0.00          0          0          0
       0
Execute     20      0.00       0.00          0          0          0
       0
Fetch       20      4.93      89.37      12388     157899       1400
       0

------- ------ -------- ---------- ---------- ---------- ----------

---

total       41      4.93      89.37      12388     157899       1400
       0

Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 40 (recursive depth: 1)

---

Then I tried to execute the above mentioned query manually and enabled the trace for this session. That section (from *.trf file) corresponding to that query is pasted below:

---

SELECT A.FPL_ID,A.PZUG_ID,A.PZV_KEY,A.EINBRUCHZEIT,A.STRECKE_ID, A.BST_REIHENFOLGE,COUNT(*),B.ZN
FROM
PZV_BSTKETTE A,PFPL_ZUG B WHERE (A.PZUG_ID = B.PZUG_ID ) GROUP BY A.FPL_ID,
A.PZUG_ID,A.PZV_KEY,A.EINBRUCHZEIT,A.STRECKE_ID,A.BST_REIHENFOLGE,B.ZN HAVING COUNT(*) > 1 call count cpu elapsed disk query current

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

---

Parse        1      0.00       0.00          0          0          0
       0
Execute      1      0.00       0.00          0          0          0
       0
Fetch        1      0.32       4.57        620       7895         70
       0

------- ------ -------- ---------- ---------- ---------- ----------

---

total        3      0.32       4.57        620       7895         70
       0

Misses in library cache during parse: 1
Optimizer goal: RULE
Parsing user id: 24

Rows Row Source Operation

-------  ---------------------------------------------------
      0  FILTER

  44625 SORT GROUP BY
  44624 NESTED LOOPS

   3665     TABLE ACCESS FULL PFPL_ZUG
  44624     TABLE ACCESS BY INDEX ROWID PZV_BSTKETTE
  48288      INDEX RANGE SCAN (object id 6452)

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

Please let me know your comments on the same.

Thanks, Raj

> Someone else already posted a good procedure for seeing what is slow on
> the oracle side.
>
> What kind of machine are you running on ( how much memory, what kind of
> processor, etc ). Is everything slow when oracle is slow or is it only
> the oracle forms part that is slow?
Received on Tue Aug 29 2006 - 06:01:23 CDT