Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.87709_CLOUD_84074_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-08-06 20:07:31 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 Warning: Issue 24.87709, has been installed 2 times on the application server while it is installed 0 times on the database! - File: sql/2487709_4.sql: __________________________ Updating: /opt/cm/v12/test/sql/2487709_4.sql - This is a new file, no information available on disk - size (new file): 32500 bytes - last modified (new file): 2024-08-06 14:00:28.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_07_32.252/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_07_32.252/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_07_32.252/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2487709_4.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_07_32.252/2487709_4.sql.sh to run 2487709_4.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-06_20_07_32.252/2487709_4.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_07_32.252/2487709_4.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 6 20:07:52 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.87709, Work Item 4 -- Subcontractor Prequal -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2487709_4.sql Output in 2487709_4.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:08:05 special list (before special recompiling) 2024-08-06 20:08:06 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-06 20:08:09 special list (after special recompiling) 2024-08-06 20:08:10 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.08.11.893124 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) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- 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:09:05 special list (before special recompiling) 2024-08-06 20:09:06 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-06 20:09:10 special list (after special recompiling) 2024-08-06 20:09:10 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.09.12.734071 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. -- ====================================================================== -- 2487709_4.sql completed. Output in 2487709_4.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.87709 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--------- 100 | * 101 | ERROR at line 1: 102 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 103 | ORA-06512: at "SYS.UTL_RECOMP", line 927 101 | ERROR at line 1: 102 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 103 | ORA-06512: at "SYS.UTL_RECOMP", line 927 104 | ORA-06512: at "SYS.DBMS_STATS", line 40799 102 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 103 | ORA-06512: at "SYS.UTL_RECOMP", line 927 104 | ORA-06512: at "SYS.DBMS_STATS", line 40799 105 | ORA-06512: at "SYS.DBMS_STATS", line 5065 103 | ORA-06512: at "SYS.UTL_RECOMP", line 927 104 | ORA-06512: at "SYS.DBMS_STATS", line 40799 105 | ORA-06512: at "SYS.DBMS_STATS", line 5065 106 | ORA-06512: at "SYS.DBMS_STATS", line 40725 104 | ORA-06512: at "SYS.DBMS_STATS", line 40799 105 | ORA-06512: at "SYS.DBMS_STATS", line 5065 106 | ORA-06512: at "SYS.DBMS_STATS", line 40725 107 | ORA-06512: at "SYS.UTL_RECOMP", line 260 105 | ORA-06512: at "SYS.DBMS_STATS", line 5065 106 | ORA-06512: at "SYS.DBMS_STATS", line 40725 107 | ORA-06512: at "SYS.UTL_RECOMP", line 260 108 | ORA-06512: at "SYS.UTL_RECOMP", line 830 106 | ORA-06512: at "SYS.DBMS_STATS", line 40725 107 | ORA-06512: at "SYS.UTL_RECOMP", line 260 108 | ORA-06512: at "SYS.UTL_RECOMP", line 830 109 | ORA-06512: at line 1 107 | ORA-06512: at "SYS.UTL_RECOMP", line 260 108 | ORA-06512: at "SYS.UTL_RECOMP", line 830 109 | ORA-06512: at line 1 110 | 254 | * 255 | ERROR at line 1: 256 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 257 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 255 | ERROR at line 1: 256 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 257 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 258 | ORA-06512: at "SYS.UTL_RECOMP", line 927 256 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 257 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 258 | ORA-06512: at "SYS.UTL_RECOMP", line 927 259 | ORA-06512: at "SYS.DBMS_STATS", line 40799 257 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 258 | ORA-06512: at "SYS.UTL_RECOMP", line 927 259 | ORA-06512: at "SYS.DBMS_STATS", line 40799 260 | ORA-06512: at "SYS.DBMS_STATS", line 5065 258 | ORA-06512: at "SYS.UTL_RECOMP", line 927 259 | ORA-06512: at "SYS.DBMS_STATS", line 40799 260 | ORA-06512: at "SYS.DBMS_STATS", line 5065 261 | ORA-06512: at "SYS.DBMS_STATS", line 40725 259 | ORA-06512: at "SYS.DBMS_STATS", line 40799 260 | ORA-06512: at "SYS.DBMS_STATS", line 5065 261 | ORA-06512: at "SYS.DBMS_STATS", line 40725 262 | ORA-06512: at "SYS.UTL_RECOMP", line 260 260 | ORA-06512: at "SYS.DBMS_STATS", line 5065 261 | ORA-06512: at "SYS.DBMS_STATS", line 40725 262 | ORA-06512: at "SYS.UTL_RECOMP", line 260 263 | ORA-06512: at "SYS.UTL_RECOMP", line 830 261 | ORA-06512: at "SYS.DBMS_STATS", line 40725 262 | ORA-06512: at "SYS.UTL_RECOMP", line 260 263 | ORA-06512: at "SYS.UTL_RECOMP", line 830 264 | ORA-06512: at "SYS.UTL_RECOMP", line 940 262 | ORA-06512: at "SYS.UTL_RECOMP", line 260 263 | ORA-06512: at "SYS.UTL_RECOMP", line 830 264 | ORA-06512: at "SYS.UTL_RECOMP", line 940 265 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 263 | ORA-06512: at "SYS.UTL_RECOMP", line 830 264 | ORA-06512: at "SYS.UTL_RECOMP", line 940 265 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 266 | ORA-06512: at line 1 264 | ORA-06512: at "SYS.UTL_RECOMP", line 940 265 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 266 | ORA-06512: at line 1 267 | 275 | * 276 | ERROR at line 1: 277 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 278 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 276 | ERROR at line 1: 277 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 278 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 279 | ORA-06512: at "SYS.UTL_RECOMP", line 927 277 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 278 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 279 | ORA-06512: at "SYS.UTL_RECOMP", line 927 280 | ORA-06512: at "SYS.DBMS_STATS", line 40799 278 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 279 | ORA-06512: at "SYS.UTL_RECOMP", line 927 280 | ORA-06512: at "SYS.DBMS_STATS", line 40799 281 | ORA-06512: at "SYS.DBMS_STATS", line 5065 279 | ORA-06512: at "SYS.UTL_RECOMP", line 927 280 | ORA-06512: at "SYS.DBMS_STATS", line 40799 281 | ORA-06512: at "SYS.DBMS_STATS", line 5065 282 | ORA-06512: at "SYS.DBMS_STATS", line 40725 280 | ORA-06512: at "SYS.DBMS_STATS", line 40799 281 | ORA-06512: at "SYS.DBMS_STATS", line 5065 282 | ORA-06512: at "SYS.DBMS_STATS", line 40725 283 | ORA-06512: at "SYS.UTL_RECOMP", line 260 281 | ORA-06512: at "SYS.DBMS_STATS", line 5065 282 | ORA-06512: at "SYS.DBMS_STATS", line 40725 283 | ORA-06512: at "SYS.UTL_RECOMP", line 260 284 | ORA-06512: at "SYS.UTL_RECOMP", line 830 282 | ORA-06512: at "SYS.DBMS_STATS", line 40725 283 | ORA-06512: at "SYS.UTL_RECOMP", line 260 284 | ORA-06512: at "SYS.UTL_RECOMP", line 830 285 | ORA-06512: at "SYS.UTL_RECOMP", line 940 283 | ORA-06512: at "SYS.UTL_RECOMP", line 260 284 | ORA-06512: at "SYS.UTL_RECOMP", line 830 285 | ORA-06512: at "SYS.UTL_RECOMP", line 940 286 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 284 | ORA-06512: at "SYS.UTL_RECOMP", line 830 285 | ORA-06512: at "SYS.UTL_RECOMP", line 940 286 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 287 | ORA-06512: at line 1 285 | ORA-06512: at "SYS.UTL_RECOMP", line 940 286 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 287 | ORA-06512: at line 1 288 | 296 | * 297 | ERROR at line 1: 298 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 299 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 297 | ERROR at line 1: 298 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 299 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 300 | ORA-06512: at "SYS.UTL_RECOMP", line 927 298 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 299 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 300 | ORA-06512: at "SYS.UTL_RECOMP", line 927 301 | ORA-06512: at "SYS.DBMS_STATS", line 40799 299 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 300 | ORA-06512: at "SYS.UTL_RECOMP", line 927 301 | ORA-06512: at "SYS.DBMS_STATS", line 40799 302 | ORA-06512: at "SYS.DBMS_STATS", line 5065 300 | ORA-06512: at "SYS.UTL_RECOMP", line 927 301 | ORA-06512: at "SYS.DBMS_STATS", line 40799 302 | ORA-06512: at "SYS.DBMS_STATS", line 5065 303 | ORA-06512: at "SYS.DBMS_STATS", line 40725 301 | ORA-06512: at "SYS.DBMS_STATS", line 40799 302 | ORA-06512: at "SYS.DBMS_STATS", line 5065 303 | ORA-06512: at "SYS.DBMS_STATS", line 40725 304 | ORA-06512: at "SYS.UTL_RECOMP", line 260 302 | ORA-06512: at "SYS.DBMS_STATS", line 5065 303 | ORA-06512: at "SYS.DBMS_STATS", line 40725 304 | ORA-06512: at "SYS.UTL_RECOMP", line 260 305 | ORA-06512: at "SYS.UTL_RECOMP", line 830 303 | ORA-06512: at "SYS.DBMS_STATS", line 40725 304 | ORA-06512: at "SYS.UTL_RECOMP", line 260 305 | ORA-06512: at "SYS.UTL_RECOMP", line 830 306 | ORA-06512: at "SYS.UTL_RECOMP", line 940 304 | ORA-06512: at "SYS.UTL_RECOMP", line 260 305 | ORA-06512: at "SYS.UTL_RECOMP", line 830 306 | ORA-06512: at "SYS.UTL_RECOMP", line 940 307 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 305 | ORA-06512: at "SYS.UTL_RECOMP", line 830 306 | ORA-06512: at "SYS.UTL_RECOMP", line 940 307 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 308 | ORA-06512: at line 1 306 | ORA-06512: at "SYS.UTL_RECOMP", line 940 307 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 308 | ORA-06512: at line 1 309 | 317 | * 318 | ERROR at line 1: 319 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 320 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 318 | ERROR at line 1: 319 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 320 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 321 | ORA-06512: at "SYS.UTL_RECOMP", line 927 319 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 320 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 321 | ORA-06512: at "SYS.UTL_RECOMP", line 927 322 | ORA-06512: at "SYS.DBMS_STATS", line 40799 320 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 321 | ORA-06512: at "SYS.UTL_RECOMP", line 927 322 | ORA-06512: at "SYS.DBMS_STATS", line 40799 323 | ORA-06512: at "SYS.DBMS_STATS", line 5065 321 | ORA-06512: at "SYS.UTL_RECOMP", line 927 322 | ORA-06512: at "SYS.DBMS_STATS", line 40799 323 | ORA-06512: at "SYS.DBMS_STATS", line 5065 324 | ORA-06512: at "SYS.DBMS_STATS", line 40725 322 | ORA-06512: at "SYS.DBMS_STATS", line 40799 323 | ORA-06512: at "SYS.DBMS_STATS", line 5065 324 | ORA-06512: at "SYS.DBMS_STATS", line 40725 325 | ORA-06512: at "SYS.UTL_RECOMP", line 260 323 | ORA-06512: at "SYS.DBMS_STATS", line 5065 324 | ORA-06512: at "SYS.DBMS_STATS", line 40725 325 | ORA-06512: at "SYS.UTL_RECOMP", line 260 326 | ORA-06512: at "SYS.UTL_RECOMP", line 830 324 | ORA-06512: at "SYS.DBMS_STATS", line 40725 325 | ORA-06512: at "SYS.UTL_RECOMP", line 260 326 | ORA-06512: at "SYS.UTL_RECOMP", line 830 327 | ORA-06512: at "SYS.UTL_RECOMP", line 940 325 | ORA-06512: at "SYS.UTL_RECOMP", line 260 326 | ORA-06512: at "SYS.UTL_RECOMP", line 830 327 | ORA-06512: at "SYS.UTL_RECOMP", line 940 328 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 326 | ORA-06512: at "SYS.UTL_RECOMP", line 830 327 | ORA-06512: at "SYS.UTL_RECOMP", line 940 328 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 329 | ORA-06512: at line 1 327 | ORA-06512: at "SYS.UTL_RECOMP", line 940 328 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 329 | ORA-06512: at line 1 330 | 338 | * 339 | ERROR at line 1: 340 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 341 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 339 | ERROR at line 1: 340 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 341 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 342 | ORA-06512: at "SYS.UTL_RECOMP", line 927 340 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 341 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 342 | ORA-06512: at "SYS.UTL_RECOMP", line 927 343 | ORA-06512: at "SYS.DBMS_STATS", line 40799 341 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 342 | ORA-06512: at "SYS.UTL_RECOMP", line 927 343 | ORA-06512: at "SYS.DBMS_STATS", line 40799 344 | ORA-06512: at "SYS.DBMS_STATS", line 5065 342 | ORA-06512: at "SYS.UTL_RECOMP", line 927 343 | ORA-06512: at "SYS.DBMS_STATS", line 40799 344 | ORA-06512: at "SYS.DBMS_STATS", line 5065 345 | ORA-06512: at "SYS.DBMS_STATS", line 40725 343 | ORA-06512: at "SYS.DBMS_STATS", line 40799 344 | ORA-06512: at "SYS.DBMS_STATS", line 5065 345 | ORA-06512: at "SYS.DBMS_STATS", line 40725 346 | ORA-06512: at "SYS.UTL_RECOMP", line 260 344 | ORA-06512: at "SYS.DBMS_STATS", line 5065 345 | ORA-06512: at "SYS.DBMS_STATS", line 40725 346 | ORA-06512: at "SYS.UTL_RECOMP", line 260 347 | ORA-06512: at "SYS.UTL_RECOMP", line 830 345 | ORA-06512: at "SYS.DBMS_STATS", line 40725 346 | ORA-06512: at "SYS.UTL_RECOMP", line 260 347 | ORA-06512: at "SYS.UTL_RECOMP", line 830 348 | ORA-06512: at "SYS.UTL_RECOMP", line 940 346 | ORA-06512: at "SYS.UTL_RECOMP", line 260 347 | ORA-06512: at "SYS.UTL_RECOMP", line 830 348 | ORA-06512: at "SYS.UTL_RECOMP", line 940 349 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 347 | ORA-06512: at "SYS.UTL_RECOMP", line 830 348 | ORA-06512: at "SYS.UTL_RECOMP", line 940 349 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 350 | ORA-06512: at line 1 348 | ORA-06512: at "SYS.UTL_RECOMP", line 940 349 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 350 | ORA-06512: at line 1 351 | 359 | * 360 | ERROR at line 1: 361 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 362 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 360 | ERROR at line 1: 361 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 362 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 363 | ORA-06512: at "SYS.UTL_RECOMP", line 927 361 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 362 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 363 | ORA-06512: at "SYS.UTL_RECOMP", line 927 364 | ORA-06512: at "SYS.DBMS_STATS", line 40799 362 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 363 | ORA-06512: at "SYS.UTL_RECOMP", line 927 364 | ORA-06512: at "SYS.DBMS_STATS", line 40799 365 | ORA-06512: at "SYS.DBMS_STATS", line 5065 363 | ORA-06512: at "SYS.UTL_RECOMP", line 927 364 | ORA-06512: at "SYS.DBMS_STATS", line 40799 365 | ORA-06512: at "SYS.DBMS_STATS", line 5065 366 | ORA-06512: at "SYS.DBMS_STATS", line 40725 364 | ORA-06512: at "SYS.DBMS_STATS", line 40799 365 | ORA-06512: at "SYS.DBMS_STATS", line 5065 366 | ORA-06512: at "SYS.DBMS_STATS", line 40725 367 | ORA-06512: at "SYS.UTL_RECOMP", line 260 365 | ORA-06512: at "SYS.DBMS_STATS", line 5065 366 | ORA-06512: at "SYS.DBMS_STATS", line 40725 367 | ORA-06512: at "SYS.UTL_RECOMP", line 260 368 | ORA-06512: at "SYS.UTL_RECOMP", line 830 366 | ORA-06512: at "SYS.DBMS_STATS", line 40725 367 | ORA-06512: at "SYS.UTL_RECOMP", line 260 368 | ORA-06512: at "SYS.UTL_RECOMP", line 830 369 | ORA-06512: at "SYS.UTL_RECOMP", line 940 367 | ORA-06512: at "SYS.UTL_RECOMP", line 260 368 | ORA-06512: at "SYS.UTL_RECOMP", line 830 369 | ORA-06512: at "SYS.UTL_RECOMP", line 940 370 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 368 | ORA-06512: at "SYS.UTL_RECOMP", line 830 369 | ORA-06512: at "SYS.UTL_RECOMP", line 940 370 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 371 | ORA-06512: at line 1 369 | ORA-06512: at "SYS.UTL_RECOMP", line 940 370 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 371 | ORA-06512: at line 1 372 | 380 | * 381 | ERROR at line 1: 382 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 383 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 381 | ERROR at line 1: 382 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 383 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 384 | ORA-06512: at "SYS.UTL_RECOMP", line 927 382 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 383 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 384 | ORA-06512: at "SYS.UTL_RECOMP", line 927 385 | ORA-06512: at "SYS.DBMS_STATS", line 40799 383 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 384 | ORA-06512: at "SYS.UTL_RECOMP", line 927 385 | ORA-06512: at "SYS.DBMS_STATS", line 40799 386 | ORA-06512: at "SYS.DBMS_STATS", line 5065 384 | ORA-06512: at "SYS.UTL_RECOMP", line 927 385 | ORA-06512: at "SYS.DBMS_STATS", line 40799 386 | ORA-06512: at "SYS.DBMS_STATS", line 5065 387 | ORA-06512: at "SYS.DBMS_STATS", line 40725 385 | ORA-06512: at "SYS.DBMS_STATS", line 40799 386 | ORA-06512: at "SYS.DBMS_STATS", line 5065 387 | ORA-06512: at "SYS.DBMS_STATS", line 40725 388 | ORA-06512: at "SYS.UTL_RECOMP", line 260 386 | ORA-06512: at "SYS.DBMS_STATS", line 5065 387 | ORA-06512: at "SYS.DBMS_STATS", line 40725 388 | ORA-06512: at "SYS.UTL_RECOMP", line 260 389 | ORA-06512: at "SYS.UTL_RECOMP", line 830 387 | ORA-06512: at "SYS.DBMS_STATS", line 40725 388 | ORA-06512: at "SYS.UTL_RECOMP", line 260 389 | ORA-06512: at "SYS.UTL_RECOMP", line 830 390 | ORA-06512: at "SYS.UTL_RECOMP", line 940 388 | ORA-06512: at "SYS.UTL_RECOMP", line 260 389 | ORA-06512: at "SYS.UTL_RECOMP", line 830 390 | ORA-06512: at "SYS.UTL_RECOMP", line 940 391 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 389 | ORA-06512: at "SYS.UTL_RECOMP", line 830 390 | ORA-06512: at "SYS.UTL_RECOMP", line 940 391 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 392 | ORA-06512: at line 1 390 | ORA-06512: at "SYS.UTL_RECOMP", line 940 391 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 392 | ORA-06512: at line 1 393 | 401 | * 402 | ERROR at line 1: 403 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 404 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 402 | ERROR at line 1: 403 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 404 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 405 | ORA-06512: at "SYS.UTL_RECOMP", line 927 403 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 404 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 405 | ORA-06512: at "SYS.UTL_RECOMP", line 927 406 | ORA-06512: at "SYS.DBMS_STATS", line 40799 404 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 405 | ORA-06512: at "SYS.UTL_RECOMP", line 927 406 | ORA-06512: at "SYS.DBMS_STATS", line 40799 407 | ORA-06512: at "SYS.DBMS_STATS", line 5065 405 | ORA-06512: at "SYS.UTL_RECOMP", line 927 406 | ORA-06512: at "SYS.DBMS_STATS", line 40799 407 | ORA-06512: at "SYS.DBMS_STATS", line 5065 408 | ORA-06512: at "SYS.DBMS_STATS", line 40725 406 | ORA-06512: at "SYS.DBMS_STATS", line 40799 407 | ORA-06512: at "SYS.DBMS_STATS", line 5065 408 | ORA-06512: at "SYS.DBMS_STATS", line 40725 409 | ORA-06512: at "SYS.UTL_RECOMP", line 260 407 | ORA-06512: at "SYS.DBMS_STATS", line 5065 408 | ORA-06512: at "SYS.DBMS_STATS", line 40725 409 | ORA-06512: at "SYS.UTL_RECOMP", line 260 410 | ORA-06512: at "SYS.UTL_RECOMP", line 830 408 | ORA-06512: at "SYS.DBMS_STATS", line 40725 409 | ORA-06512: at "SYS.UTL_RECOMP", line 260 410 | ORA-06512: at "SYS.UTL_RECOMP", line 830 411 | ORA-06512: at "SYS.UTL_RECOMP", line 940 409 | ORA-06512: at "SYS.UTL_RECOMP", line 260 410 | ORA-06512: at "SYS.UTL_RECOMP", line 830 411 | ORA-06512: at "SYS.UTL_RECOMP", line 940 412 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 410 | ORA-06512: at "SYS.UTL_RECOMP", line 830 411 | ORA-06512: at "SYS.UTL_RECOMP", line 940 412 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 413 | ORA-06512: at line 1 411 | ORA-06512: at "SYS.UTL_RECOMP", line 940 412 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 413 | ORA-06512: at line 1 414 | 421 | * 422 | ERROR at line 1: 423 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 424 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 422 | ERROR at line 1: 423 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 424 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 425 | ORA-06512: at "SYS.UTL_RECOMP", line 927 423 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 424 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 425 | ORA-06512: at "SYS.UTL_RECOMP", line 927 426 | ORA-06512: at "SYS.DBMS_STATS", line 40799 424 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 425 | ORA-06512: at "SYS.UTL_RECOMP", line 927 426 | ORA-06512: at "SYS.DBMS_STATS", line 40799 427 | ORA-06512: at "SYS.DBMS_STATS", line 5065 425 | ORA-06512: at "SYS.UTL_RECOMP", line 927 426 | ORA-06512: at "SYS.DBMS_STATS", line 40799 427 | ORA-06512: at "SYS.DBMS_STATS", line 5065 428 | ORA-06512: at "SYS.DBMS_STATS", line 40725 426 | ORA-06512: at "SYS.DBMS_STATS", line 40799 427 | ORA-06512: at "SYS.DBMS_STATS", line 5065 428 | ORA-06512: at "SYS.DBMS_STATS", line 40725 429 | ORA-06512: at "SYS.UTL_RECOMP", line 260 427 | ORA-06512: at "SYS.DBMS_STATS", line 5065 428 | ORA-06512: at "SYS.DBMS_STATS", line 40725 429 | ORA-06512: at "SYS.UTL_RECOMP", line 260 430 | ORA-06512: at "SYS.UTL_RECOMP", line 830 428 | ORA-06512: at "SYS.DBMS_STATS", line 40725 429 | ORA-06512: at "SYS.UTL_RECOMP", line 260 430 | ORA-06512: at "SYS.UTL_RECOMP", line 830 431 | ORA-06512: at "SYS.UTL_RECOMP", line 940 429 | ORA-06512: at "SYS.UTL_RECOMP", line 260 430 | ORA-06512: at "SYS.UTL_RECOMP", line 830 431 | ORA-06512: at "SYS.UTL_RECOMP", line 940 432 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 430 | ORA-06512: at "SYS.UTL_RECOMP", line 830 431 | ORA-06512: at "SYS.UTL_RECOMP", line 940 432 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 433 | ORA-06512: at line 6 431 | ORA-06512: at "SYS.UTL_RECOMP", line 940 432 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 433 | ORA-06512: at line 6 434 | ORA-06512: at line 6 432 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 433 | ORA-06512: at line 6 434 | ORA-06512: at line 6 435 | 677 | * 678 | ERROR at line 1: 679 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 680 | ORA-06512: at "SYS.UTL_RECOMP", line 927 678 | ERROR at line 1: 679 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 680 | ORA-06512: at "SYS.UTL_RECOMP", line 927 681 | ORA-06512: at "SYS.DBMS_STATS", line 40799 679 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 680 | ORA-06512: at "SYS.UTL_RECOMP", line 927 681 | ORA-06512: at "SYS.DBMS_STATS", line 40799 682 | ORA-06512: at "SYS.DBMS_STATS", line 5065 680 | ORA-06512: at "SYS.UTL_RECOMP", line 927 681 | ORA-06512: at "SYS.DBMS_STATS", line 40799 682 | ORA-06512: at "SYS.DBMS_STATS", line 5065 683 | ORA-06512: at "SYS.DBMS_STATS", line 40725 681 | ORA-06512: at "SYS.DBMS_STATS", line 40799 682 | ORA-06512: at "SYS.DBMS_STATS", line 5065 683 | ORA-06512: at "SYS.DBMS_STATS", line 40725 684 | ORA-06512: at "SYS.UTL_RECOMP", line 260 682 | ORA-06512: at "SYS.DBMS_STATS", line 5065 683 | ORA-06512: at "SYS.DBMS_STATS", line 40725 684 | ORA-06512: at "SYS.UTL_RECOMP", line 260 685 | ORA-06512: at "SYS.UTL_RECOMP", line 830 683 | ORA-06512: at "SYS.DBMS_STATS", line 40725 684 | ORA-06512: at "SYS.UTL_RECOMP", line 260 685 | ORA-06512: at "SYS.UTL_RECOMP", line 830 686 | ORA-06512: at line 1 684 | ORA-06512: at "SYS.UTL_RECOMP", line 260 685 | ORA-06512: at "SYS.UTL_RECOMP", line 830 686 | ORA-06512: at line 1 687 | 828 | * 829 | ERROR at line 1: 830 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 831 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 829 | ERROR at line 1: 830 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 831 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 832 | ORA-06512: at "SYS.UTL_RECOMP", line 927 830 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 831 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 832 | ORA-06512: at "SYS.UTL_RECOMP", line 927 833 | ORA-06512: at "SYS.DBMS_STATS", line 40799 831 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 832 | ORA-06512: at "SYS.UTL_RECOMP", line 927 833 | ORA-06512: at "SYS.DBMS_STATS", line 40799 834 | ORA-06512: at "SYS.DBMS_STATS", line 5065 832 | ORA-06512: at "SYS.UTL_RECOMP", line 927 833 | ORA-06512: at "SYS.DBMS_STATS", line 40799 834 | ORA-06512: at "SYS.DBMS_STATS", line 5065 835 | ORA-06512: at "SYS.DBMS_STATS", line 40725 833 | ORA-06512: at "SYS.DBMS_STATS", line 40799 834 | ORA-06512: at "SYS.DBMS_STATS", line 5065 835 | ORA-06512: at "SYS.DBMS_STATS", line 40725 836 | ORA-06512: at "SYS.UTL_RECOMP", line 260 834 | ORA-06512: at "SYS.DBMS_STATS", line 5065 835 | ORA-06512: at "SYS.DBMS_STATS", line 40725 836 | ORA-06512: at "SYS.UTL_RECOMP", line 260 837 | ORA-06512: at "SYS.UTL_RECOMP", line 830 835 | ORA-06512: at "SYS.DBMS_STATS", line 40725 836 | ORA-06512: at "SYS.UTL_RECOMP", line 260 837 | ORA-06512: at "SYS.UTL_RECOMP", line 830 838 | ORA-06512: at "SYS.UTL_RECOMP", line 940 836 | ORA-06512: at "SYS.UTL_RECOMP", line 260 837 | ORA-06512: at "SYS.UTL_RECOMP", line 830 838 | ORA-06512: at "SYS.UTL_RECOMP", line 940 839 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 837 | ORA-06512: at "SYS.UTL_RECOMP", line 830 838 | ORA-06512: at "SYS.UTL_RECOMP", line 940 839 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 840 | ORA-06512: at line 1 838 | ORA-06512: at "SYS.UTL_RECOMP", line 940 839 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 840 | ORA-06512: at line 1 841 | 849 | * 850 | ERROR at line 1: 851 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 852 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 850 | ERROR at line 1: 851 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 852 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 853 | ORA-06512: at "SYS.UTL_RECOMP", line 927 851 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 852 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 853 | ORA-06512: at "SYS.UTL_RECOMP", line 927 854 | ORA-06512: at "SYS.DBMS_STATS", line 40799 852 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 853 | ORA-06512: at "SYS.UTL_RECOMP", line 927 854 | ORA-06512: at "SYS.DBMS_STATS", line 40799 855 | ORA-06512: at "SYS.DBMS_STATS", line 5065 853 | ORA-06512: at "SYS.UTL_RECOMP", line 927 854 | ORA-06512: at "SYS.DBMS_STATS", line 40799 855 | ORA-06512: at "SYS.DBMS_STATS", line 5065 856 | ORA-06512: at "SYS.DBMS_STATS", line 40725 854 | ORA-06512: at "SYS.DBMS_STATS", line 40799 855 | ORA-06512: at "SYS.DBMS_STATS", line 5065 856 | ORA-06512: at "SYS.DBMS_STATS", line 40725 857 | ORA-06512: at "SYS.UTL_RECOMP", line 260 855 | ORA-06512: at "SYS.DBMS_STATS", line 5065 856 | ORA-06512: at "SYS.DBMS_STATS", line 40725 857 | ORA-06512: at "SYS.UTL_RECOMP", line 260 858 | ORA-06512: at "SYS.UTL_RECOMP", line 830 856 | ORA-06512: at "SYS.DBMS_STATS", line 40725 857 | ORA-06512: at "SYS.UTL_RECOMP", line 260 858 | ORA-06512: at "SYS.UTL_RECOMP", line 830 859 | ORA-06512: at "SYS.UTL_RECOMP", line 940 857 | ORA-06512: at "SYS.UTL_RECOMP", line 260 858 | ORA-06512: at "SYS.UTL_RECOMP", line 830 859 | ORA-06512: at "SYS.UTL_RECOMP", line 940 860 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 858 | ORA-06512: at "SYS.UTL_RECOMP", line 830 859 | ORA-06512: at "SYS.UTL_RECOMP", line 940 860 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 861 | ORA-06512: at line 1 859 | ORA-06512: at "SYS.UTL_RECOMP", line 940 860 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 861 | ORA-06512: at line 1 862 | 870 | * 871 | ERROR at line 1: 872 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 871 | ERROR at line 1: 872 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 874 | ORA-06512: at "SYS.UTL_RECOMP", line 927 872 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 874 | ORA-06512: at "SYS.UTL_RECOMP", line 927 875 | ORA-06512: at "SYS.DBMS_STATS", line 40799 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 874 | ORA-06512: at "SYS.UTL_RECOMP", line 927 875 | ORA-06512: at "SYS.DBMS_STATS", line 40799 876 | ORA-06512: at "SYS.DBMS_STATS", line 5065 874 | ORA-06512: at "SYS.UTL_RECOMP", line 927 875 | ORA-06512: at "SYS.DBMS_STATS", line 40799 876 | ORA-06512: at "SYS.DBMS_STATS", line 5065 877 | ORA-06512: at "SYS.DBMS_STATS", line 40725 875 | ORA-06512: at "SYS.DBMS_STATS", line 40799 876 | ORA-06512: at "SYS.DBMS_STATS", line 5065 877 | ORA-06512: at "SYS.DBMS_STATS", line 40725 878 | ORA-06512: at "SYS.UTL_RECOMP", line 260 876 | ORA-06512: at "SYS.DBMS_STATS", line 5065 877 | ORA-06512: at "SYS.DBMS_STATS", line 40725 878 | ORA-06512: at "SYS.UTL_RECOMP", line 260 879 | ORA-06512: at "SYS.UTL_RECOMP", line 830 877 | ORA-06512: at "SYS.DBMS_STATS", line 40725 878 | ORA-06512: at "SYS.UTL_RECOMP", line 260 879 | ORA-06512: at "SYS.UTL_RECOMP", line 830 880 | ORA-06512: at "SYS.UTL_RECOMP", line 940 878 | ORA-06512: at "SYS.UTL_RECOMP", line 260 879 | ORA-06512: at "SYS.UTL_RECOMP", line 830 880 | ORA-06512: at "SYS.UTL_RECOMP", line 940 881 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 879 | ORA-06512: at "SYS.UTL_RECOMP", line 830 880 | ORA-06512: at "SYS.UTL_RECOMP", line 940 881 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 882 | ORA-06512: at line 1 880 | ORA-06512: at "SYS.UTL_RECOMP", line 940 881 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 882 | ORA-06512: at line 1 883 | 891 | * 892 | ERROR at line 1: 893 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 892 | ERROR at line 1: 893 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 895 | ORA-06512: at "SYS.UTL_RECOMP", line 927 893 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 895 | ORA-06512: at "SYS.UTL_RECOMP", line 927 896 | ORA-06512: at "SYS.DBMS_STATS", line 40799 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 895 | ORA-06512: at "SYS.UTL_RECOMP", line 927 896 | ORA-06512: at "SYS.DBMS_STATS", line 40799 897 | ORA-06512: at "SYS.DBMS_STATS", line 5065 895 | ORA-06512: at "SYS.UTL_RECOMP", line 927 896 | ORA-06512: at "SYS.DBMS_STATS", line 40799 897 | ORA-06512: at "SYS.DBMS_STATS", line 5065 898 | ORA-06512: at "SYS.DBMS_STATS", line 40725 896 | ORA-06512: at "SYS.DBMS_STATS", line 40799 897 | ORA-06512: at "SYS.DBMS_STATS", line 5065 898 | ORA-06512: at "SYS.DBMS_STATS", line 40725 899 | ORA-06512: at "SYS.UTL_RECOMP", line 260 897 | ORA-06512: at "SYS.DBMS_STATS", line 5065 898 | ORA-06512: at "SYS.DBMS_STATS", line 40725 899 | ORA-06512: at "SYS.UTL_RECOMP", line 260 900 | ORA-06512: at "SYS.UTL_RECOMP", line 830 898 | ORA-06512: at "SYS.DBMS_STATS", line 40725 899 | ORA-06512: at "SYS.UTL_RECOMP", line 260 900 | ORA-06512: at "SYS.UTL_RECOMP", line 830 901 | ORA-06512: at "SYS.UTL_RECOMP", line 940 899 | ORA-06512: at "SYS.UTL_RECOMP", line 260 900 | ORA-06512: at "SYS.UTL_RECOMP", line 830 901 | ORA-06512: at "SYS.UTL_RECOMP", line 940 902 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 900 | ORA-06512: at "SYS.UTL_RECOMP", line 830 901 | ORA-06512: at "SYS.UTL_RECOMP", line 940 902 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 903 | ORA-06512: at line 1 901 | ORA-06512: at "SYS.UTL_RECOMP", line 940 902 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 903 | ORA-06512: at line 1 904 | 912 | * 913 | ERROR at line 1: 914 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 913 | ERROR at line 1: 914 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 916 | ORA-06512: at "SYS.UTL_RECOMP", line 927 914 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 916 | ORA-06512: at "SYS.UTL_RECOMP", line 927 917 | ORA-06512: at "SYS.DBMS_STATS", line 40799 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 916 | ORA-06512: at "SYS.UTL_RECOMP", line 927 917 | ORA-06512: at "SYS.DBMS_STATS", line 40799 918 | ORA-06512: at "SYS.DBMS_STATS", line 5065 916 | ORA-06512: at "SYS.UTL_RECOMP", line 927 917 | ORA-06512: at "SYS.DBMS_STATS", line 40799 918 | ORA-06512: at "SYS.DBMS_STATS", line 5065 919 | ORA-06512: at "SYS.DBMS_STATS", line 40725 917 | ORA-06512: at "SYS.DBMS_STATS", line 40799 918 | ORA-06512: at "SYS.DBMS_STATS", line 5065 919 | ORA-06512: at "SYS.DBMS_STATS", line 40725 920 | ORA-06512: at "SYS.UTL_RECOMP", line 260 918 | ORA-06512: at "SYS.DBMS_STATS", line 5065 919 | ORA-06512: at "SYS.DBMS_STATS", line 40725 920 | ORA-06512: at "SYS.UTL_RECOMP", line 260 921 | ORA-06512: at "SYS.UTL_RECOMP", line 830 919 | ORA-06512: at "SYS.DBMS_STATS", line 40725 920 | ORA-06512: at "SYS.UTL_RECOMP", line 260 921 | ORA-06512: at "SYS.UTL_RECOMP", line 830 922 | ORA-06512: at "SYS.UTL_RECOMP", line 940 920 | ORA-06512: at "SYS.UTL_RECOMP", line 260 921 | ORA-06512: at "SYS.UTL_RECOMP", line 830 922 | ORA-06512: at "SYS.UTL_RECOMP", line 940 923 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 921 | ORA-06512: at "SYS.UTL_RECOMP", line 830 922 | ORA-06512: at "SYS.UTL_RECOMP", line 940 923 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 924 | ORA-06512: at line 1 922 | ORA-06512: at "SYS.UTL_RECOMP", line 940 923 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 924 | ORA-06512: at line 1 925 | 933 | * 934 | ERROR at line 1: 935 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 934 | ERROR at line 1: 935 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 937 | ORA-06512: at "SYS.UTL_RECOMP", line 927 935 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 937 | ORA-06512: at "SYS.UTL_RECOMP", line 927 938 | ORA-06512: at "SYS.DBMS_STATS", line 40799 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 937 | ORA-06512: at "SYS.UTL_RECOMP", line 927 938 | ORA-06512: at "SYS.DBMS_STATS", line 40799 939 | ORA-06512: at "SYS.DBMS_STATS", line 5065 937 | ORA-06512: at "SYS.UTL_RECOMP", line 927 938 | ORA-06512: at "SYS.DBMS_STATS", line 40799 939 | ORA-06512: at "SYS.DBMS_STATS", line 5065 940 | ORA-06512: at "SYS.DBMS_STATS", line 40725 938 | ORA-06512: at "SYS.DBMS_STATS", line 40799 939 | ORA-06512: at "SYS.DBMS_STATS", line 5065 940 | ORA-06512: at "SYS.DBMS_STATS", line 40725 941 | ORA-06512: at "SYS.UTL_RECOMP", line 260 939 | ORA-06512: at "SYS.DBMS_STATS", line 5065 940 | ORA-06512: at "SYS.DBMS_STATS", line 40725 941 | ORA-06512: at "SYS.UTL_RECOMP", line 260 942 | ORA-06512: at "SYS.UTL_RECOMP", line 830 940 | ORA-06512: at "SYS.DBMS_STATS", line 40725 941 | ORA-06512: at "SYS.UTL_RECOMP", line 260 942 | ORA-06512: at "SYS.UTL_RECOMP", line 830 943 | ORA-06512: at "SYS.UTL_RECOMP", line 940 941 | ORA-06512: at "SYS.UTL_RECOMP", line 260 942 | ORA-06512: at "SYS.UTL_RECOMP", line 830 943 | ORA-06512: at "SYS.UTL_RECOMP", line 940 944 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 942 | ORA-06512: at "SYS.UTL_RECOMP", line 830 943 | ORA-06512: at "SYS.UTL_RECOMP", line 940 944 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 945 | ORA-06512: at line 1 943 | ORA-06512: at "SYS.UTL_RECOMP", line 940 944 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 945 | ORA-06512: at line 1 946 | 954 | * 955 | ERROR at line 1: 956 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 955 | ERROR at line 1: 956 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 958 | ORA-06512: at "SYS.UTL_RECOMP", line 927 956 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 958 | ORA-06512: at "SYS.UTL_RECOMP", line 927 959 | ORA-06512: at "SYS.DBMS_STATS", line 40799 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 958 | ORA-06512: at "SYS.UTL_RECOMP", line 927 959 | ORA-06512: at "SYS.DBMS_STATS", line 40799 960 | ORA-06512: at "SYS.DBMS_STATS", line 5065 958 | ORA-06512: at "SYS.UTL_RECOMP", line 927 959 | ORA-06512: at "SYS.DBMS_STATS", line 40799 960 | ORA-06512: at "SYS.DBMS_STATS", line 5065 961 | ORA-06512: at "SYS.DBMS_STATS", line 40725 959 | ORA-06512: at "SYS.DBMS_STATS", line 40799 960 | ORA-06512: at "SYS.DBMS_STATS", line 5065 961 | ORA-06512: at "SYS.DBMS_STATS", line 40725 962 | ORA-06512: at "SYS.UTL_RECOMP", line 260 960 | ORA-06512: at "SYS.DBMS_STATS", line 5065 961 | ORA-06512: at "SYS.DBMS_STATS", line 40725 962 | ORA-06512: at "SYS.UTL_RECOMP", line 260 963 | ORA-06512: at "SYS.UTL_RECOMP", line 830 961 | ORA-06512: at "SYS.DBMS_STATS", line 40725 962 | ORA-06512: at "SYS.UTL_RECOMP", line 260 963 | ORA-06512: at "SYS.UTL_RECOMP", line 830 964 | ORA-06512: at "SYS.UTL_RECOMP", line 940 962 | ORA-06512: at "SYS.UTL_RECOMP", line 260 963 | ORA-06512: at "SYS.UTL_RECOMP", line 830 964 | ORA-06512: at "SYS.UTL_RECOMP", line 940 965 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 963 | ORA-06512: at "SYS.UTL_RECOMP", line 830 964 | ORA-06512: at "SYS.UTL_RECOMP", line 940 965 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 966 | ORA-06512: at line 1 964 | ORA-06512: at "SYS.UTL_RECOMP", line 940 965 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 966 | ORA-06512: at line 1 967 | 975 | * 976 | ERROR at line 1: 977 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 976 | ERROR at line 1: 977 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 979 | ORA-06512: at "SYS.UTL_RECOMP", line 927 977 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 979 | ORA-06512: at "SYS.UTL_RECOMP", line 927 980 | ORA-06512: at "SYS.DBMS_STATS", line 40799 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 979 | ORA-06512: at "SYS.UTL_RECOMP", line 927 980 | ORA-06512: at "SYS.DBMS_STATS", line 40799 981 | ORA-06512: at "SYS.DBMS_STATS", line 5065 979 | ORA-06512: at "SYS.UTL_RECOMP", line 927 980 | ORA-06512: at "SYS.DBMS_STATS", line 40799 981 | ORA-06512: at "SYS.DBMS_STATS", line 5065 982 | ORA-06512: at "SYS.DBMS_STATS", line 40725 980 | ORA-06512: at "SYS.DBMS_STATS", line 40799 981 | ORA-06512: at "SYS.DBMS_STATS", line 5065 982 | ORA-06512: at "SYS.DBMS_STATS", line 40725 983 | ORA-06512: at "SYS.UTL_RECOMP", line 260 981 | ORA-06512: at "SYS.DBMS_STATS", line 5065 982 | ORA-06512: at "SYS.DBMS_STATS", line 40725 983 | ORA-06512: at "SYS.UTL_RECOMP", line 260 984 | ORA-06512: at "SYS.UTL_RECOMP", line 830 982 | ORA-06512: at "SYS.DBMS_STATS", line 40725 983 | ORA-06512: at "SYS.UTL_RECOMP", line 260 984 | ORA-06512: at "SYS.UTL_RECOMP", line 830 985 | ORA-06512: at "SYS.UTL_RECOMP", line 940 983 | ORA-06512: at "SYS.UTL_RECOMP", line 260 984 | ORA-06512: at "SYS.UTL_RECOMP", line 830 985 | ORA-06512: at "SYS.UTL_RECOMP", line 940 986 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 984 | ORA-06512: at "SYS.UTL_RECOMP", line 830 985 | ORA-06512: at "SYS.UTL_RECOMP", line 940 986 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 987 | ORA-06512: at line 1 985 | ORA-06512: at "SYS.UTL_RECOMP", line 940 986 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 987 | ORA-06512: at line 1 988 | 995 | * 996 | ERROR at line 1: 997 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 998 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 996 | ERROR at line 1: 997 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 998 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 999 | ORA-06512: at "SYS.UTL_RECOMP", line 927 997 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 998 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 999 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1000 | ORA-06512: at "SYS.DBMS_STATS", line 40799 998 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 999 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1000 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1001 | ORA-06512: at "SYS.DBMS_STATS", line 5065 999 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1000 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1001 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1000 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1001 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1003 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1001 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1003 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1004 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1002 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1003 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1004 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1003 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1004 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1006 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1004 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1006 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1007 | ORA-06512: at line 6 1005 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1006 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1007 | ORA-06512: at line 6 1008 | ORA-06512: at line 6 1006 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1007 | ORA-06512: at line 6 1008 | ORA-06512: at line 6 1009 | =============================== End of Installation Log Review ===============================