equiv to dbms_flashback.get_system_change_number() of 9i at 8.1.5

Hi experts,

I am wondering if theres an equivalent to this 9i select statement at 8i:

select dbms_flashback.get_system_change_number from dual;

or do i have to look up the redo logs for that information ?

i am also wondering if there are other "events" that increase the scn except

alter system checkpoint,
alter system switch logfile,
commit.

i could not find this info in the FAQ, nor could i find it in the documentation. and, could anyone explain to me why the scn is always increased by at least 2 ?

thanks,

Frank Zaum,

Salzgitter Received on Tue Oct 15 2002 - 12:58:50 CDT