Re: Spatial Insert Performance

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Fri, 09 Jul 2004 14:09:14 -0400
Message-ID: <ccmn02$slc$1@newslocal.mitre.org>

And here are the stats from the bottom of the trace file...

--Peter

---

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        2      0.00       0.00          0          0          0           0
Execute    102     53.04      53.25          1      49600      22641        5000
Fetch        0      0.00       0.00          0          0          0           0


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

total      104     53.04      53.25          1      49600      22641        5000

Misses in library cache during parse: 0

Elapsed times include waiting on following events:

   Event waited on                             Times   Max. Wait  Total Waited
   ----------------------------------------   Waited  ----------  ------------
   SQL*Net message to client                     103        0.00          0.00
   SQL*Net message from client                   103        0.21          0.94
   log file sync                                 100        0.14          0.52

OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse    46048      3.42       3.55          0        126          0           0
Execute  61140      5.48       5.54          0      16068      16306        5720
Fetch    65467      7.57       7.70          1     386290          1       55420


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

total   172655     16.48      16.81          1     402484      16307       61140

Misses in library cache during parse: 184

Elapsed times include waiting on following events:

   Event waited on                             Times   Max. Wait  Total Waited
   ----------------------------------------   Waited  ----------  ------------
   SQL*Net message to client                       1        0.00          0.00
   SQL*Net message from client                     1        0.00          0.00
   log file switch completion                      2        0.17          0.19
   db file sequential read                         1        0.00          0.00

45745 user SQL statements in session.

   306 internal SQL statements in session. 46051 SQL statements in session.

---

Trace file: dbdev_ora_2180.trc
Trace file compatibility: 9.00.01
Sort options: exeela

        1 session in tracefile.
    45745 user SQL statements in trace file.       306 internal SQL statements in trace file.     46051 SQL statements in trace file.       203 unique SQL statements in trace file.   1193891 lines in trace file. Received on Fri Jul 09 2004 - 13:09:14 CDT