This discussion is archived
5 Replies Latest reply: Jul 10, 2013 2:47 AM by user13077819 RSS

batch size in adpatch

user13077819 Newbie
Currently Being Moderated

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 Employee ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Employee ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    Team,

     

    Plz help me on this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points