5 Replies Latest reply: Jul 10, 2013 4:47 AM by user13077819 RSS

    batch size in adpatch

    user13077819

      Can you correct me about batch size in adpatch if its wrong:

       

      No. or rows will commit at a time like save point for each workers job.

       

      Regards

        • 1. Re: batch size in adpatch
          Hussein Sawwan-Oracle

          Please see (How Does The Batch Size Affect The Number Of Parallel Update Units [ID 1311402.1]).

           

          Thanks,

          Hussein

          • 2. Re: batch size in adpatch
            user13077819

            parallel updates means,

             

            say ex:

            worker 1 sid- 400

            worker 2 sid- 401

            worker 3 sid- 402

            worker 4 sid- 403

             

            while 1 worker 1 doing updates to table its having lock, how come worker 2 will do updated to same tables? it should wait for worker 1 to release lock right.

             

            Regards.

            • 3. Re: batch size in adpatch
              Hussein Sawwan-Oracle

              Parallel updates doesn't necessarily mean update on the same object (table) by different workers, and it means more than one worker is running different scripts (updating different data in patches). If the same script is processed by many workers then adpatch is smart enough to handle the locks on the tables.

               

              Thanks,

              Hussein

              • 4. Re: batch size in adpatch
                user13077819

                thanks for info...

                 

                I have attended class in Oracle Internal Training rooms.

                 

                The concept they told was, If query starts running, if execution plan was created already then creating profiles or running stats will effect  for next run of query, not for present run.

                 

                cat batchprocess.sql

                select status, sum(rows_processed), count(*)

                from apps.ad_parallel_update_units

                where update_id = (

                select update_id

                from apps.ad_parallel_updates

                where script_name like '&a')

                group by status;

                 

                 

                 

                 

                 

                with the above script we generally monitor adpatch work status.

                 

                while adworker running this script "ar120lclcsu.sql", we see its process batches.


                We observe the batches moving slowly. with help of sqltrpt recommendations, we created profile. after creating immediatly WITHOUT restarting of job, batches moved very fastly.


                My doubt is, scripts started and some batches were processed means its already started and execution plan for the script is generated, after immediatly creating profile and without restart of job how profile taken effect?


                • 5. Re: batch size in adpatch
                  user13077819

                  Team,

                   

                  Plz help me on this.