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 [EMAIL PROTECTED] 214.954.1781 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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: [EMAIL PROTECTED] 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: [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).
