Oracle-APEX3.0非常简单的安装步骤

SQLselectowa_util.get_versionfromdual;GET_VERSION--------------------------------------------------10.1.2.0.8SQL@F:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlrp.sql;TIMESTAMP-------------------------------------------------------------------------------COMP_TIMESTAMPUTLRP_BGN2016-09-2716:19:17DOCThefollowingPL/SQLblockinvokesUTL_RECOMPtorecompileinvalidDOCobjectsinthedatabase.RecompilationtimeisproportionaltotheDOCnumberofinvalidobjectsinthedatabase,sothiscommandmaytakeDOCalongtimetoexecuteonadatabasewithalargenumberofinvalidDOCobjects.DOCDOCUsethefollowingqueriestotrackrecompilationprogress:DOCDOC1.Queryreturningthenumberofinvalidobjectsremaining.ThisDOCnumbershoulddecreasewithtime.DOCSELECTCOUNT(*)FROMobj$WHEREstatusIN(4,5,6);DOCDOC2.Queryreturningthenumberofobjectscompiledsofar.ThisnumberDOCshouldincreasewithtime.DOCSELECTCOUNT(*)FROMUTL_RECOMP_COMPILED;DOCDOCThisscriptautomaticallychoosesserialorparallelrecompilationDOCbasedonthenumberofCPUsavailable(parametercpu_count)multipliedDOCbythenumberofthreadsperCPU(parameterparallel_threads_per_cpu).DOCOnRAC,thisnumberisaddedacrossallRACnodes.DOCDOCUTL_RECOMPusesDBMS_SCHEDULERtocreatejobsforparallelDOCrecompilation.JobsarecreatedwithoutinstanceaffinitysothattheyDOCcanmigrateacrossRACnodes.UsethefollowingqueriestoverifyDOCwhetherUTL_RECOMPjobsarebeingcreatedandruncorrectly:DOCDOC1.QueryshowingjobscreatedbyUTL_RECOMPDOCSELECTjob_nameFROMdba_scheduler_jobsDOCWHEREjob_namelike'UTL_RECOMP_SLAVE_%';DOCDOC2.QueryshowingUTL_RECOMPjobsthatarerunningDOCSELECTjob_nameFROMdba_scheduler_running_jobsDOCWHEREjob_namelike'UTL_RECOMP_SLAVE_%';DOC#PL/SQL过程已成功完成。TIMESTAMP-------------------------------------------------------------------------------COMP_TIMESTAMPUTLRP_END2016-09-2716:19:21DOCThefollowingqueryreportsthenumberofobjectsthathavecompiledDOCwitherrors(objectsthatcompilewitherrorshavestatussetto3inDOCobj$).Ifthenumberishigherthanexpected,pleaseexaminetheerrorDOCmessagesreportedwitheachobject(usingSHOWERRORS)toseeiftheyDOCpointtosystemmisconfigurationorresourceconstraintsthatmustbeDOCfixedbeforeattemptingtorecompiletheseobjects.DOC#OBJECTSWITHERRORS-------------------0DOCThefollowingqueryreportsthenumberoferrorscaughtduringDOCrecompilation.Ifthisnumberisnon-zero,pleasequerytheerrorDOCmessagesinthetableUTL_RECOMP_ERRORStoseeifanyoftheseerrorsDOCareduetomisconfigurationorresourceconstraintsthatmustbeDOCfixedbeforeobjectscancompilesuccessfully.DOC#ERRORSDURINGRECOMPILATION---------------------------0PL/SQL过程已成功完成。PL/SQL过程已成功完成。SQLalteruseranonymousaccountunlock;用户已更改。