Re: To Commit or NOT to Commit

frequent commits when fetching across commits in a pl/sql block is good for ora-1555 errors :)

joe

kgopal wrote:
>
> Hi !
>
> Frequent Commits are always good for performance..
>
> Any one agree ..
>
> Gopal
>
> --
> Author: kgopal
> INET: kgopal_at_mantraonline.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs