Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_DDL.ANALYZE_OBJECT and implicit commit
Of course. Whenever you issue DML statement, Oracle will perform commit
immediately after execution. Hope this can help you.
snapondba_at_hotmail.com wrote:
> Does the DBMS_DDL.ANALYZE_OBJECT procedure cause an implicit commit within a
> PL/SQL block? A procedure we developed populates several staging tables and
> updates some production data. I think our performance will increase if we can
> analyze the staging tables, but want the option to rollback all activity upon
> an exception. If the analyze performs an implicit commit we lose the ability
> to rollback everything.
>
> Any thoughts?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
--
Best Regards,
Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)
![]() |
![]() |