Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_DDL.ANALYZE_OBJECT and implicit commit
Yes, it does. As any other DDL statement.
Why don't you keep list of tables you want to analyze in dynamic array which
is stored in SGA.
Then at the end of your procedure you can repeat cycle again analyzing
tables.
But anyway I think it isn't a good idea to analyze tables during normal
work. It takes a lot of time.
snapondba_at_hotmail.com wrote <776lap$fld$1_at_nnrp1.dejanews.com> ...
>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
Received on Sat Jan 09 1999 - 14:45:20 CST