Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DUAL Table slow

DUAL Table slow

From: <raviprasad_at_my-deja.com>
Date: 2000/09/21
Message-ID: <8qdvc7$rdr$1@nnrp1.deja.com>#1/1

Hi,
  Accessing dual table is slow. Why is it. Attached trace file SELECT SYSDATE
FROM
 SYS.DUAL call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------



Parse 0 0.00 0.00 0 0 0 0
Execute 348 0.02 0.45 0 0 0 0
Fetch 348 0.06 0.09 0 348 1044 348
------- ------ -------- ---------- ---------- ---------- ----------

Why would Execute show 0.45 seconds elapsed ?

Thanks in advance,

Ravi

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US