> disable it by default for all sessions (current patch)
That is the most backwards non-surprising solution.
> enable it by default only for interactive sessions, like AUTOCOMMIT
And that is what other dbms' do.
Chris