ORA_ROWSCN and ROWDEPENDENCIES

Yesterday, I can't find it now, someone wrote that ROWDEPENDENCIES has a granularity of 3 seconds.

While that may have been true in the past ... it seems it another bit of advice that has outlived its usefulness.

In 10gR2 the following produces a unique SCN for each row.

CREATE TABLE t (
testcol NUMBER(10))
ROWDEPENDENCIES; BEGIN
   FOR i IN 1 .. 1000 LOOP
   INSERT INTO t VALUES (i);
   COMMIT;
   user_lock.sleep(0.1);
   END LOOP;
END;
/

SELECT ora_rowscn, testcol
FROM t
ORDER BY 2;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org