RE: Currval and buffer gets

From: Ramon E. Estevez <com.banilejas_at_codetel.net.do>
Date: Wed, 24 Apr 2002 08:18:34 -0800
Message-ID: <F001.0044DF7B.20020424081834@fatcity.com>

Waleed, Kevin, Jonathan, Alexander

8.1.7.0 on Windows 2000

run time using view x$dual in centiseconds=494 run time using table dual in centiseconds=896 run time using direct := in centiseconds=1007

Ramon

-----Original Message-----

Alexander.Feinstein_at_mitchell1.com
Sent: Tuesday, 23 April, 2002 9:23 PM
To: Multiple recipients of list ORACLE-L

Waleed/Kevin/Jonathan ...,

8.1.7.2 on HP-UX 64bit.
Modified version:

declare
n1 number;
n2 number;
ss date;
begin
n1 := sys.dbms_utility.get_time;
for i in 1..100000 loop
select sysdate into ss from sys.x_$dual; end loop;
n2 := sys.dbms_utility.get_time;
sys.dbms_output.put_line('run time using view x_$dual in centiseconds='||(n2-n1));
--

n1 := sys.dbms_utility.get_time;
for i in 1..100000 loop
select sysdate into ss from sys.dual;
end loop;
n2 := sys.dbms_utility.get_time;
sys.dbms_output.put_line('run time using table dual in centiseconds='||(n2-n1));
--

n1 := sys.dbms_utility.get_time;
for i in 1..100000 loop
ss := sysdate;
end loop;
n2 := sys.dbms_utility.get_time;
sys.dbms_output.put_line('run time using direct := in centiseconds='||(n2-n1));
end;

Output:

run time using view x_$dual in centiseconds=1167
run time using table dual   in centiseconds=1661
run time using direct :=    in centiseconds=339

Alex.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 24 2002 - 11:18:34 CDT