Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Slow performance when running ETL with Oracle libraries might be caused by a large number of SELECT statements. Below are recommendations to improve performance:

1. If you are using the ToolPool entry weba_run_ETL.sas, edit the last parameter of that program to clear the libraries at the beginning of each job, as shown here:

   /* add any desired options */
   %let weba_options =
           %nrstr(compress=no
                   mprint
                   noquotelenmax;
                   libname cicomneo clear;
                   libname cicomora clear;
                   libname mafsneo clear;
                   libname mafsora clear;
                   );
   

2. If you are using a scheduler to run the deployed jobs, this approach is recommended:
   • Create a program file called clear_libs.sas containing these statements:

        libname cicomneo clear;
        libname cicomora clear;
        libname mafsneo clear;
        libname mafsora clear;
     

   • Edit each deployed job and add this statement at the beginning of the job:

        %include "/clear_libs.sas";
     

Operating System and Release Information