Re: Separating data, index objects

Joel Garry wrote:

> Unless you are saying it does this at random
> times in the middle of a full table scan, which I would highly doubt.
>
> jg

I'm not sure I'd use the word "random" but if you doubt it try this on a single user system with only a single SQL*Plus connection.

SELECT dbms_flashback.get_system_change_number FROM dual;

then immediately:

SELECT dbms_flashback.get_system_change_number FROM dual;

and again immediately:

SELECT dbms_flashback.get_system_change_number FROM dual;

likely consecutive numbers.

Now lets simulate a large full table scan.

SELECT dbms_flashback.get_system_change_number FROM dual;

now wait 60 seconds

SELECT dbms_flashback.get_system_change_number FROM dual;

A lot of SCNs were used ... and they were doing something ... somewhere.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)