Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Disable Parallel Queries in BIAPPS ETL packages,

Received Response
1
Views
1
Comments
3439799
3439799 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

TABLE_MAINT_PROC - Often used for the routine table operations like creating index etc. This is automatically executing Create index commands in parallel mode with Degree 6. It is not getting enough resources on the DB and Often fails (as the Parallel query dies).

Would like to haveb the procedure in ODI TABLE_MAINT_PROC not pass any parallel query at all. Is there a way to customize the packages OR call it in such a way to disable parallel degree in Queries.

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi -

    Can you review the below parameter in your BIACM:

    pastedImage_1.png

    My understanding is that this can be set to 0/null.

    I'd invite further discussion from the group to understand if this is the ideal solution for your issue - 6 seems a bit high. I have mine set at 2 ... and we have some very large tables/indexes.

    Do you have access to the data warehouse database? If so, can you check the following:

    SQL> show parameter parallel

    Regards,

    Charles