Re: DUAL Table slow

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: 2000/09/21
Message-ID: <39ca8a55.117154599@nsw.nnrp.telstra.net>#1/1

Hi Ravi,

It is not too slow considering that you did it 348 times.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: raviprasad_at_my-deja.com

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