Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.87893_CLOUD_84098_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-08-06 20:09:50 The following directories are used: CMiC Home: "/opt/cm", as specified in /home/oracle/.cms/cms.conf. Oracle Home: "D:/as10g2/midtier", default value. JSP Oracle Home: "/u01/app/oracle/midtierjsp", as specified in /home/oracle/.cms/cms.conf. Mobile Oracle Home: "/u01/app/oracle/midtiermobile", as specified in /home/oracle/.cms/cms.conf. Oracle Client Home: "/u01/app/oracle/product/19.19/PROD", as specified in /home/oracle/.cms/cms.conf. /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc7.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc6.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc8.jar Connection string: jdbc:oracle:oci:da/********@test - File: sql/2487893_2.sql: __________________________ Updating: /opt/cm/v12/test/sql/2487893_2.sql - This is a new file, no information available on disk - size (new file): 10396 bytes - last modified (new file): 2024-08-06 16:44:12.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_09_51.753/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_09_51.753/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_09_51.753/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2487893_2.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_09_51.753/2487893_2.sql.sh to run 2487893_2.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_09_51.753/2487893_2.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_09_51.753/2487893_2.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 6 20:10:10 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 24.87893, Work Item 2 -- Pogue - CMIC API Exception Issues -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2487893_2.sql Output in 2487893_2.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at line 1 Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,636 INDEX 53,119 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,998 TABLE 35,490 TABLE PARTITION 20,863 17 TRIGGER 266 TYPE 10,398 6 VIEW -------- ********** -------- 144,174 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,301 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,912 sum 1 230 JS80 INDEX 20 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 20 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 427 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,297 35 VIEW -------- ********** -------- 6,332 sum 35 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 164,046 60 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('da'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('dar'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('owf_mgr'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('uig'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('js80'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('jsr'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('jsd'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== BEGIN sys.dbms_utility.compile_schema(upper('cmic_bi'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== Begin * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 6 ORA-06512: at line 6 start additional_compx.sql 2024-08-06 20:10:23 special list (before special recompiling) 2024-08-06 20:10:24 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-06 20:10:27 special list (after special recompiling) 2024-08-06 20:10:28 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,636 INDEX 53,119 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,998 TABLE 35,490 TABLE PARTITION 20,863 17 TRIGGER 266 TYPE 10,398 6 VIEW -------- ********** -------- 144,174 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,301 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,912 sum 1 230 JS80 INDEX 20 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 20 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 427 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,297 35 VIEW -------- ********** -------- 6,332 sum 35 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 164,046 60 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 06-AUG-24 08.10.29.936166 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== Table created. -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Get the current State of the Database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at line 1 -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,636 INDEX 53,119 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,998 TABLE 35,490 TABLE PARTITION 20,863 17 TRIGGER 266 TYPE 10,398 6 VIEW -------- ********** -------- 144,174 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,301 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,912 sum 1 230 JS80 INDEX 20 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 20 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 427 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,297 35 VIEW -------- ********** -------- 6,332 sum 35 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 164,046 60 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('da'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('dar'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('owf_mgr'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('uig'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('js80'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('jsr'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== BEGIN sys.dbms_utility.compile_schema(upper('jsd'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== BEGIN sys.dbms_utility.compile_schema(upper('cmic_bi'), false, true); END; * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 1 ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== Begin * ERROR at line 1: ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 ORA-06512: at "SYS.DBMS_UTILITY", line 439 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 5065 ORA-06512: at "SYS.DBMS_STATS", line 40725 ORA-06512: at "SYS.UTL_RECOMP", line 260 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at "SYS.UTL_RECOMP", line 940 ORA-06512: at "SYS.DBMS_UTILITY", line 435 ORA-06512: at line 6 ORA-06512: at line 6 start additional_compx.sql 2024-08-06 20:11:25 special list (before special recompiling) 2024-08-06 20:11:25 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-06 20:11:28 special list (after special recompiling) 2024-08-06 20:11:28 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,636 INDEX 53,119 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,998 TABLE 35,490 TABLE PARTITION 20,863 17 TRIGGER 266 TYPE 10,398 6 VIEW -------- ********** -------- 144,174 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,301 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,912 sum 1 230 JS80 INDEX 20 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 20 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 427 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,297 35 VIEW -------- ********** -------- 6,332 sum 35 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 164,046 60 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 06-AUG-24 08.11.30.563512 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2487893_2.sql completed. Output in 2487893_2.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.87893 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 216 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 98 | * 99 | ERROR at line 1: 100 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 101 | ORA-06512: at "SYS.UTL_RECOMP", line 927 99 | ERROR at line 1: 100 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 101 | ORA-06512: at "SYS.UTL_RECOMP", line 927 102 | ORA-06512: at "SYS.DBMS_STATS", line 40799 100 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 101 | ORA-06512: at "SYS.UTL_RECOMP", line 927 102 | ORA-06512: at "SYS.DBMS_STATS", line 40799 103 | ORA-06512: at "SYS.DBMS_STATS", line 5065 101 | ORA-06512: at "SYS.UTL_RECOMP", line 927 102 | ORA-06512: at "SYS.DBMS_STATS", line 40799 103 | ORA-06512: at "SYS.DBMS_STATS", line 5065 104 | ORA-06512: at "SYS.DBMS_STATS", line 40725 102 | ORA-06512: at "SYS.DBMS_STATS", line 40799 103 | ORA-06512: at "SYS.DBMS_STATS", line 5065 104 | ORA-06512: at "SYS.DBMS_STATS", line 40725 105 | ORA-06512: at "SYS.UTL_RECOMP", line 260 103 | ORA-06512: at "SYS.DBMS_STATS", line 5065 104 | ORA-06512: at "SYS.DBMS_STATS", line 40725 105 | ORA-06512: at "SYS.UTL_RECOMP", line 260 106 | ORA-06512: at "SYS.UTL_RECOMP", line 830 104 | ORA-06512: at "SYS.DBMS_STATS", line 40725 105 | ORA-06512: at "SYS.UTL_RECOMP", line 260 106 | ORA-06512: at "SYS.UTL_RECOMP", line 830 107 | ORA-06512: at line 1 105 | ORA-06512: at "SYS.UTL_RECOMP", line 260 106 | ORA-06512: at "SYS.UTL_RECOMP", line 830 107 | ORA-06512: at line 1 108 | 252 | * 253 | ERROR at line 1: 254 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 255 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 253 | ERROR at line 1: 254 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 255 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 256 | ORA-06512: at "SYS.UTL_RECOMP", line 927 254 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 255 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 256 | ORA-06512: at "SYS.UTL_RECOMP", line 927 257 | ORA-06512: at "SYS.DBMS_STATS", line 40799 255 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 256 | ORA-06512: at "SYS.UTL_RECOMP", line 927 257 | ORA-06512: at "SYS.DBMS_STATS", line 40799 258 | ORA-06512: at "SYS.DBMS_STATS", line 5065 256 | ORA-06512: at "SYS.UTL_RECOMP", line 927 257 | ORA-06512: at "SYS.DBMS_STATS", line 40799 258 | ORA-06512: at "SYS.DBMS_STATS", line 5065 259 | ORA-06512: at "SYS.DBMS_STATS", line 40725 257 | ORA-06512: at "SYS.DBMS_STATS", line 40799 258 | ORA-06512: at "SYS.DBMS_STATS", line 5065 259 | ORA-06512: at "SYS.DBMS_STATS", line 40725 260 | ORA-06512: at "SYS.UTL_RECOMP", line 260 258 | ORA-06512: at "SYS.DBMS_STATS", line 5065 259 | ORA-06512: at "SYS.DBMS_STATS", line 40725 260 | ORA-06512: at "SYS.UTL_RECOMP", line 260 261 | ORA-06512: at "SYS.UTL_RECOMP", line 830 259 | ORA-06512: at "SYS.DBMS_STATS", line 40725 260 | ORA-06512: at "SYS.UTL_RECOMP", line 260 261 | ORA-06512: at "SYS.UTL_RECOMP", line 830 262 | ORA-06512: at "SYS.UTL_RECOMP", line 940 260 | ORA-06512: at "SYS.UTL_RECOMP", line 260 261 | ORA-06512: at "SYS.UTL_RECOMP", line 830 262 | ORA-06512: at "SYS.UTL_RECOMP", line 940 263 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 261 | ORA-06512: at "SYS.UTL_RECOMP", line 830 262 | ORA-06512: at "SYS.UTL_RECOMP", line 940 263 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 264 | ORA-06512: at line 1 262 | ORA-06512: at "SYS.UTL_RECOMP", line 940 263 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 264 | ORA-06512: at line 1 265 | 273 | * 274 | ERROR at line 1: 275 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 276 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 274 | ERROR at line 1: 275 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 276 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 277 | ORA-06512: at "SYS.UTL_RECOMP", line 927 275 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 276 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 277 | ORA-06512: at "SYS.UTL_RECOMP", line 927 278 | ORA-06512: at "SYS.DBMS_STATS", line 40799 276 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 277 | ORA-06512: at "SYS.UTL_RECOMP", line 927 278 | ORA-06512: at "SYS.DBMS_STATS", line 40799 279 | ORA-06512: at "SYS.DBMS_STATS", line 5065 277 | ORA-06512: at "SYS.UTL_RECOMP", line 927 278 | ORA-06512: at "SYS.DBMS_STATS", line 40799 279 | ORA-06512: at "SYS.DBMS_STATS", line 5065 280 | ORA-06512: at "SYS.DBMS_STATS", line 40725 278 | ORA-06512: at "SYS.DBMS_STATS", line 40799 279 | ORA-06512: at "SYS.DBMS_STATS", line 5065 280 | ORA-06512: at "SYS.DBMS_STATS", line 40725 281 | ORA-06512: at "SYS.UTL_RECOMP", line 260 279 | ORA-06512: at "SYS.DBMS_STATS", line 5065 280 | ORA-06512: at "SYS.DBMS_STATS", line 40725 281 | ORA-06512: at "SYS.UTL_RECOMP", line 260 282 | ORA-06512: at "SYS.UTL_RECOMP", line 830 280 | ORA-06512: at "SYS.DBMS_STATS", line 40725 281 | ORA-06512: at "SYS.UTL_RECOMP", line 260 282 | ORA-06512: at "SYS.UTL_RECOMP", line 830 283 | ORA-06512: at "SYS.UTL_RECOMP", line 940 281 | ORA-06512: at "SYS.UTL_RECOMP", line 260 282 | ORA-06512: at "SYS.UTL_RECOMP", line 830 283 | ORA-06512: at "SYS.UTL_RECOMP", line 940 284 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 282 | ORA-06512: at "SYS.UTL_RECOMP", line 830 283 | ORA-06512: at "SYS.UTL_RECOMP", line 940 284 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 285 | ORA-06512: at line 1 283 | ORA-06512: at "SYS.UTL_RECOMP", line 940 284 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 285 | ORA-06512: at line 1 286 | 294 | * 295 | ERROR at line 1: 296 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 297 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 295 | ERROR at line 1: 296 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 297 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 298 | ORA-06512: at "SYS.UTL_RECOMP", line 927 296 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 297 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 298 | ORA-06512: at "SYS.UTL_RECOMP", line 927 299 | ORA-06512: at "SYS.DBMS_STATS", line 40799 297 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 298 | ORA-06512: at "SYS.UTL_RECOMP", line 927 299 | ORA-06512: at "SYS.DBMS_STATS", line 40799 300 | ORA-06512: at "SYS.DBMS_STATS", line 5065 298 | ORA-06512: at "SYS.UTL_RECOMP", line 927 299 | ORA-06512: at "SYS.DBMS_STATS", line 40799 300 | ORA-06512: at "SYS.DBMS_STATS", line 5065 301 | ORA-06512: at "SYS.DBMS_STATS", line 40725 299 | ORA-06512: at "SYS.DBMS_STATS", line 40799 300 | ORA-06512: at "SYS.DBMS_STATS", line 5065 301 | ORA-06512: at "SYS.DBMS_STATS", line 40725 302 | ORA-06512: at "SYS.UTL_RECOMP", line 260 300 | ORA-06512: at "SYS.DBMS_STATS", line 5065 301 | ORA-06512: at "SYS.DBMS_STATS", line 40725 302 | ORA-06512: at "SYS.UTL_RECOMP", line 260 303 | ORA-06512: at "SYS.UTL_RECOMP", line 830 301 | ORA-06512: at "SYS.DBMS_STATS", line 40725 302 | ORA-06512: at "SYS.UTL_RECOMP", line 260 303 | ORA-06512: at "SYS.UTL_RECOMP", line 830 304 | ORA-06512: at "SYS.UTL_RECOMP", line 940 302 | ORA-06512: at "SYS.UTL_RECOMP", line 260 303 | ORA-06512: at "SYS.UTL_RECOMP", line 830 304 | ORA-06512: at "SYS.UTL_RECOMP", line 940 305 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 303 | ORA-06512: at "SYS.UTL_RECOMP", line 830 304 | ORA-06512: at "SYS.UTL_RECOMP", line 940 305 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 306 | ORA-06512: at line 1 304 | ORA-06512: at "SYS.UTL_RECOMP", line 940 305 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 306 | ORA-06512: at line 1 307 | 315 | * 316 | ERROR at line 1: 317 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 318 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 316 | ERROR at line 1: 317 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 318 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 319 | ORA-06512: at "SYS.UTL_RECOMP", line 927 317 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 318 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 319 | ORA-06512: at "SYS.UTL_RECOMP", line 927 320 | ORA-06512: at "SYS.DBMS_STATS", line 40799 318 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 319 | ORA-06512: at "SYS.UTL_RECOMP", line 927 320 | ORA-06512: at "SYS.DBMS_STATS", line 40799 321 | ORA-06512: at "SYS.DBMS_STATS", line 5065 319 | ORA-06512: at "SYS.UTL_RECOMP", line 927 320 | ORA-06512: at "SYS.DBMS_STATS", line 40799 321 | ORA-06512: at "SYS.DBMS_STATS", line 5065 322 | ORA-06512: at "SYS.DBMS_STATS", line 40725 320 | ORA-06512: at "SYS.DBMS_STATS", line 40799 321 | ORA-06512: at "SYS.DBMS_STATS", line 5065 322 | ORA-06512: at "SYS.DBMS_STATS", line 40725 323 | ORA-06512: at "SYS.UTL_RECOMP", line 260 321 | ORA-06512: at "SYS.DBMS_STATS", line 5065 322 | ORA-06512: at "SYS.DBMS_STATS", line 40725 323 | ORA-06512: at "SYS.UTL_RECOMP", line 260 324 | ORA-06512: at "SYS.UTL_RECOMP", line 830 322 | ORA-06512: at "SYS.DBMS_STATS", line 40725 323 | ORA-06512: at "SYS.UTL_RECOMP", line 260 324 | ORA-06512: at "SYS.UTL_RECOMP", line 830 325 | ORA-06512: at "SYS.UTL_RECOMP", line 940 323 | ORA-06512: at "SYS.UTL_RECOMP", line 260 324 | ORA-06512: at "SYS.UTL_RECOMP", line 830 325 | ORA-06512: at "SYS.UTL_RECOMP", line 940 326 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 324 | ORA-06512: at "SYS.UTL_RECOMP", line 830 325 | ORA-06512: at "SYS.UTL_RECOMP", line 940 326 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 327 | ORA-06512: at line 1 325 | ORA-06512: at "SYS.UTL_RECOMP", line 940 326 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 327 | ORA-06512: at line 1 328 | 336 | * 337 | ERROR at line 1: 338 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 339 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 337 | ERROR at line 1: 338 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 339 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 340 | ORA-06512: at "SYS.UTL_RECOMP", line 927 338 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 339 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 340 | ORA-06512: at "SYS.UTL_RECOMP", line 927 341 | ORA-06512: at "SYS.DBMS_STATS", line 40799 339 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 340 | ORA-06512: at "SYS.UTL_RECOMP", line 927 341 | ORA-06512: at "SYS.DBMS_STATS", line 40799 342 | ORA-06512: at "SYS.DBMS_STATS", line 5065 340 | ORA-06512: at "SYS.UTL_RECOMP", line 927 341 | ORA-06512: at "SYS.DBMS_STATS", line 40799 342 | ORA-06512: at "SYS.DBMS_STATS", line 5065 343 | ORA-06512: at "SYS.DBMS_STATS", line 40725 341 | ORA-06512: at "SYS.DBMS_STATS", line 40799 342 | ORA-06512: at "SYS.DBMS_STATS", line 5065 343 | ORA-06512: at "SYS.DBMS_STATS", line 40725 344 | ORA-06512: at "SYS.UTL_RECOMP", line 260 342 | ORA-06512: at "SYS.DBMS_STATS", line 5065 343 | ORA-06512: at "SYS.DBMS_STATS", line 40725 344 | ORA-06512: at "SYS.UTL_RECOMP", line 260 345 | ORA-06512: at "SYS.UTL_RECOMP", line 830 343 | ORA-06512: at "SYS.DBMS_STATS", line 40725 344 | ORA-06512: at "SYS.UTL_RECOMP", line 260 345 | ORA-06512: at "SYS.UTL_RECOMP", line 830 346 | ORA-06512: at "SYS.UTL_RECOMP", line 940 344 | ORA-06512: at "SYS.UTL_RECOMP", line 260 345 | ORA-06512: at "SYS.UTL_RECOMP", line 830 346 | ORA-06512: at "SYS.UTL_RECOMP", line 940 347 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 345 | ORA-06512: at "SYS.UTL_RECOMP", line 830 346 | ORA-06512: at "SYS.UTL_RECOMP", line 940 347 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 348 | ORA-06512: at line 1 346 | ORA-06512: at "SYS.UTL_RECOMP", line 940 347 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 348 | ORA-06512: at line 1 349 | 357 | * 358 | ERROR at line 1: 359 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 360 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 358 | ERROR at line 1: 359 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 360 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 361 | ORA-06512: at "SYS.UTL_RECOMP", line 927 359 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 360 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 361 | ORA-06512: at "SYS.UTL_RECOMP", line 927 362 | ORA-06512: at "SYS.DBMS_STATS", line 40799 360 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 361 | ORA-06512: at "SYS.UTL_RECOMP", line 927 362 | ORA-06512: at "SYS.DBMS_STATS", line 40799 363 | ORA-06512: at "SYS.DBMS_STATS", line 5065 361 | ORA-06512: at "SYS.UTL_RECOMP", line 927 362 | ORA-06512: at "SYS.DBMS_STATS", line 40799 363 | ORA-06512: at "SYS.DBMS_STATS", line 5065 364 | ORA-06512: at "SYS.DBMS_STATS", line 40725 362 | ORA-06512: at "SYS.DBMS_STATS", line 40799 363 | ORA-06512: at "SYS.DBMS_STATS", line 5065 364 | ORA-06512: at "SYS.DBMS_STATS", line 40725 365 | ORA-06512: at "SYS.UTL_RECOMP", line 260 363 | ORA-06512: at "SYS.DBMS_STATS", line 5065 364 | ORA-06512: at "SYS.DBMS_STATS", line 40725 365 | ORA-06512: at "SYS.UTL_RECOMP", line 260 366 | ORA-06512: at "SYS.UTL_RECOMP", line 830 364 | ORA-06512: at "SYS.DBMS_STATS", line 40725 365 | ORA-06512: at "SYS.UTL_RECOMP", line 260 366 | ORA-06512: at "SYS.UTL_RECOMP", line 830 367 | ORA-06512: at "SYS.UTL_RECOMP", line 940 365 | ORA-06512: at "SYS.UTL_RECOMP", line 260 366 | ORA-06512: at "SYS.UTL_RECOMP", line 830 367 | ORA-06512: at "SYS.UTL_RECOMP", line 940 368 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 366 | ORA-06512: at "SYS.UTL_RECOMP", line 830 367 | ORA-06512: at "SYS.UTL_RECOMP", line 940 368 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 369 | ORA-06512: at line 1 367 | ORA-06512: at "SYS.UTL_RECOMP", line 940 368 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 369 | ORA-06512: at line 1 370 | 378 | * 379 | ERROR at line 1: 380 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 381 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 379 | ERROR at line 1: 380 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 381 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 382 | ORA-06512: at "SYS.UTL_RECOMP", line 927 380 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 381 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 382 | ORA-06512: at "SYS.UTL_RECOMP", line 927 383 | ORA-06512: at "SYS.DBMS_STATS", line 40799 381 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 382 | ORA-06512: at "SYS.UTL_RECOMP", line 927 383 | ORA-06512: at "SYS.DBMS_STATS", line 40799 384 | ORA-06512: at "SYS.DBMS_STATS", line 5065 382 | ORA-06512: at "SYS.UTL_RECOMP", line 927 383 | ORA-06512: at "SYS.DBMS_STATS", line 40799 384 | ORA-06512: at "SYS.DBMS_STATS", line 5065 385 | ORA-06512: at "SYS.DBMS_STATS", line 40725 383 | ORA-06512: at "SYS.DBMS_STATS", line 40799 384 | ORA-06512: at "SYS.DBMS_STATS", line 5065 385 | ORA-06512: at "SYS.DBMS_STATS", line 40725 386 | ORA-06512: at "SYS.UTL_RECOMP", line 260 384 | ORA-06512: at "SYS.DBMS_STATS", line 5065 385 | ORA-06512: at "SYS.DBMS_STATS", line 40725 386 | ORA-06512: at "SYS.UTL_RECOMP", line 260 387 | ORA-06512: at "SYS.UTL_RECOMP", line 830 385 | ORA-06512: at "SYS.DBMS_STATS", line 40725 386 | ORA-06512: at "SYS.UTL_RECOMP", line 260 387 | ORA-06512: at "SYS.UTL_RECOMP", line 830 388 | ORA-06512: at "SYS.UTL_RECOMP", line 940 386 | ORA-06512: at "SYS.UTL_RECOMP", line 260 387 | ORA-06512: at "SYS.UTL_RECOMP", line 830 388 | ORA-06512: at "SYS.UTL_RECOMP", line 940 389 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 387 | ORA-06512: at "SYS.UTL_RECOMP", line 830 388 | ORA-06512: at "SYS.UTL_RECOMP", line 940 389 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 390 | ORA-06512: at line 1 388 | ORA-06512: at "SYS.UTL_RECOMP", line 940 389 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 390 | ORA-06512: at line 1 391 | 399 | * 400 | ERROR at line 1: 401 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 402 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 400 | ERROR at line 1: 401 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 402 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 403 | ORA-06512: at "SYS.UTL_RECOMP", line 927 401 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 402 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 403 | ORA-06512: at "SYS.UTL_RECOMP", line 927 404 | ORA-06512: at "SYS.DBMS_STATS", line 40799 402 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 403 | ORA-06512: at "SYS.UTL_RECOMP", line 927 404 | ORA-06512: at "SYS.DBMS_STATS", line 40799 405 | ORA-06512: at "SYS.DBMS_STATS", line 5065 403 | ORA-06512: at "SYS.UTL_RECOMP", line 927 404 | ORA-06512: at "SYS.DBMS_STATS", line 40799 405 | ORA-06512: at "SYS.DBMS_STATS", line 5065 406 | ORA-06512: at "SYS.DBMS_STATS", line 40725 404 | ORA-06512: at "SYS.DBMS_STATS", line 40799 405 | ORA-06512: at "SYS.DBMS_STATS", line 5065 406 | ORA-06512: at "SYS.DBMS_STATS", line 40725 407 | ORA-06512: at "SYS.UTL_RECOMP", line 260 405 | ORA-06512: at "SYS.DBMS_STATS", line 5065 406 | ORA-06512: at "SYS.DBMS_STATS", line 40725 407 | ORA-06512: at "SYS.UTL_RECOMP", line 260 408 | ORA-06512: at "SYS.UTL_RECOMP", line 830 406 | ORA-06512: at "SYS.DBMS_STATS", line 40725 407 | ORA-06512: at "SYS.UTL_RECOMP", line 260 408 | ORA-06512: at "SYS.UTL_RECOMP", line 830 409 | ORA-06512: at "SYS.UTL_RECOMP", line 940 407 | ORA-06512: at "SYS.UTL_RECOMP", line 260 408 | ORA-06512: at "SYS.UTL_RECOMP", line 830 409 | ORA-06512: at "SYS.UTL_RECOMP", line 940 410 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 408 | ORA-06512: at "SYS.UTL_RECOMP", line 830 409 | ORA-06512: at "SYS.UTL_RECOMP", line 940 410 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 411 | ORA-06512: at line 1 409 | ORA-06512: at "SYS.UTL_RECOMP", line 940 410 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 411 | ORA-06512: at line 1 412 | 419 | * 420 | ERROR at line 1: 421 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 422 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 420 | ERROR at line 1: 421 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 422 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 423 | ORA-06512: at "SYS.UTL_RECOMP", line 927 421 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 422 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 423 | ORA-06512: at "SYS.UTL_RECOMP", line 927 424 | ORA-06512: at "SYS.DBMS_STATS", line 40799 422 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 423 | ORA-06512: at "SYS.UTL_RECOMP", line 927 424 | ORA-06512: at "SYS.DBMS_STATS", line 40799 425 | ORA-06512: at "SYS.DBMS_STATS", line 5065 423 | ORA-06512: at "SYS.UTL_RECOMP", line 927 424 | ORA-06512: at "SYS.DBMS_STATS", line 40799 425 | ORA-06512: at "SYS.DBMS_STATS", line 5065 426 | ORA-06512: at "SYS.DBMS_STATS", line 40725 424 | ORA-06512: at "SYS.DBMS_STATS", line 40799 425 | ORA-06512: at "SYS.DBMS_STATS", line 5065 426 | ORA-06512: at "SYS.DBMS_STATS", line 40725 427 | ORA-06512: at "SYS.UTL_RECOMP", line 260 425 | ORA-06512: at "SYS.DBMS_STATS", line 5065 426 | ORA-06512: at "SYS.DBMS_STATS", line 40725 427 | ORA-06512: at "SYS.UTL_RECOMP", line 260 428 | ORA-06512: at "SYS.UTL_RECOMP", line 830 426 | ORA-06512: at "SYS.DBMS_STATS", line 40725 427 | ORA-06512: at "SYS.UTL_RECOMP", line 260 428 | ORA-06512: at "SYS.UTL_RECOMP", line 830 429 | ORA-06512: at "SYS.UTL_RECOMP", line 940 427 | ORA-06512: at "SYS.UTL_RECOMP", line 260 428 | ORA-06512: at "SYS.UTL_RECOMP", line 830 429 | ORA-06512: at "SYS.UTL_RECOMP", line 940 430 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 428 | ORA-06512: at "SYS.UTL_RECOMP", line 830 429 | ORA-06512: at "SYS.UTL_RECOMP", line 940 430 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 431 | ORA-06512: at line 6 429 | ORA-06512: at "SYS.UTL_RECOMP", line 940 430 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 431 | ORA-06512: at line 6 432 | ORA-06512: at line 6 430 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 431 | ORA-06512: at line 6 432 | ORA-06512: at line 6 433 | 699 | * 700 | ERROR at line 1: 701 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 702 | ORA-06512: at "SYS.UTL_RECOMP", line 927 700 | ERROR at line 1: 701 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 702 | ORA-06512: at "SYS.UTL_RECOMP", line 927 703 | ORA-06512: at "SYS.DBMS_STATS", line 40799 701 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 702 | ORA-06512: at "SYS.UTL_RECOMP", line 927 703 | ORA-06512: at "SYS.DBMS_STATS", line 40799 704 | ORA-06512: at "SYS.DBMS_STATS", line 5065 702 | ORA-06512: at "SYS.UTL_RECOMP", line 927 703 | ORA-06512: at "SYS.DBMS_STATS", line 40799 704 | ORA-06512: at "SYS.DBMS_STATS", line 5065 705 | ORA-06512: at "SYS.DBMS_STATS", line 40725 703 | ORA-06512: at "SYS.DBMS_STATS", line 40799 704 | ORA-06512: at "SYS.DBMS_STATS", line 5065 705 | ORA-06512: at "SYS.DBMS_STATS", line 40725 706 | ORA-06512: at "SYS.UTL_RECOMP", line 260 704 | ORA-06512: at "SYS.DBMS_STATS", line 5065 705 | ORA-06512: at "SYS.DBMS_STATS", line 40725 706 | ORA-06512: at "SYS.UTL_RECOMP", line 260 707 | ORA-06512: at "SYS.UTL_RECOMP", line 830 705 | ORA-06512: at "SYS.DBMS_STATS", line 40725 706 | ORA-06512: at "SYS.UTL_RECOMP", line 260 707 | ORA-06512: at "SYS.UTL_RECOMP", line 830 708 | ORA-06512: at line 1 706 | ORA-06512: at "SYS.UTL_RECOMP", line 260 707 | ORA-06512: at "SYS.UTL_RECOMP", line 830 708 | ORA-06512: at line 1 709 | 850 | * 851 | ERROR at line 1: 852 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 853 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 851 | ERROR at line 1: 852 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 853 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 854 | ORA-06512: at "SYS.UTL_RECOMP", line 927 852 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 853 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 854 | ORA-06512: at "SYS.UTL_RECOMP", line 927 855 | ORA-06512: at "SYS.DBMS_STATS", line 40799 853 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 854 | ORA-06512: at "SYS.UTL_RECOMP", line 927 855 | ORA-06512: at "SYS.DBMS_STATS", line 40799 856 | ORA-06512: at "SYS.DBMS_STATS", line 5065 854 | ORA-06512: at "SYS.UTL_RECOMP", line 927 855 | ORA-06512: at "SYS.DBMS_STATS", line 40799 856 | ORA-06512: at "SYS.DBMS_STATS", line 5065 857 | ORA-06512: at "SYS.DBMS_STATS", line 40725 855 | ORA-06512: at "SYS.DBMS_STATS", line 40799 856 | ORA-06512: at "SYS.DBMS_STATS", line 5065 857 | ORA-06512: at "SYS.DBMS_STATS", line 40725 858 | ORA-06512: at "SYS.UTL_RECOMP", line 260 856 | ORA-06512: at "SYS.DBMS_STATS", line 5065 857 | ORA-06512: at "SYS.DBMS_STATS", line 40725 858 | ORA-06512: at "SYS.UTL_RECOMP", line 260 859 | ORA-06512: at "SYS.UTL_RECOMP", line 830 857 | ORA-06512: at "SYS.DBMS_STATS", line 40725 858 | ORA-06512: at "SYS.UTL_RECOMP", line 260 859 | ORA-06512: at "SYS.UTL_RECOMP", line 830 860 | ORA-06512: at "SYS.UTL_RECOMP", line 940 858 | ORA-06512: at "SYS.UTL_RECOMP", line 260 859 | ORA-06512: at "SYS.UTL_RECOMP", line 830 860 | ORA-06512: at "SYS.UTL_RECOMP", line 940 861 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 859 | ORA-06512: at "SYS.UTL_RECOMP", line 830 860 | ORA-06512: at "SYS.UTL_RECOMP", line 940 861 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 862 | ORA-06512: at line 1 860 | ORA-06512: at "SYS.UTL_RECOMP", line 940 861 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 862 | ORA-06512: at line 1 863 | 871 | * 872 | ERROR at line 1: 873 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 874 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 872 | ERROR at line 1: 873 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 874 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 875 | ORA-06512: at "SYS.UTL_RECOMP", line 927 873 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 874 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 875 | ORA-06512: at "SYS.UTL_RECOMP", line 927 876 | ORA-06512: at "SYS.DBMS_STATS", line 40799 874 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 875 | ORA-06512: at "SYS.UTL_RECOMP", line 927 876 | ORA-06512: at "SYS.DBMS_STATS", line 40799 877 | ORA-06512: at "SYS.DBMS_STATS", line 5065 875 | ORA-06512: at "SYS.UTL_RECOMP", line 927 876 | ORA-06512: at "SYS.DBMS_STATS", line 40799 877 | ORA-06512: at "SYS.DBMS_STATS", line 5065 878 | ORA-06512: at "SYS.DBMS_STATS", line 40725 876 | ORA-06512: at "SYS.DBMS_STATS", line 40799 877 | ORA-06512: at "SYS.DBMS_STATS", line 5065 878 | ORA-06512: at "SYS.DBMS_STATS", line 40725 879 | ORA-06512: at "SYS.UTL_RECOMP", line 260 877 | ORA-06512: at "SYS.DBMS_STATS", line 5065 878 | ORA-06512: at "SYS.DBMS_STATS", line 40725 879 | ORA-06512: at "SYS.UTL_RECOMP", line 260 880 | ORA-06512: at "SYS.UTL_RECOMP", line 830 878 | ORA-06512: at "SYS.DBMS_STATS", line 40725 879 | ORA-06512: at "SYS.UTL_RECOMP", line 260 880 | ORA-06512: at "SYS.UTL_RECOMP", line 830 881 | ORA-06512: at "SYS.UTL_RECOMP", line 940 879 | ORA-06512: at "SYS.UTL_RECOMP", line 260 880 | ORA-06512: at "SYS.UTL_RECOMP", line 830 881 | ORA-06512: at "SYS.UTL_RECOMP", line 940 882 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 880 | ORA-06512: at "SYS.UTL_RECOMP", line 830 881 | ORA-06512: at "SYS.UTL_RECOMP", line 940 882 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 883 | ORA-06512: at line 1 881 | ORA-06512: at "SYS.UTL_RECOMP", line 940 882 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 883 | ORA-06512: at line 1 884 | 892 | * 893 | ERROR at line 1: 894 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 895 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 893 | ERROR at line 1: 894 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 895 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 896 | ORA-06512: at "SYS.UTL_RECOMP", line 927 894 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 895 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 896 | ORA-06512: at "SYS.UTL_RECOMP", line 927 897 | ORA-06512: at "SYS.DBMS_STATS", line 40799 895 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 896 | ORA-06512: at "SYS.UTL_RECOMP", line 927 897 | ORA-06512: at "SYS.DBMS_STATS", line 40799 898 | ORA-06512: at "SYS.DBMS_STATS", line 5065 896 | ORA-06512: at "SYS.UTL_RECOMP", line 927 897 | ORA-06512: at "SYS.DBMS_STATS", line 40799 898 | ORA-06512: at "SYS.DBMS_STATS", line 5065 899 | ORA-06512: at "SYS.DBMS_STATS", line 40725 897 | ORA-06512: at "SYS.DBMS_STATS", line 40799 898 | ORA-06512: at "SYS.DBMS_STATS", line 5065 899 | ORA-06512: at "SYS.DBMS_STATS", line 40725 900 | ORA-06512: at "SYS.UTL_RECOMP", line 260 898 | ORA-06512: at "SYS.DBMS_STATS", line 5065 899 | ORA-06512: at "SYS.DBMS_STATS", line 40725 900 | ORA-06512: at "SYS.UTL_RECOMP", line 260 901 | ORA-06512: at "SYS.UTL_RECOMP", line 830 899 | ORA-06512: at "SYS.DBMS_STATS", line 40725 900 | ORA-06512: at "SYS.UTL_RECOMP", line 260 901 | ORA-06512: at "SYS.UTL_RECOMP", line 830 902 | ORA-06512: at "SYS.UTL_RECOMP", line 940 900 | ORA-06512: at "SYS.UTL_RECOMP", line 260 901 | ORA-06512: at "SYS.UTL_RECOMP", line 830 902 | ORA-06512: at "SYS.UTL_RECOMP", line 940 903 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 901 | ORA-06512: at "SYS.UTL_RECOMP", line 830 902 | ORA-06512: at "SYS.UTL_RECOMP", line 940 903 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 904 | ORA-06512: at line 1 902 | ORA-06512: at "SYS.UTL_RECOMP", line 940 903 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 904 | ORA-06512: at line 1 905 | 913 | * 914 | ERROR at line 1: 915 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 916 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 914 | ERROR at line 1: 915 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 916 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 917 | ORA-06512: at "SYS.UTL_RECOMP", line 927 915 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 916 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 917 | ORA-06512: at "SYS.UTL_RECOMP", line 927 918 | ORA-06512: at "SYS.DBMS_STATS", line 40799 916 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 917 | ORA-06512: at "SYS.UTL_RECOMP", line 927 918 | ORA-06512: at "SYS.DBMS_STATS", line 40799 919 | ORA-06512: at "SYS.DBMS_STATS", line 5065 917 | ORA-06512: at "SYS.UTL_RECOMP", line 927 918 | ORA-06512: at "SYS.DBMS_STATS", line 40799 919 | ORA-06512: at "SYS.DBMS_STATS", line 5065 920 | ORA-06512: at "SYS.DBMS_STATS", line 40725 918 | ORA-06512: at "SYS.DBMS_STATS", line 40799 919 | ORA-06512: at "SYS.DBMS_STATS", line 5065 920 | ORA-06512: at "SYS.DBMS_STATS", line 40725 921 | ORA-06512: at "SYS.UTL_RECOMP", line 260 919 | ORA-06512: at "SYS.DBMS_STATS", line 5065 920 | ORA-06512: at "SYS.DBMS_STATS", line 40725 921 | ORA-06512: at "SYS.UTL_RECOMP", line 260 922 | ORA-06512: at "SYS.UTL_RECOMP", line 830 920 | ORA-06512: at "SYS.DBMS_STATS", line 40725 921 | ORA-06512: at "SYS.UTL_RECOMP", line 260 922 | ORA-06512: at "SYS.UTL_RECOMP", line 830 923 | ORA-06512: at "SYS.UTL_RECOMP", line 940 921 | ORA-06512: at "SYS.UTL_RECOMP", line 260 922 | ORA-06512: at "SYS.UTL_RECOMP", line 830 923 | ORA-06512: at "SYS.UTL_RECOMP", line 940 924 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 922 | ORA-06512: at "SYS.UTL_RECOMP", line 830 923 | ORA-06512: at "SYS.UTL_RECOMP", line 940 924 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 925 | ORA-06512: at line 1 923 | ORA-06512: at "SYS.UTL_RECOMP", line 940 924 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 925 | ORA-06512: at line 1 926 | 934 | * 935 | ERROR at line 1: 936 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 937 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 935 | ERROR at line 1: 936 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 937 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 938 | ORA-06512: at "SYS.UTL_RECOMP", line 927 936 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 937 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 938 | ORA-06512: at "SYS.UTL_RECOMP", line 927 939 | ORA-06512: at "SYS.DBMS_STATS", line 40799 937 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 938 | ORA-06512: at "SYS.UTL_RECOMP", line 927 939 | ORA-06512: at "SYS.DBMS_STATS", line 40799 940 | ORA-06512: at "SYS.DBMS_STATS", line 5065 938 | ORA-06512: at "SYS.UTL_RECOMP", line 927 939 | ORA-06512: at "SYS.DBMS_STATS", line 40799 940 | ORA-06512: at "SYS.DBMS_STATS", line 5065 941 | ORA-06512: at "SYS.DBMS_STATS", line 40725 939 | ORA-06512: at "SYS.DBMS_STATS", line 40799 940 | ORA-06512: at "SYS.DBMS_STATS", line 5065 941 | ORA-06512: at "SYS.DBMS_STATS", line 40725 942 | ORA-06512: at "SYS.UTL_RECOMP", line 260 940 | ORA-06512: at "SYS.DBMS_STATS", line 5065 941 | ORA-06512: at "SYS.DBMS_STATS", line 40725 942 | ORA-06512: at "SYS.UTL_RECOMP", line 260 943 | ORA-06512: at "SYS.UTL_RECOMP", line 830 941 | ORA-06512: at "SYS.DBMS_STATS", line 40725 942 | ORA-06512: at "SYS.UTL_RECOMP", line 260 943 | ORA-06512: at "SYS.UTL_RECOMP", line 830 944 | ORA-06512: at "SYS.UTL_RECOMP", line 940 942 | ORA-06512: at "SYS.UTL_RECOMP", line 260 943 | ORA-06512: at "SYS.UTL_RECOMP", line 830 944 | ORA-06512: at "SYS.UTL_RECOMP", line 940 945 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 943 | ORA-06512: at "SYS.UTL_RECOMP", line 830 944 | ORA-06512: at "SYS.UTL_RECOMP", line 940 945 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 946 | ORA-06512: at line 1 944 | ORA-06512: at "SYS.UTL_RECOMP", line 940 945 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 946 | ORA-06512: at line 1 947 | 955 | * 956 | ERROR at line 1: 957 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 958 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 956 | ERROR at line 1: 957 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 958 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 959 | ORA-06512: at "SYS.UTL_RECOMP", line 927 957 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 958 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 959 | ORA-06512: at "SYS.UTL_RECOMP", line 927 960 | ORA-06512: at "SYS.DBMS_STATS", line 40799 958 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 959 | ORA-06512: at "SYS.UTL_RECOMP", line 927 960 | ORA-06512: at "SYS.DBMS_STATS", line 40799 961 | ORA-06512: at "SYS.DBMS_STATS", line 5065 959 | ORA-06512: at "SYS.UTL_RECOMP", line 927 960 | ORA-06512: at "SYS.DBMS_STATS", line 40799 961 | ORA-06512: at "SYS.DBMS_STATS", line 5065 962 | ORA-06512: at "SYS.DBMS_STATS", line 40725 960 | ORA-06512: at "SYS.DBMS_STATS", line 40799 961 | ORA-06512: at "SYS.DBMS_STATS", line 5065 962 | ORA-06512: at "SYS.DBMS_STATS", line 40725 963 | ORA-06512: at "SYS.UTL_RECOMP", line 260 961 | ORA-06512: at "SYS.DBMS_STATS", line 5065 962 | ORA-06512: at "SYS.DBMS_STATS", line 40725 963 | ORA-06512: at "SYS.UTL_RECOMP", line 260 964 | ORA-06512: at "SYS.UTL_RECOMP", line 830 962 | ORA-06512: at "SYS.DBMS_STATS", line 40725 963 | ORA-06512: at "SYS.UTL_RECOMP", line 260 964 | ORA-06512: at "SYS.UTL_RECOMP", line 830 965 | ORA-06512: at "SYS.UTL_RECOMP", line 940 963 | ORA-06512: at "SYS.UTL_RECOMP", line 260 964 | ORA-06512: at "SYS.UTL_RECOMP", line 830 965 | ORA-06512: at "SYS.UTL_RECOMP", line 940 966 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 964 | ORA-06512: at "SYS.UTL_RECOMP", line 830 965 | ORA-06512: at "SYS.UTL_RECOMP", line 940 966 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 967 | ORA-06512: at line 1 965 | ORA-06512: at "SYS.UTL_RECOMP", line 940 966 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 967 | ORA-06512: at line 1 968 | 976 | * 977 | ERROR at line 1: 978 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 979 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 977 | ERROR at line 1: 978 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 979 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 980 | ORA-06512: at "SYS.UTL_RECOMP", line 927 978 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 979 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 980 | ORA-06512: at "SYS.UTL_RECOMP", line 927 981 | ORA-06512: at "SYS.DBMS_STATS", line 40799 979 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 980 | ORA-06512: at "SYS.UTL_RECOMP", line 927 981 | ORA-06512: at "SYS.DBMS_STATS", line 40799 982 | ORA-06512: at "SYS.DBMS_STATS", line 5065 980 | ORA-06512: at "SYS.UTL_RECOMP", line 927 981 | ORA-06512: at "SYS.DBMS_STATS", line 40799 982 | ORA-06512: at "SYS.DBMS_STATS", line 5065 983 | ORA-06512: at "SYS.DBMS_STATS", line 40725 981 | ORA-06512: at "SYS.DBMS_STATS", line 40799 982 | ORA-06512: at "SYS.DBMS_STATS", line 5065 983 | ORA-06512: at "SYS.DBMS_STATS", line 40725 984 | ORA-06512: at "SYS.UTL_RECOMP", line 260 982 | ORA-06512: at "SYS.DBMS_STATS", line 5065 983 | ORA-06512: at "SYS.DBMS_STATS", line 40725 984 | ORA-06512: at "SYS.UTL_RECOMP", line 260 985 | ORA-06512: at "SYS.UTL_RECOMP", line 830 983 | ORA-06512: at "SYS.DBMS_STATS", line 40725 984 | ORA-06512: at "SYS.UTL_RECOMP", line 260 985 | ORA-06512: at "SYS.UTL_RECOMP", line 830 986 | ORA-06512: at "SYS.UTL_RECOMP", line 940 984 | ORA-06512: at "SYS.UTL_RECOMP", line 260 985 | ORA-06512: at "SYS.UTL_RECOMP", line 830 986 | ORA-06512: at "SYS.UTL_RECOMP", line 940 987 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 985 | ORA-06512: at "SYS.UTL_RECOMP", line 830 986 | ORA-06512: at "SYS.UTL_RECOMP", line 940 987 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 988 | ORA-06512: at line 1 986 | ORA-06512: at "SYS.UTL_RECOMP", line 940 987 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 988 | ORA-06512: at line 1 989 | 997 | * 998 | ERROR at line 1: 999 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1000 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 998 | ERROR at line 1: 999 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1000 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1001 | ORA-06512: at "SYS.UTL_RECOMP", line 927 999 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1000 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1001 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1000 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1001 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1003 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1001 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1003 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1004 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1003 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1004 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1003 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1004 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1006 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1004 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1006 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1007 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1006 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1007 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1008 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1006 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1007 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1008 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1009 | ORA-06512: at line 1 1007 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1008 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1009 | ORA-06512: at line 1 1010 | 1017 | * 1018 | ERROR at line 1: 1019 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1018 | ERROR at line 1: 1019 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1021 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1019 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1021 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1022 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1021 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1022 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1023 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1021 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1022 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1023 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1024 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1022 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1023 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1024 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1025 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1023 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1024 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1025 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1026 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1024 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1025 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1026 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1027 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1025 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1026 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1027 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1028 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1026 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1027 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1028 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1029 | ORA-06512: at line 6 1027 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1028 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1029 | ORA-06512: at line 6 1030 | ORA-06512: at line 6 1028 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1029 | ORA-06512: at line 6 1030 | ORA-06512: at line 6 1031 | =============================== End of Installation Log Review ===============================