explain plan

From: chhabradc <member22674_at_dbforums.com>
Date: Wed, 15 Jan 2003 15:21:57 +0000
Message-ID: <2391252.1042644117_at_dbforums.com>

Can somebody please help me in understanding this

call     count       cpu    elapsed       disk      query
current        rows

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

---

Parse        1      0.01       0.00          0          0
0           0
Execute      2      0.01       0.00          0          0
0           0
Fetch        2      0.00      69.31          0          0
0           0

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

---

total        5      0.02      69.32          0          0
0           0

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

Elapsed times include waiting on following events:

  Event waited on                             Times   Max. Wait

  Total Waited

• Waited ----------

  ---

  SQL*Net message to dblink 6 0.00 0.00 SQL*Net message from dblink 6 35.62 67.69 SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 3 105.72 105.73 **********************************************************************-

  ---

--

Posted via http://dbforums.com Received on Wed Jan 15 2003 - 16:21:57 CET