Re: Current SCN in Redo, 8i Standby DB

Hi Mario,

Using COMMITSCN is not a good idea. You can only use it once in a transaction, so you would have to commit each time, which would raise the SCN and result in a logswitch every five minutes anyway. Not to mention that it is an undocumented feature, and has a memory leak bug.

Maybe a better way is to query the value of the 'calls to kcmgas' system statistic. This statistic is incremented by 1 for each SCN allocation. If your check it just after each log switch, and then check it again every 5 minutes, you will know whether the SCN has changed.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Thu, 03 Feb 2000 14:08:45 -0800, Mario Bucsics <mario.bucsicsNOmaSPAM_at_siemens.at.invalid> wrote:

>Hi !
>
>
>Just use: select userenv('COMMITSCN') from dual;
>
> Bye
>
> Mario,OCP
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Feb 03 2000 - 19:34:08 CST