Performance

From: Jack <none_at_INVALIDmail.com>
Date: Fri, 15 Sep 2006 07:24:38 GMT
Message-ID: <WysOg.48$3s5.20@read3.inet.fi>

Hi!

Production server is a bit slow

Prod                                       Test
----------                               --------------------
9.0.1.4.0                                      9.2.0.4
SUN                                           WinXP
20-40s                                         4s   execution time

Is ther some init parameter which affect Nested loop performance? Or any other ideas?

Jack

---

Time: 00:00:06.07

Execution Plan

---

   0 SELECT STATEMENT Optimizer=CHOOSE    1 0 SORT (UNIQUE)

   2    1     NESTED LOOPS
   3    2       NESTED LOOPS
   4    3         NESTED LOOPS
   5    4           NESTED LOOPS
   6    5             VIEW
   7    6               SORT (UNIQUE)
   8    7                 UNION-ALL
   9    8                   MERGE JOIN
  10    9                     SORT (JOIN)
  11   10                       TABLE ACCESS (FULL) OF 'KAAPELI'
  12    9                     SORT (JOIN)
  13   12                       TABLE ACCESS (FULL) OF 'TILAUSRIVI'
  14    8                   TABLE ACCESS (FULL) OF 'KAAPELI'
  15    5             INDEX (UNIQUE SCAN) OF 'TTIL_PK' (UNIQUE)
  16    4           INDEX (UNIQUE SCAN) OF 'KARY_PK' (UNIQUE)
  17    3         INDEX (RANGE SCAN) OF 'TRIV_PK' (UNIQUE)
  18    2       TABLE ACCESS (BY INDEX ROWID) OF 'TILA'
  19   18         INDEX (UNIQUE SCAN) OF 'TILA_PK' (UNIQUE)

Statistics

---

       1939  recursive calls
          0  db block gets
      41383  consistent gets
          0  physical reads
          0  redo size
       1503  bytes sent via SQL*Net to client
        491  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
       1376  sorts (memory)
          0  sorts (disk)
         41  rows processed

Received on Fri Sep 15 2006 - 02:24:38 CDT