RE: Mass updates to production tables (NULL to non-NULL)

Yes you can, but I still like to see it in action with my own eyes to verify ;-) Another cool thing that came of all this is that I wasn't aware of the "select * from table(dbms_xplan.display());" used by 9iR2. I play with the 9i's off and on when I have time, but not dealing with 9iR2 (or R1) on a daily basis I had no idea about the DBMS_XPLAN package in 9iR2.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Deshpande,
> Kirti
> Sent: Tuesday, November 26, 2002 1:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Mass updates to production tables (NULL to non-NULL)
>
>
> Larry,
>
> What I found was the explain plan in 9iR2 will tell you if the
> DML is getting parallelized.
>
> Here is what I see:
> SQL> alter session enable parallel dml;
> Session altered.
> SQL> explain plan for
> 2 update /*+ parallel (KED, 4) */ KED
> 3 set secondary = 'X';
> Explained.
> SQL> @?/rdbms/admin/utlxplp
> PLAN_TABLE_OUTPUT
> ------------------------------------------------------------------
> -----------------------------
> ------------------------------------------------------------------
> -----------------------------
> | Id | Operation | Name | Rows | Bytes | Cost
> | TQ |IN-OUT| PQ Distrib |
> ------------------------------------------------------------------
> -----------------------------
> | 0 | UPDATE STATEMENT | | 1520K| 2969K|
> 707 | | | |
> | 1 | UPDATE | KED | | |
> |Q8,00 | P->S | QC (RANDOM)|
> | 2 | TABLE ACCESS FULL | KED | 1520K| 2969K|
> 707 |Q8,00 | PCWP | |
> ------------------------------------------------------------------
> -----------------------------
>
> In 9i R1 I did not see any TQ (memory queue), IN-OUT and PQ
> Distribution information for UPDATE operation, indicating that it
> was carried on serially, however, the TABLE ACCESS FULL operation
> was performed in parallel as expected.
>
> Regards,
>
> - Kirti

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).