Toad World® Forums

Block_changes

Hi

I'm running a big SQL statement with absolutely no updates. Why does the session manager show bloc_changes / consistent_changes on this statement :

Regards

Martin

Hi martin_goblet,

After run SQL statement with absolutely no updates, Does bloc_changes / consistent_changes values be changes at the moment?

Michael

Hi Michael

I was not able to reproduce this matter. The problem is that I don’t remember with wich statement I got this matter.

Next time, I see this, I’ll save the statement and execute it in a new session to confirm.

Regards

Martin