Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> DUAL Table slow
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
------- ------ -------- ---------- ---------- ---------- ----------
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
![]() |
![]() |