Re: Separating data, index objects

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1121543830.872468_at_yasure...
>
> 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.
> --

Just happened to catch the tail-end on this, so have no idea where the main thread has been going.

I suspect your SCN changes are probably
CKPT (the checkpoint process) doing its
checkpoint advance and controlfile update every three seconds.

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005