Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.87966_CLOUD_98500_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-08-07 20:10:03 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.87966, has been installed 1 times on the application server while it is installed 0 times on the database! - File: sql/pmbidder.vwt: _________________________ The new copy of the file "/opt/cm/v12/test/sql/pmbidder.vwt", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/pmbidder.vwt - size (on disk): 779 bytes - last modified (on disk): 2024-07-30 16:05:12.0 - size (new file): 779 bytes - last modified (new file): 2024-07-30 16:05:12.0 Warning: The file was not modified. - File: sql/2487966_1.sql: __________________________ The new copy of the file "/opt/cm/v12/test/sql/2487966_1.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/2487966_1.sql - size (on disk): 8097 bytes - last modified (on disk): 2024-07-30 16:05:12.0 - size (new file): 8097 bytes - last modified (new file): 2024-07-30 16:05:12.0 Warning: The file was not modified. Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-07_20_10_04.256/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-08-07_20_10_04.256/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-07_20_10_04.256/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2487966_1.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-07_20_10_04.256/2487966_1.sql.sh to run 2487966_1.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-07_20_10_04.256/2487966_1.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-08-07_20_10_04.256/2487966_1.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 7 20:10:09 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.87966, Work Item 1 -- Prequal Vender Approval - Error Message -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2487966_1.sql Output in 2487966_1.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,130 INDEX PARTITION 101 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,501 TABLE PARTITION 20,863 17 TRIGGER 266 TYPE 10,398 6 VIEW -------- ********** -------- 144,223 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 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 164,105 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-07 20:10:11 special list (before special recompiling) 2024-08-07 20:10:12 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-07 20:10:12 special list (after special recompiling) 2024-08-07 20:10:13 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,130 INDEX PARTITION 101 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,501 TABLE PARTITION 20,863 17 TRIGGER 266 TYPE 10,398 6 VIEW -------- ********** -------- 144,223 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 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 164,105 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 07-AUG-24 08.10.14.580185 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 -- ====================================================================== ================================================================= View PMBIDDER ================================================================= -- ====================================================================== -- 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 -- ====================================================================== PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. -- ====================================================================== -- 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 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,130 INDEX PARTITION 101 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 25 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,998 TABLE 35,501 TABLE PARTITION 20,863 20 TRIGGER 266 TYPE 10,399 16 VIEW -------- ********** -------- 144,223 sum 63 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,301 SYNONYM 2 TABLE 391 3 TRIGGER 1,205 11 VIEW -------- ********** -------- 2,912 sum 14 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 1 PACKAGE BODY 2 SYNONYM 2,893 4 VIEW -------- ********** -------- 4,491 sum 5 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 39 VIEW -------- ********** -------- 6,332 sum 39 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 2 VIEW -------- ********** -------- 538 sum 2 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 164,105 123 =================================================== =================================================================================== == 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-07 20:10:17 special list (before special recompiling) 2024-08-07 20:10:18 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-07 20:10:19 special list (after special recompiling) 2024-08-07 20:10:19 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,130 INDEX PARTITION 101 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 25 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,998 TABLE 35,501 TABLE PARTITION 20,863 20 TRIGGER 266 TYPE 10,399 16 VIEW -------- ********** -------- 144,223 sum 63 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,301 SYNONYM 2 TABLE 391 3 TRIGGER 1,205 11 VIEW -------- ********** -------- 2,912 sum 14 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 1 PACKAGE BODY 2 SYNONYM 2,893 4 VIEW -------- ********** -------- 4,491 sum 5 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 39 VIEW -------- ********** -------- 6,332 sum 39 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 2 VIEW -------- ********** -------- 538 sum 2 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 164,105 123 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_PM_PURCHASE_BID DA PACKAGE BODY DBK_ATTACHMENT DA PACKAGE BODY DBK_BP_PARTNER DA PACKAGE BODY DBK_COL_RPT_UTIL DA PACKAGE BODY DBK_COPY_PO DA PACKAGE BODY DBK_DC_PMBIDDER DA PACKAGE BODY DBK_JC_CONT_FORECAST_2 DA PACKAGE BODY DBK_PMHCSSIMPORT DA PACKAGE BODY DBK_PM_BIDP DA PACKAGE BODY DBK_PM_CHANGE DA PACKAGE BODY DBK_PM_CONTACT DA PACKAGE BODY DBK_PM_ITB DA PACKAGE BODY DBK_PM_PARTNER DA PACKAGE BODY DBK_PM_PREQUAL DA PACKAGE BODY DBK_PM_PROJECT DA PACKAGE BODY DBK_PM_PURCHASE_BID DA PACKAGE BODY DBK_PM_PURCHASE_BUYOUT DA PACKAGE BODY DBK_PM_SC DA PACKAGE BODY DBK_PO DA PACKAGE BODY DBK_PO_DETAIL_IMPORT DA PACKAGE BODY DBK_PO_RELEASE DA PACKAGE BODY DBK_RPT_DIST DA PACKAGE BODY DBK_SC_IMPORT DA PACKAGE BODY DBK_SD_CONVERT_ATTACH_TO_DOC DA PACKAGE BODY DBK_SYS_CONTACT DA PACKAGE BODY DBK_SYS_PARTNER 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_A_ID_R_BPCSICODE_TN DA TRIGGER DBT_I_IUD_BID_ITEM_QUOTE DA TRIGGER DBT_I_IUD_BID_ITEM_QUOTEBO DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW FLPM2000_V DA VIEW FLPM2200_V5 DA VIEW PMBIDDER_V DA VIEW PMBIDDER_V0 DA VIEW PMBIDITEMQUOTEBO_V DA VIEW PMBIDITEMQUOTEBO_V1 DA VIEW PMBIDITEMQUOTEBO_V2 DA VIEW PMBIDITEMQUOTE_V DA VIEW PMBIDITEMQUOTE_V1 DA VIEW PMBIDITEMQUOTE_V2 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 DAR TRIGGER DBT_I_IUD_PMBIDDER DAR TRIGGER DBT_I_IUD_PMBIDDER_ALL DAR VIEW PMADDENDABIDPACKAGES_V DAR VIEW PMADDENDAFORVENDOR_V DAR VIEW PMBIDDER DAR VIEW PMBIDDERBIDPACKAGE_V DAR VIEW PMBIDDER_ALL_V DAR VIEW PMBIDDER_V DAR VIEW PMBIDITEMQUOTEBO_V DAR VIEW PMBIDPACKAGEQUOTE_V DAR VIEW PMITBBROADCASTDETAIL_V DAR VIEW PMNOTEATTCOUNT_V DAR VIEW SYSCLOGPMBIDDERESPONSE_V JSR PACKAGE BODY DBK_JSR_PMBIDANBOJSP01 JSR VIEW JSR_PMBIDANBOJSP01 JSR VIEW JSR_PMBIDANBOJSP01V1 JSR VIEW JSR_PMBIDANBOJSP01V2 JSR VIEW JSR_PMBIDANBOJSP01V3 REPORT_WRI VIEW HMCG_BID_LIST_V REPORT_WRI VIEW STA_PURCHASING_SUMMARY =================================================================== DB=test A_TEST01 07-AUG-24 08.10.20.736088 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. -- ====================================================================== -- 2487966_1.sql completed. Output in 2487966_1.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 The following invalid objects were created after this installation: =================================================================== DA PACKAGE BODY DBK_SYS_CONTACT DA PACKAGE BODY DBK_ATTACHMENT DA VIEW PMBIDDER_V JSR VIEW JSR_PMBIDANBOJSP01V3 DA PACKAGE BODY DBK_SYS_PARTNER JSR VIEW JSR_PMBIDANBOJSP01V2 JSR VIEW JSR_PMBIDANBOJSP01V1 DA PACKAGE BODY DBK_RPT_DIST DA VIEW PMBIDITEMQUOTEBO_V2 DA VIEW PMBIDITEMQUOTEBO_V1 DAR TRIGGER DBT_I_IUD_PMBIDDER DAR VIEW PMADDENDABIDPACKAGES_V REPORT_WRI VIEW STA_PURCHASING_SUMMARY DAR VIEW PMBIDDERBIDPACKAGE_V DA PACKAGE BODY DBK_PM_CONTACT DA PACKAGE BODY DBK_BP_PARTNER DA PACKAGE BODY DBK_PM_PARTNER DA PACKAGE BODY DBK_DC_PMBIDDER DA PACKAGE BODY DBK_COPY_PO DAR VIEW PMBIDDER DAR VIEW PMBIDDER_ALL_V DAR VIEW PMADDENDAFORVENDOR_V DA PACKAGE BODY DBK_PM_PURCHASE_BUYOUT DA PACKAGE BODY DBK_PO_DETAIL_IMPORT DA PACKAGE BODY DBK_COL_RPT_UTIL DA VIEW PMBIDITEMQUOTE_V JSR PACKAGE BODY DBK_JSR_PMBIDANBOJSP01 DA PACKAGE BODY DBK_PO_RELEASE DA PACKAGE BODY DBK_PM_SC DAR TRIGGER DBT_I_IUD_PMBIDDER_ALL DAR VIEW PMBIDPACKAGEQUOTE_V DAR VIEW SYSCLOGPMBIDDERESPONSE_V DAR VIEW PMBIDITEMQUOTEBO_V DA VIEW PMBIDDER_V0 DA PACKAGE DBK_PM_PURCHASE_BID DA PACKAGE BODY DBK_PO DA TRIGGER DBT_I_IUD_BID_ITEM_QUOTEBO DA PACKAGE BODY DBK_PM_ITB DAR VIEW PMITBBROADCASTDETAIL_V DA PACKAGE BODY DBK_PMHCSSIMPORT REPORT_WRI VIEW HMCG_BID_LIST_V DA VIEW PMBIDITEMQUOTEBO_V DA PACKAGE BODY DBK_PM_PURCHASE_BID DA PACKAGE BODY DBK_JC_CONT_FORECAST_2 DA PACKAGE BODY DBK_PM_CHANGE DA VIEW FLPM2000_V DA TRIGGER DBT_I_IUD_BID_ITEM_QUOTE DAR VIEW PMBIDDER_V DA PACKAGE BODY DBK_PM_PREQUAL DA PACKAGE BODY DBK_SD_CONVERT_ATTACH_TO_DOC JSR VIEW JSR_PMBIDANBOJSP01 DA PACKAGE BODY DBK_PM_BIDP DA PACKAGE BODY DBK_PM_PROJECT DA VIEW FLPM2200_V5 DAR VIEW PMNOTEATTCOUNT_V DA VIEW PMBIDITEMQUOTE_V2 DA VIEW PMBIDITEMQUOTE_V1 DA PACKAGE BODY DBK_SC_IMPORT DA TRIGGER DBT_A_ID_R_BPCSICODE_TN *** end of new invalid object *** deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.87966 was successfully installed, but with warnings. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 1 Warning Errors: 0 Informative Errors: 216 ---------CRITICAL ERRORS--------- 1300 | The following invalid objects were created after this installation: 1301 | =================================================================== 1302 | DA PACKAGE BODY DBK_SYS_CONTACT 1303 | DA PACKAGE BODY DBK_ATTACHMENT 1304 | DA VIEW PMBIDDER_V 1305 | JSR VIEW JSR_PMBIDANBOJSP01V3 1306 | DA PACKAGE BODY DBK_SYS_PARTNER 1307 | JSR VIEW JSR_PMBIDANBOJSP01V2 1308 | JSR VIEW JSR_PMBIDANBOJSP01V1 1309 | DA PACKAGE BODY DBK_RPT_DIST 1310 | DA VIEW PMBIDITEMQUOTEBO_V2 1311 | DA VIEW PMBIDITEMQUOTEBO_V1 1312 | DAR TRIGGER DBT_I_IUD_PMBIDDER 1313 | DAR VIEW PMADDENDABIDPACKAGES_V 1314 | REPORT_WRI VIEW STA_PURCHASING_SUMMARY 1315 | DAR VIEW PMBIDDERBIDPACKAGE_V 1316 | DA PACKAGE BODY DBK_PM_CONTACT 1317 | DA PACKAGE BODY DBK_BP_PARTNER 1318 | DA PACKAGE BODY DBK_PM_PARTNER 1319 | DA PACKAGE BODY DBK_DC_PMBIDDER 1320 | DA PACKAGE BODY DBK_COPY_PO 1321 | DAR VIEW PMBIDDER 1322 | DAR VIEW PMBIDDER_ALL_V 1323 | DAR VIEW PMADDENDAFORVENDOR_V 1324 | DA PACKAGE BODY DBK_PM_PURCHASE_BUYOUT 1325 | DA PACKAGE BODY DBK_PO_DETAIL_IMPORT 1326 | DA PACKAGE BODY DBK_COL_RPT_UTIL 1327 | DA VIEW PMBIDITEMQUOTE_V 1328 | JSR PACKAGE BODY DBK_JSR_PMBIDANBOJSP01 1329 | DA PACKAGE BODY DBK_PO_RELEASE 1330 | DA PACKAGE BODY DBK_PM_SC 1331 | DAR TRIGGER DBT_I_IUD_PMBIDDER_ALL 1332 | DAR VIEW PMBIDPACKAGEQUOTE_V 1333 | DAR VIEW SYSCLOGPMBIDDERESPONSE_V 1334 | DAR VIEW PMBIDITEMQUOTEBO_V 1335 | DA VIEW PMBIDDER_V0 1336 | DA PACKAGE DBK_PM_PURCHASE_BID 1337 | DA PACKAGE BODY DBK_PO 1338 | DA TRIGGER DBT_I_IUD_BID_ITEM_QUOTEBO 1339 | DA PACKAGE BODY DBK_PM_ITB 1340 | DAR VIEW PMITBBROADCASTDETAIL_V 1341 | DA PACKAGE BODY DBK_PMHCSSIMPORT 1342 | REPORT_WRI VIEW HMCG_BID_LIST_V 1343 | DA VIEW PMBIDITEMQUOTEBO_V 1344 | DA PACKAGE BODY DBK_PM_PURCHASE_BID 1345 | DA PACKAGE BODY DBK_JC_CONT_FORECAST_2 1346 | DA PACKAGE BODY DBK_PM_CHANGE 1347 | DA VIEW FLPM2000_V 1348 | DA TRIGGER DBT_I_IUD_BID_ITEM_QUOTE 1349 | DAR VIEW PMBIDDER_V 1350 | DA PACKAGE BODY DBK_PM_PREQUAL 1351 | DA PACKAGE BODY DBK_SD_CONVERT_ATTACH_TO_DOC 1352 | JSR VIEW JSR_PMBIDANBOJSP01 1353 | DA PACKAGE BODY DBK_PM_BIDP 1354 | DA PACKAGE BODY DBK_PM_PROJECT 1355 | DA VIEW FLPM2200_V5 1356 | DAR VIEW PMNOTEATTCOUNT_V 1357 | DA VIEW PMBIDITEMQUOTE_V2 1358 | DA VIEW PMBIDITEMQUOTE_V1 1359 | DA PACKAGE BODY DBK_SC_IMPORT 1360 | DA TRIGGER DBT_A_ID_R_BPCSICODE_TN ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 122 | * 123 | ERROR at line 1: 124 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 125 | ORA-06512: at "SYS.UTL_RECOMP", line 927 123 | ERROR at line 1: 124 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 125 | ORA-06512: at "SYS.UTL_RECOMP", line 927 126 | ORA-06512: at "SYS.DBMS_STATS", line 40799 124 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 125 | ORA-06512: at "SYS.UTL_RECOMP", line 927 126 | ORA-06512: at "SYS.DBMS_STATS", line 40799 127 | ORA-06512: at "SYS.DBMS_STATS", line 5065 125 | ORA-06512: at "SYS.UTL_RECOMP", line 927 126 | ORA-06512: at "SYS.DBMS_STATS", line 40799 127 | ORA-06512: at "SYS.DBMS_STATS", line 5065 128 | ORA-06512: at "SYS.DBMS_STATS", line 40725 126 | ORA-06512: at "SYS.DBMS_STATS", line 40799 127 | ORA-06512: at "SYS.DBMS_STATS", line 5065 128 | ORA-06512: at "SYS.DBMS_STATS", line 40725 129 | ORA-06512: at "SYS.UTL_RECOMP", line 260 127 | ORA-06512: at "SYS.DBMS_STATS", line 5065 128 | ORA-06512: at "SYS.DBMS_STATS", line 40725 129 | ORA-06512: at "SYS.UTL_RECOMP", line 260 130 | ORA-06512: at "SYS.UTL_RECOMP", line 830 128 | ORA-06512: at "SYS.DBMS_STATS", line 40725 129 | ORA-06512: at "SYS.UTL_RECOMP", line 260 130 | ORA-06512: at "SYS.UTL_RECOMP", line 830 131 | ORA-06512: at line 1 129 | ORA-06512: at "SYS.UTL_RECOMP", line 260 130 | ORA-06512: at "SYS.UTL_RECOMP", line 830 131 | ORA-06512: at line 1 132 | 276 | * 277 | ERROR at line 1: 278 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 279 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 277 | ERROR at line 1: 278 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 279 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 280 | ORA-06512: at "SYS.UTL_RECOMP", line 927 278 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 279 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 280 | ORA-06512: at "SYS.UTL_RECOMP", line 927 281 | ORA-06512: at "SYS.DBMS_STATS", line 40799 279 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 280 | ORA-06512: at "SYS.UTL_RECOMP", line 927 281 | ORA-06512: at "SYS.DBMS_STATS", line 40799 282 | ORA-06512: at "SYS.DBMS_STATS", line 5065 280 | ORA-06512: at "SYS.UTL_RECOMP", line 927 281 | ORA-06512: at "SYS.DBMS_STATS", line 40799 282 | ORA-06512: at "SYS.DBMS_STATS", line 5065 283 | ORA-06512: at "SYS.DBMS_STATS", line 40725 281 | ORA-06512: at "SYS.DBMS_STATS", line 40799 282 | ORA-06512: at "SYS.DBMS_STATS", line 5065 283 | ORA-06512: at "SYS.DBMS_STATS", line 40725 284 | ORA-06512: at "SYS.UTL_RECOMP", line 260 282 | ORA-06512: at "SYS.DBMS_STATS", line 5065 283 | ORA-06512: at "SYS.DBMS_STATS", line 40725 284 | ORA-06512: at "SYS.UTL_RECOMP", line 260 285 | ORA-06512: at "SYS.UTL_RECOMP", line 830 283 | ORA-06512: at "SYS.DBMS_STATS", line 40725 284 | ORA-06512: at "SYS.UTL_RECOMP", line 260 285 | ORA-06512: at "SYS.UTL_RECOMP", line 830 286 | ORA-06512: at "SYS.UTL_RECOMP", line 940 284 | ORA-06512: at "SYS.UTL_RECOMP", line 260 285 | ORA-06512: at "SYS.UTL_RECOMP", line 830 286 | ORA-06512: at "SYS.UTL_RECOMP", line 940 287 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 285 | ORA-06512: at "SYS.UTL_RECOMP", line 830 286 | ORA-06512: at "SYS.UTL_RECOMP", line 940 287 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 288 | ORA-06512: at line 1 286 | ORA-06512: at "SYS.UTL_RECOMP", line 940 287 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 288 | ORA-06512: at line 1 289 | 297 | * 298 | ERROR at line 1: 299 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 300 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 298 | ERROR at line 1: 299 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 300 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 301 | ORA-06512: at "SYS.UTL_RECOMP", line 927 299 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 300 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 301 | ORA-06512: at "SYS.UTL_RECOMP", line 927 302 | ORA-06512: at "SYS.DBMS_STATS", line 40799 300 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 301 | ORA-06512: at "SYS.UTL_RECOMP", line 927 302 | ORA-06512: at "SYS.DBMS_STATS", line 40799 303 | ORA-06512: at "SYS.DBMS_STATS", line 5065 301 | ORA-06512: at "SYS.UTL_RECOMP", line 927 302 | ORA-06512: at "SYS.DBMS_STATS", line 40799 303 | ORA-06512: at "SYS.DBMS_STATS", line 5065 304 | ORA-06512: at "SYS.DBMS_STATS", line 40725 302 | ORA-06512: at "SYS.DBMS_STATS", line 40799 303 | ORA-06512: at "SYS.DBMS_STATS", line 5065 304 | ORA-06512: at "SYS.DBMS_STATS", line 40725 305 | ORA-06512: at "SYS.UTL_RECOMP", line 260 303 | ORA-06512: at "SYS.DBMS_STATS", line 5065 304 | ORA-06512: at "SYS.DBMS_STATS", line 40725 305 | ORA-06512: at "SYS.UTL_RECOMP", line 260 306 | ORA-06512: at "SYS.UTL_RECOMP", line 830 304 | ORA-06512: at "SYS.DBMS_STATS", line 40725 305 | ORA-06512: at "SYS.UTL_RECOMP", line 260 306 | ORA-06512: at "SYS.UTL_RECOMP", line 830 307 | ORA-06512: at "SYS.UTL_RECOMP", line 940 305 | ORA-06512: at "SYS.UTL_RECOMP", line 260 306 | ORA-06512: at "SYS.UTL_RECOMP", line 830 307 | ORA-06512: at "SYS.UTL_RECOMP", line 940 308 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 306 | ORA-06512: at "SYS.UTL_RECOMP", line 830 307 | ORA-06512: at "SYS.UTL_RECOMP", line 940 308 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 309 | ORA-06512: at line 1 307 | ORA-06512: at "SYS.UTL_RECOMP", line 940 308 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 309 | ORA-06512: at line 1 310 | 318 | * 319 | ERROR at line 1: 320 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 321 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 319 | ERROR at line 1: 320 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 321 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 322 | ORA-06512: at "SYS.UTL_RECOMP", line 927 320 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 321 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 322 | ORA-06512: at "SYS.UTL_RECOMP", line 927 323 | ORA-06512: at "SYS.DBMS_STATS", line 40799 321 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 322 | ORA-06512: at "SYS.UTL_RECOMP", line 927 323 | ORA-06512: at "SYS.DBMS_STATS", line 40799 324 | ORA-06512: at "SYS.DBMS_STATS", line 5065 322 | ORA-06512: at "SYS.UTL_RECOMP", line 927 323 | ORA-06512: at "SYS.DBMS_STATS", line 40799 324 | ORA-06512: at "SYS.DBMS_STATS", line 5065 325 | ORA-06512: at "SYS.DBMS_STATS", line 40725 323 | ORA-06512: at "SYS.DBMS_STATS", line 40799 324 | ORA-06512: at "SYS.DBMS_STATS", line 5065 325 | ORA-06512: at "SYS.DBMS_STATS", line 40725 326 | ORA-06512: at "SYS.UTL_RECOMP", line 260 324 | ORA-06512: at "SYS.DBMS_STATS", line 5065 325 | ORA-06512: at "SYS.DBMS_STATS", line 40725 326 | ORA-06512: at "SYS.UTL_RECOMP", line 260 327 | ORA-06512: at "SYS.UTL_RECOMP", line 830 325 | ORA-06512: at "SYS.DBMS_STATS", line 40725 326 | ORA-06512: at "SYS.UTL_RECOMP", line 260 327 | ORA-06512: at "SYS.UTL_RECOMP", line 830 328 | ORA-06512: at "SYS.UTL_RECOMP", line 940 326 | ORA-06512: at "SYS.UTL_RECOMP", line 260 327 | ORA-06512: at "SYS.UTL_RECOMP", line 830 328 | ORA-06512: at "SYS.UTL_RECOMP", line 940 329 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 327 | ORA-06512: at "SYS.UTL_RECOMP", line 830 328 | ORA-06512: at "SYS.UTL_RECOMP", line 940 329 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 330 | ORA-06512: at line 1 328 | ORA-06512: at "SYS.UTL_RECOMP", line 940 329 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 330 | ORA-06512: at line 1 331 | 339 | * 340 | ERROR at line 1: 341 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 342 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 340 | ERROR at line 1: 341 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 342 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 343 | ORA-06512: at "SYS.UTL_RECOMP", line 927 341 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 342 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 343 | ORA-06512: at "SYS.UTL_RECOMP", line 927 344 | ORA-06512: at "SYS.DBMS_STATS", line 40799 342 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 343 | ORA-06512: at "SYS.UTL_RECOMP", line 927 344 | ORA-06512: at "SYS.DBMS_STATS", line 40799 345 | ORA-06512: at "SYS.DBMS_STATS", line 5065 343 | ORA-06512: at "SYS.UTL_RECOMP", line 927 344 | ORA-06512: at "SYS.DBMS_STATS", line 40799 345 | ORA-06512: at "SYS.DBMS_STATS", line 5065 346 | ORA-06512: at "SYS.DBMS_STATS", line 40725 344 | ORA-06512: at "SYS.DBMS_STATS", line 40799 345 | ORA-06512: at "SYS.DBMS_STATS", line 5065 346 | ORA-06512: at "SYS.DBMS_STATS", line 40725 347 | ORA-06512: at "SYS.UTL_RECOMP", line 260 345 | ORA-06512: at "SYS.DBMS_STATS", line 5065 346 | ORA-06512: at "SYS.DBMS_STATS", line 40725 347 | ORA-06512: at "SYS.UTL_RECOMP", line 260 348 | ORA-06512: at "SYS.UTL_RECOMP", line 830 346 | ORA-06512: at "SYS.DBMS_STATS", line 40725 347 | ORA-06512: at "SYS.UTL_RECOMP", line 260 348 | ORA-06512: at "SYS.UTL_RECOMP", line 830 349 | ORA-06512: at "SYS.UTL_RECOMP", line 940 347 | ORA-06512: at "SYS.UTL_RECOMP", line 260 348 | ORA-06512: at "SYS.UTL_RECOMP", line 830 349 | ORA-06512: at "SYS.UTL_RECOMP", line 940 350 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 348 | ORA-06512: at "SYS.UTL_RECOMP", line 830 349 | ORA-06512: at "SYS.UTL_RECOMP", line 940 350 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 351 | ORA-06512: at line 1 349 | ORA-06512: at "SYS.UTL_RECOMP", line 940 350 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 351 | ORA-06512: at line 1 352 | 360 | * 361 | ERROR at line 1: 362 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 363 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 361 | ERROR at line 1: 362 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 363 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 364 | ORA-06512: at "SYS.UTL_RECOMP", line 927 362 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 363 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 364 | ORA-06512: at "SYS.UTL_RECOMP", line 927 365 | ORA-06512: at "SYS.DBMS_STATS", line 40799 363 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 364 | ORA-06512: at "SYS.UTL_RECOMP", line 927 365 | ORA-06512: at "SYS.DBMS_STATS", line 40799 366 | ORA-06512: at "SYS.DBMS_STATS", line 5065 364 | ORA-06512: at "SYS.UTL_RECOMP", line 927 365 | ORA-06512: at "SYS.DBMS_STATS", line 40799 366 | ORA-06512: at "SYS.DBMS_STATS", line 5065 367 | ORA-06512: at "SYS.DBMS_STATS", line 40725 365 | ORA-06512: at "SYS.DBMS_STATS", line 40799 366 | ORA-06512: at "SYS.DBMS_STATS", line 5065 367 | ORA-06512: at "SYS.DBMS_STATS", line 40725 368 | ORA-06512: at "SYS.UTL_RECOMP", line 260 366 | ORA-06512: at "SYS.DBMS_STATS", line 5065 367 | ORA-06512: at "SYS.DBMS_STATS", line 40725 368 | ORA-06512: at "SYS.UTL_RECOMP", line 260 369 | ORA-06512: at "SYS.UTL_RECOMP", line 830 367 | ORA-06512: at "SYS.DBMS_STATS", line 40725 368 | ORA-06512: at "SYS.UTL_RECOMP", line 260 369 | ORA-06512: at "SYS.UTL_RECOMP", line 830 370 | ORA-06512: at "SYS.UTL_RECOMP", line 940 368 | ORA-06512: at "SYS.UTL_RECOMP", line 260 369 | ORA-06512: at "SYS.UTL_RECOMP", line 830 370 | ORA-06512: at "SYS.UTL_RECOMP", line 940 371 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 369 | ORA-06512: at "SYS.UTL_RECOMP", line 830 370 | ORA-06512: at "SYS.UTL_RECOMP", line 940 371 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 372 | ORA-06512: at line 1 370 | ORA-06512: at "SYS.UTL_RECOMP", line 940 371 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 372 | ORA-06512: at line 1 373 | 381 | * 382 | ERROR at line 1: 383 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 384 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 382 | ERROR at line 1: 383 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 384 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 385 | ORA-06512: at "SYS.UTL_RECOMP", line 927 383 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 384 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 385 | ORA-06512: at "SYS.UTL_RECOMP", line 927 386 | ORA-06512: at "SYS.DBMS_STATS", line 40799 384 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 385 | ORA-06512: at "SYS.UTL_RECOMP", line 927 386 | ORA-06512: at "SYS.DBMS_STATS", line 40799 387 | ORA-06512: at "SYS.DBMS_STATS", line 5065 385 | ORA-06512: at "SYS.UTL_RECOMP", line 927 386 | ORA-06512: at "SYS.DBMS_STATS", line 40799 387 | ORA-06512: at "SYS.DBMS_STATS", line 5065 388 | ORA-06512: at "SYS.DBMS_STATS", line 40725 386 | ORA-06512: at "SYS.DBMS_STATS", line 40799 387 | ORA-06512: at "SYS.DBMS_STATS", line 5065 388 | ORA-06512: at "SYS.DBMS_STATS", line 40725 389 | ORA-06512: at "SYS.UTL_RECOMP", line 260 387 | ORA-06512: at "SYS.DBMS_STATS", line 5065 388 | ORA-06512: at "SYS.DBMS_STATS", line 40725 389 | ORA-06512: at "SYS.UTL_RECOMP", line 260 390 | ORA-06512: at "SYS.UTL_RECOMP", line 830 388 | ORA-06512: at "SYS.DBMS_STATS", line 40725 389 | ORA-06512: at "SYS.UTL_RECOMP", line 260 390 | ORA-06512: at "SYS.UTL_RECOMP", line 830 391 | ORA-06512: at "SYS.UTL_RECOMP", line 940 389 | ORA-06512: at "SYS.UTL_RECOMP", line 260 390 | ORA-06512: at "SYS.UTL_RECOMP", line 830 391 | ORA-06512: at "SYS.UTL_RECOMP", line 940 392 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 390 | ORA-06512: at "SYS.UTL_RECOMP", line 830 391 | ORA-06512: at "SYS.UTL_RECOMP", line 940 392 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 393 | ORA-06512: at line 1 391 | ORA-06512: at "SYS.UTL_RECOMP", line 940 392 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 393 | ORA-06512: at line 1 394 | 402 | * 403 | ERROR at line 1: 404 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 405 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 403 | ERROR at line 1: 404 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 405 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 406 | ORA-06512: at "SYS.UTL_RECOMP", line 927 404 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 405 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 406 | ORA-06512: at "SYS.UTL_RECOMP", line 927 407 | ORA-06512: at "SYS.DBMS_STATS", line 40799 405 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 406 | ORA-06512: at "SYS.UTL_RECOMP", line 927 407 | ORA-06512: at "SYS.DBMS_STATS", line 40799 408 | ORA-06512: at "SYS.DBMS_STATS", line 5065 406 | ORA-06512: at "SYS.UTL_RECOMP", line 927 407 | ORA-06512: at "SYS.DBMS_STATS", line 40799 408 | ORA-06512: at "SYS.DBMS_STATS", line 5065 409 | ORA-06512: at "SYS.DBMS_STATS", line 40725 407 | ORA-06512: at "SYS.DBMS_STATS", line 40799 408 | ORA-06512: at "SYS.DBMS_STATS", line 5065 409 | ORA-06512: at "SYS.DBMS_STATS", line 40725 410 | ORA-06512: at "SYS.UTL_RECOMP", line 260 408 | ORA-06512: at "SYS.DBMS_STATS", line 5065 409 | ORA-06512: at "SYS.DBMS_STATS", line 40725 410 | ORA-06512: at "SYS.UTL_RECOMP", line 260 411 | ORA-06512: at "SYS.UTL_RECOMP", line 830 409 | ORA-06512: at "SYS.DBMS_STATS", line 40725 410 | ORA-06512: at "SYS.UTL_RECOMP", line 260 411 | ORA-06512: at "SYS.UTL_RECOMP", line 830 412 | ORA-06512: at "SYS.UTL_RECOMP", line 940 410 | ORA-06512: at "SYS.UTL_RECOMP", line 260 411 | ORA-06512: at "SYS.UTL_RECOMP", line 830 412 | ORA-06512: at "SYS.UTL_RECOMP", line 940 413 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 411 | ORA-06512: at "SYS.UTL_RECOMP", line 830 412 | ORA-06512: at "SYS.UTL_RECOMP", line 940 413 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 414 | ORA-06512: at line 1 412 | ORA-06512: at "SYS.UTL_RECOMP", line 940 413 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 414 | ORA-06512: at line 1 415 | 423 | * 424 | ERROR at line 1: 425 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 426 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 424 | ERROR at line 1: 425 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 426 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 427 | ORA-06512: at "SYS.UTL_RECOMP", line 927 425 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 426 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 427 | ORA-06512: at "SYS.UTL_RECOMP", line 927 428 | ORA-06512: at "SYS.DBMS_STATS", line 40799 426 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 427 | ORA-06512: at "SYS.UTL_RECOMP", line 927 428 | ORA-06512: at "SYS.DBMS_STATS", line 40799 429 | ORA-06512: at "SYS.DBMS_STATS", line 5065 427 | ORA-06512: at "SYS.UTL_RECOMP", line 927 428 | ORA-06512: at "SYS.DBMS_STATS", line 40799 429 | ORA-06512: at "SYS.DBMS_STATS", line 5065 430 | ORA-06512: at "SYS.DBMS_STATS", line 40725 428 | ORA-06512: at "SYS.DBMS_STATS", line 40799 429 | ORA-06512: at "SYS.DBMS_STATS", line 5065 430 | ORA-06512: at "SYS.DBMS_STATS", line 40725 431 | ORA-06512: at "SYS.UTL_RECOMP", line 260 429 | ORA-06512: at "SYS.DBMS_STATS", line 5065 430 | ORA-06512: at "SYS.DBMS_STATS", line 40725 431 | ORA-06512: at "SYS.UTL_RECOMP", line 260 432 | ORA-06512: at "SYS.UTL_RECOMP", line 830 430 | ORA-06512: at "SYS.DBMS_STATS", line 40725 431 | ORA-06512: at "SYS.UTL_RECOMP", line 260 432 | ORA-06512: at "SYS.UTL_RECOMP", line 830 433 | ORA-06512: at "SYS.UTL_RECOMP", line 940 431 | ORA-06512: at "SYS.UTL_RECOMP", line 260 432 | ORA-06512: at "SYS.UTL_RECOMP", line 830 433 | ORA-06512: at "SYS.UTL_RECOMP", line 940 434 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 432 | ORA-06512: at "SYS.UTL_RECOMP", line 830 433 | ORA-06512: at "SYS.UTL_RECOMP", line 940 434 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 435 | ORA-06512: at line 1 433 | ORA-06512: at "SYS.UTL_RECOMP", line 940 434 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 435 | ORA-06512: at line 1 436 | 443 | * 444 | ERROR at line 1: 445 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 446 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 444 | ERROR at line 1: 445 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 446 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 447 | ORA-06512: at "SYS.UTL_RECOMP", line 927 445 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 446 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 447 | ORA-06512: at "SYS.UTL_RECOMP", line 927 448 | ORA-06512: at "SYS.DBMS_STATS", line 40799 446 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 447 | ORA-06512: at "SYS.UTL_RECOMP", line 927 448 | ORA-06512: at "SYS.DBMS_STATS", line 40799 449 | ORA-06512: at "SYS.DBMS_STATS", line 5065 447 | ORA-06512: at "SYS.UTL_RECOMP", line 927 448 | ORA-06512: at "SYS.DBMS_STATS", line 40799 449 | ORA-06512: at "SYS.DBMS_STATS", line 5065 450 | ORA-06512: at "SYS.DBMS_STATS", line 40725 448 | ORA-06512: at "SYS.DBMS_STATS", line 40799 449 | ORA-06512: at "SYS.DBMS_STATS", line 5065 450 | ORA-06512: at "SYS.DBMS_STATS", line 40725 451 | ORA-06512: at "SYS.UTL_RECOMP", line 260 449 | ORA-06512: at "SYS.DBMS_STATS", line 5065 450 | ORA-06512: at "SYS.DBMS_STATS", line 40725 451 | ORA-06512: at "SYS.UTL_RECOMP", line 260 452 | ORA-06512: at "SYS.UTL_RECOMP", line 830 450 | ORA-06512: at "SYS.DBMS_STATS", line 40725 451 | ORA-06512: at "SYS.UTL_RECOMP", line 260 452 | ORA-06512: at "SYS.UTL_RECOMP", line 830 453 | ORA-06512: at "SYS.UTL_RECOMP", line 940 451 | ORA-06512: at "SYS.UTL_RECOMP", line 260 452 | ORA-06512: at "SYS.UTL_RECOMP", line 830 453 | ORA-06512: at "SYS.UTL_RECOMP", line 940 454 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 452 | ORA-06512: at "SYS.UTL_RECOMP", line 830 453 | ORA-06512: at "SYS.UTL_RECOMP", line 940 454 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 455 | ORA-06512: at line 6 453 | ORA-06512: at "SYS.UTL_RECOMP", line 940 454 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 455 | ORA-06512: at line 6 456 | ORA-06512: at line 6 454 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 455 | ORA-06512: at line 6 456 | ORA-06512: at line 6 457 | 708 | * 709 | ERROR at line 1: 710 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 711 | ORA-06512: at "SYS.UTL_RECOMP", line 927 709 | ERROR at line 1: 710 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 711 | ORA-06512: at "SYS.UTL_RECOMP", line 927 712 | ORA-06512: at "SYS.DBMS_STATS", line 40799 710 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 711 | ORA-06512: at "SYS.UTL_RECOMP", line 927 712 | ORA-06512: at "SYS.DBMS_STATS", line 40799 713 | ORA-06512: at "SYS.DBMS_STATS", line 5065 711 | ORA-06512: at "SYS.UTL_RECOMP", line 927 712 | ORA-06512: at "SYS.DBMS_STATS", line 40799 713 | ORA-06512: at "SYS.DBMS_STATS", line 5065 714 | ORA-06512: at "SYS.DBMS_STATS", line 40725 712 | ORA-06512: at "SYS.DBMS_STATS", line 40799 713 | ORA-06512: at "SYS.DBMS_STATS", line 5065 714 | ORA-06512: at "SYS.DBMS_STATS", line 40725 715 | ORA-06512: at "SYS.UTL_RECOMP", line 260 713 | ORA-06512: at "SYS.DBMS_STATS", line 5065 714 | ORA-06512: at "SYS.DBMS_STATS", line 40725 715 | ORA-06512: at "SYS.UTL_RECOMP", line 260 716 | ORA-06512: at "SYS.UTL_RECOMP", line 830 714 | ORA-06512: at "SYS.DBMS_STATS", line 40725 715 | ORA-06512: at "SYS.UTL_RECOMP", line 260 716 | ORA-06512: at "SYS.UTL_RECOMP", line 830 717 | ORA-06512: at line 1 715 | ORA-06512: at "SYS.UTL_RECOMP", line 260 716 | ORA-06512: at "SYS.UTL_RECOMP", line 830 717 | ORA-06512: at line 1 718 | 862 | * 863 | ERROR at line 1: 864 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 865 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 863 | ERROR at line 1: 864 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 865 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 866 | ORA-06512: at "SYS.UTL_RECOMP", line 927 864 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 865 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 866 | ORA-06512: at "SYS.UTL_RECOMP", line 927 867 | ORA-06512: at "SYS.DBMS_STATS", line 40799 865 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 866 | ORA-06512: at "SYS.UTL_RECOMP", line 927 867 | ORA-06512: at "SYS.DBMS_STATS", line 40799 868 | ORA-06512: at "SYS.DBMS_STATS", line 5065 866 | ORA-06512: at "SYS.UTL_RECOMP", line 927 867 | ORA-06512: at "SYS.DBMS_STATS", line 40799 868 | ORA-06512: at "SYS.DBMS_STATS", line 5065 869 | ORA-06512: at "SYS.DBMS_STATS", line 40725 867 | ORA-06512: at "SYS.DBMS_STATS", line 40799 868 | ORA-06512: at "SYS.DBMS_STATS", line 5065 869 | ORA-06512: at "SYS.DBMS_STATS", line 40725 870 | ORA-06512: at "SYS.UTL_RECOMP", line 260 868 | ORA-06512: at "SYS.DBMS_STATS", line 5065 869 | ORA-06512: at "SYS.DBMS_STATS", line 40725 870 | ORA-06512: at "SYS.UTL_RECOMP", line 260 871 | ORA-06512: at "SYS.UTL_RECOMP", line 830 869 | ORA-06512: at "SYS.DBMS_STATS", line 40725 870 | ORA-06512: at "SYS.UTL_RECOMP", line 260 871 | ORA-06512: at "SYS.UTL_RECOMP", line 830 872 | ORA-06512: at "SYS.UTL_RECOMP", line 940 870 | ORA-06512: at "SYS.UTL_RECOMP", line 260 871 | ORA-06512: at "SYS.UTL_RECOMP", line 830 872 | ORA-06512: at "SYS.UTL_RECOMP", line 940 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 871 | ORA-06512: at "SYS.UTL_RECOMP", line 830 872 | ORA-06512: at "SYS.UTL_RECOMP", line 940 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 874 | ORA-06512: at line 1 872 | ORA-06512: at "SYS.UTL_RECOMP", line 940 873 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 874 | ORA-06512: at line 1 875 | 883 | * 884 | ERROR at line 1: 885 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 886 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 884 | ERROR at line 1: 885 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 886 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 887 | ORA-06512: at "SYS.UTL_RECOMP", line 927 885 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 886 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 887 | ORA-06512: at "SYS.UTL_RECOMP", line 927 888 | ORA-06512: at "SYS.DBMS_STATS", line 40799 886 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 887 | ORA-06512: at "SYS.UTL_RECOMP", line 927 888 | ORA-06512: at "SYS.DBMS_STATS", line 40799 889 | ORA-06512: at "SYS.DBMS_STATS", line 5065 887 | ORA-06512: at "SYS.UTL_RECOMP", line 927 888 | ORA-06512: at "SYS.DBMS_STATS", line 40799 889 | ORA-06512: at "SYS.DBMS_STATS", line 5065 890 | ORA-06512: at "SYS.DBMS_STATS", line 40725 888 | ORA-06512: at "SYS.DBMS_STATS", line 40799 889 | ORA-06512: at "SYS.DBMS_STATS", line 5065 890 | ORA-06512: at "SYS.DBMS_STATS", line 40725 891 | ORA-06512: at "SYS.UTL_RECOMP", line 260 889 | ORA-06512: at "SYS.DBMS_STATS", line 5065 890 | ORA-06512: at "SYS.DBMS_STATS", line 40725 891 | ORA-06512: at "SYS.UTL_RECOMP", line 260 892 | ORA-06512: at "SYS.UTL_RECOMP", line 830 890 | ORA-06512: at "SYS.DBMS_STATS", line 40725 891 | ORA-06512: at "SYS.UTL_RECOMP", line 260 892 | ORA-06512: at "SYS.UTL_RECOMP", line 830 893 | ORA-06512: at "SYS.UTL_RECOMP", line 940 891 | ORA-06512: at "SYS.UTL_RECOMP", line 260 892 | ORA-06512: at "SYS.UTL_RECOMP", line 830 893 | ORA-06512: at "SYS.UTL_RECOMP", line 940 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 892 | ORA-06512: at "SYS.UTL_RECOMP", line 830 893 | ORA-06512: at "SYS.UTL_RECOMP", line 940 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 895 | ORA-06512: at line 1 893 | ORA-06512: at "SYS.UTL_RECOMP", line 940 894 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 895 | ORA-06512: at line 1 896 | 904 | * 905 | ERROR at line 1: 906 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 907 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 905 | ERROR at line 1: 906 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 907 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 908 | ORA-06512: at "SYS.UTL_RECOMP", line 927 906 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 907 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 908 | ORA-06512: at "SYS.UTL_RECOMP", line 927 909 | ORA-06512: at "SYS.DBMS_STATS", line 40799 907 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 908 | ORA-06512: at "SYS.UTL_RECOMP", line 927 909 | ORA-06512: at "SYS.DBMS_STATS", line 40799 910 | ORA-06512: at "SYS.DBMS_STATS", line 5065 908 | ORA-06512: at "SYS.UTL_RECOMP", line 927 909 | ORA-06512: at "SYS.DBMS_STATS", line 40799 910 | ORA-06512: at "SYS.DBMS_STATS", line 5065 911 | ORA-06512: at "SYS.DBMS_STATS", line 40725 909 | ORA-06512: at "SYS.DBMS_STATS", line 40799 910 | ORA-06512: at "SYS.DBMS_STATS", line 5065 911 | ORA-06512: at "SYS.DBMS_STATS", line 40725 912 | ORA-06512: at "SYS.UTL_RECOMP", line 260 910 | ORA-06512: at "SYS.DBMS_STATS", line 5065 911 | ORA-06512: at "SYS.DBMS_STATS", line 40725 912 | ORA-06512: at "SYS.UTL_RECOMP", line 260 913 | ORA-06512: at "SYS.UTL_RECOMP", line 830 911 | ORA-06512: at "SYS.DBMS_STATS", line 40725 912 | ORA-06512: at "SYS.UTL_RECOMP", line 260 913 | ORA-06512: at "SYS.UTL_RECOMP", line 830 914 | ORA-06512: at "SYS.UTL_RECOMP", line 940 912 | ORA-06512: at "SYS.UTL_RECOMP", line 260 913 | ORA-06512: at "SYS.UTL_RECOMP", line 830 914 | ORA-06512: at "SYS.UTL_RECOMP", line 940 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 913 | ORA-06512: at "SYS.UTL_RECOMP", line 830 914 | ORA-06512: at "SYS.UTL_RECOMP", line 940 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 916 | ORA-06512: at line 1 914 | ORA-06512: at "SYS.UTL_RECOMP", line 940 915 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 916 | ORA-06512: at line 1 917 | 925 | * 926 | ERROR at line 1: 927 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 928 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 926 | ERROR at line 1: 927 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 928 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 929 | ORA-06512: at "SYS.UTL_RECOMP", line 927 927 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 928 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 929 | ORA-06512: at "SYS.UTL_RECOMP", line 927 930 | ORA-06512: at "SYS.DBMS_STATS", line 40799 928 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 929 | ORA-06512: at "SYS.UTL_RECOMP", line 927 930 | ORA-06512: at "SYS.DBMS_STATS", line 40799 931 | ORA-06512: at "SYS.DBMS_STATS", line 5065 929 | ORA-06512: at "SYS.UTL_RECOMP", line 927 930 | ORA-06512: at "SYS.DBMS_STATS", line 40799 931 | ORA-06512: at "SYS.DBMS_STATS", line 5065 932 | ORA-06512: at "SYS.DBMS_STATS", line 40725 930 | ORA-06512: at "SYS.DBMS_STATS", line 40799 931 | ORA-06512: at "SYS.DBMS_STATS", line 5065 932 | ORA-06512: at "SYS.DBMS_STATS", line 40725 933 | ORA-06512: at "SYS.UTL_RECOMP", line 260 931 | ORA-06512: at "SYS.DBMS_STATS", line 5065 932 | ORA-06512: at "SYS.DBMS_STATS", line 40725 933 | ORA-06512: at "SYS.UTL_RECOMP", line 260 934 | ORA-06512: at "SYS.UTL_RECOMP", line 830 932 | ORA-06512: at "SYS.DBMS_STATS", line 40725 933 | ORA-06512: at "SYS.UTL_RECOMP", line 260 934 | ORA-06512: at "SYS.UTL_RECOMP", line 830 935 | ORA-06512: at "SYS.UTL_RECOMP", line 940 933 | ORA-06512: at "SYS.UTL_RECOMP", line 260 934 | ORA-06512: at "SYS.UTL_RECOMP", line 830 935 | ORA-06512: at "SYS.UTL_RECOMP", line 940 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 934 | ORA-06512: at "SYS.UTL_RECOMP", line 830 935 | ORA-06512: at "SYS.UTL_RECOMP", line 940 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 937 | ORA-06512: at line 1 935 | ORA-06512: at "SYS.UTL_RECOMP", line 940 936 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 937 | ORA-06512: at line 1 938 | 946 | * 947 | ERROR at line 1: 948 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 949 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 947 | ERROR at line 1: 948 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 949 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 950 | ORA-06512: at "SYS.UTL_RECOMP", line 927 948 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 949 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 950 | ORA-06512: at "SYS.UTL_RECOMP", line 927 951 | ORA-06512: at "SYS.DBMS_STATS", line 40799 949 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 950 | ORA-06512: at "SYS.UTL_RECOMP", line 927 951 | ORA-06512: at "SYS.DBMS_STATS", line 40799 952 | ORA-06512: at "SYS.DBMS_STATS", line 5065 950 | ORA-06512: at "SYS.UTL_RECOMP", line 927 951 | ORA-06512: at "SYS.DBMS_STATS", line 40799 952 | ORA-06512: at "SYS.DBMS_STATS", line 5065 953 | ORA-06512: at "SYS.DBMS_STATS", line 40725 951 | ORA-06512: at "SYS.DBMS_STATS", line 40799 952 | ORA-06512: at "SYS.DBMS_STATS", line 5065 953 | ORA-06512: at "SYS.DBMS_STATS", line 40725 954 | ORA-06512: at "SYS.UTL_RECOMP", line 260 952 | ORA-06512: at "SYS.DBMS_STATS", line 5065 953 | ORA-06512: at "SYS.DBMS_STATS", line 40725 954 | ORA-06512: at "SYS.UTL_RECOMP", line 260 955 | ORA-06512: at "SYS.UTL_RECOMP", line 830 953 | ORA-06512: at "SYS.DBMS_STATS", line 40725 954 | ORA-06512: at "SYS.UTL_RECOMP", line 260 955 | ORA-06512: at "SYS.UTL_RECOMP", line 830 956 | ORA-06512: at "SYS.UTL_RECOMP", line 940 954 | ORA-06512: at "SYS.UTL_RECOMP", line 260 955 | ORA-06512: at "SYS.UTL_RECOMP", line 830 956 | ORA-06512: at "SYS.UTL_RECOMP", line 940 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 955 | ORA-06512: at "SYS.UTL_RECOMP", line 830 956 | ORA-06512: at "SYS.UTL_RECOMP", line 940 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 958 | ORA-06512: at line 1 956 | ORA-06512: at "SYS.UTL_RECOMP", line 940 957 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 958 | ORA-06512: at line 1 959 | 967 | * 968 | ERROR at line 1: 969 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 970 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 968 | ERROR at line 1: 969 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 970 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 971 | ORA-06512: at "SYS.UTL_RECOMP", line 927 969 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 970 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 971 | ORA-06512: at "SYS.UTL_RECOMP", line 927 972 | ORA-06512: at "SYS.DBMS_STATS", line 40799 970 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 971 | ORA-06512: at "SYS.UTL_RECOMP", line 927 972 | ORA-06512: at "SYS.DBMS_STATS", line 40799 973 | ORA-06512: at "SYS.DBMS_STATS", line 5065 971 | ORA-06512: at "SYS.UTL_RECOMP", line 927 972 | ORA-06512: at "SYS.DBMS_STATS", line 40799 973 | ORA-06512: at "SYS.DBMS_STATS", line 5065 974 | ORA-06512: at "SYS.DBMS_STATS", line 40725 972 | ORA-06512: at "SYS.DBMS_STATS", line 40799 973 | ORA-06512: at "SYS.DBMS_STATS", line 5065 974 | ORA-06512: at "SYS.DBMS_STATS", line 40725 975 | ORA-06512: at "SYS.UTL_RECOMP", line 260 973 | ORA-06512: at "SYS.DBMS_STATS", line 5065 974 | ORA-06512: at "SYS.DBMS_STATS", line 40725 975 | ORA-06512: at "SYS.UTL_RECOMP", line 260 976 | ORA-06512: at "SYS.UTL_RECOMP", line 830 974 | ORA-06512: at "SYS.DBMS_STATS", line 40725 975 | ORA-06512: at "SYS.UTL_RECOMP", line 260 976 | ORA-06512: at "SYS.UTL_RECOMP", line 830 977 | ORA-06512: at "SYS.UTL_RECOMP", line 940 975 | ORA-06512: at "SYS.UTL_RECOMP", line 260 976 | ORA-06512: at "SYS.UTL_RECOMP", line 830 977 | ORA-06512: at "SYS.UTL_RECOMP", line 940 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 976 | ORA-06512: at "SYS.UTL_RECOMP", line 830 977 | ORA-06512: at "SYS.UTL_RECOMP", line 940 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 979 | ORA-06512: at line 1 977 | ORA-06512: at "SYS.UTL_RECOMP", line 940 978 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 979 | ORA-06512: at line 1 980 | 988 | * 989 | ERROR at line 1: 990 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 991 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 989 | ERROR at line 1: 990 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 991 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 992 | ORA-06512: at "SYS.UTL_RECOMP", line 927 990 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 991 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 992 | ORA-06512: at "SYS.UTL_RECOMP", line 927 993 | ORA-06512: at "SYS.DBMS_STATS", line 40799 991 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 992 | ORA-06512: at "SYS.UTL_RECOMP", line 927 993 | ORA-06512: at "SYS.DBMS_STATS", line 40799 994 | ORA-06512: at "SYS.DBMS_STATS", line 5065 992 | ORA-06512: at "SYS.UTL_RECOMP", line 927 993 | ORA-06512: at "SYS.DBMS_STATS", line 40799 994 | ORA-06512: at "SYS.DBMS_STATS", line 5065 995 | ORA-06512: at "SYS.DBMS_STATS", line 40725 993 | ORA-06512: at "SYS.DBMS_STATS", line 40799 994 | ORA-06512: at "SYS.DBMS_STATS", line 5065 995 | ORA-06512: at "SYS.DBMS_STATS", line 40725 996 | ORA-06512: at "SYS.UTL_RECOMP", line 260 994 | ORA-06512: at "SYS.DBMS_STATS", line 5065 995 | ORA-06512: at "SYS.DBMS_STATS", line 40725 996 | ORA-06512: at "SYS.UTL_RECOMP", line 260 997 | ORA-06512: at "SYS.UTL_RECOMP", line 830 995 | ORA-06512: at "SYS.DBMS_STATS", line 40725 996 | ORA-06512: at "SYS.UTL_RECOMP", line 260 997 | ORA-06512: at "SYS.UTL_RECOMP", line 830 998 | ORA-06512: at "SYS.UTL_RECOMP", line 940 996 | ORA-06512: at "SYS.UTL_RECOMP", line 260 997 | ORA-06512: at "SYS.UTL_RECOMP", line 830 998 | ORA-06512: at "SYS.UTL_RECOMP", line 940 999 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 997 | ORA-06512: at "SYS.UTL_RECOMP", line 830 998 | ORA-06512: at "SYS.UTL_RECOMP", line 940 999 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1000 | ORA-06512: at line 1 998 | ORA-06512: at "SYS.UTL_RECOMP", line 940 999 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1000 | ORA-06512: at line 1 1001 | 1009 | * 1010 | ERROR at line 1: 1011 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1012 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1010 | ERROR at line 1: 1011 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1012 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1013 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1011 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1012 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1013 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1014 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1012 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1013 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1014 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1015 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1013 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1014 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1015 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1016 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1014 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1015 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1016 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1017 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1015 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1016 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1017 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1018 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1016 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1017 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1018 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1019 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1017 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1018 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1019 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1018 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1019 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1021 | ORA-06512: at line 1 1019 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1020 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1021 | ORA-06512: at line 1 1022 | 1029 | * 1030 | ERROR at line 1: 1031 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1032 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1030 | ERROR at line 1: 1031 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1032 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1033 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1031 | ORA-20000: Unable to gather statistics concurrently: the job_queue_processes parameter is less than 4 1032 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1033 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1034 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1032 | ORA-06512: at "SYS.DBMS_UTILITY", line 439 1033 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1034 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1035 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1033 | ORA-06512: at "SYS.UTL_RECOMP", line 927 1034 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1035 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1036 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1034 | ORA-06512: at "SYS.DBMS_STATS", line 40799 1035 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1036 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1037 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1035 | ORA-06512: at "SYS.DBMS_STATS", line 5065 1036 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1037 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1038 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1036 | ORA-06512: at "SYS.DBMS_STATS", line 40725 1037 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1038 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1039 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1037 | ORA-06512: at "SYS.UTL_RECOMP", line 260 1038 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1039 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1040 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1038 | ORA-06512: at "SYS.UTL_RECOMP", line 830 1039 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1040 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1041 | ORA-06512: at line 6 1039 | ORA-06512: at "SYS.UTL_RECOMP", line 940 1040 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1041 | ORA-06512: at line 6 1042 | ORA-06512: at line 6 1040 | ORA-06512: at "SYS.DBMS_UTILITY", line 435 1041 | ORA-06512: at line 6 1042 | ORA-06512: at line 6 1043 | =============================== End of Installation Log Review ===============================