Re: Poll: How fast is YOUR database in rows per second, on a full bore table scan???
Date: Fri, 04 Jan 2008 13:26:09 -0800
> The question is, these days, just how many rows
> per second can Oracle retrieve in the worst case
No it isn't. Never has been and never will be. But if that's your question here's my answer:
CREATE OR REPLACE PROCEDURE dba_222 (sleepval IN PLS_INTEGER) IS
FOR rec IN (select obj# from source$) LOOP dbms_lock.sleep(sleepval);
set timing on
set timing off
My calculation is one row per day. So this should complete in 1627 years give or take a few months.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Jan 04 2008 - 15:26:09 CST