A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
