资源描述:
《连接池效率测试(connection pool efficiency test)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、连接池效率测试(Connectionpoolefficiencytest)Connectionpoolefficiencytest.Txtwhatiscalledmyth?Listentomenexpresslovetoyou.Whatisthelegend?Listentotheman'spromisetoyou.Whatisadream?Seehowyoureactwhenyouhearthefirsttwo.Part1:thefollowingstepsareacompletedemonstrationofthejobcreationprocess:1,firstcreateapigt
2、able,andthefieldisadateformatSQL>,create,table,pig(a,date);TablecreatedSQL>commit;Commitcomplete2,createastoredprocedureBBthatactstoinsertdataintothepigtableSQL>,create,or,replace,procedure,BB,as2begin3,insert,into,pig,values(sysdate);4end;5/Procedurecreated3,createajobnamedjob2009;thefunctionistoe
3、xecuteastoredprocedureBBeveryminute(60*24=1440).SQL>declareSQL>job2009number;SQL>begin2,dbms_job.submit(job2009,'bb,'sysdate+1/1440',sysdate);Dbms_job.run(job2009);3end;4/Note:thesystemhereautomaticallygeneratesjobIDfor41PL/SQLproceduresuccessfullycompletedJob2009-Forty-one4,runjob2009SQL>begin2dbm
4、s_job.run(:job2009);3end;4/PL/SQLproceduresuccessfullycompletedJob2009-Forty-one5,deletejob2009SQL>begin2dbms_job.remove(:job2009);3end;4/6,querytherelevantviewofjobsSelect,job,last_date,last_sec,broken,failures,interval,what,from,dba_jobsExplainsomeofthemoreimportantfieldsindba_jobsJob:referstothe
5、IDnumberofjob.Forexample,the41aboveWhenfailures:jobexecutesthenumberoffailures,ifmorethan15times,thenthebrokencolumnwillbelabeledYandwillnotrunthejoblaterBroken:defaultstoN,andifitisY,itmeansthatthejobisnolongerexecuted!Interval:theintervalbetweenexecutingjob.What:theactualworkofthejob.Thesecondpar
6、t:therelatedknowledgeofjob:1,DBA_JOBSDBA_JOBS==============================Field(column)typedescriptionUniquesignnumberforJOBNUMBERtaskLOG_USERVARCHAR2(30)theuserwhosubmittedthetaskPRIV_USERVARCHAR2(30)auserwhogivestaskpermissionsSCHEMA_USERVARCHAR2(30)usermodeforsyntaxanalysisoftasksThelasttimeLAS
7、T_DATEDATEsuccessfullyranthetaskLAST_SECVARCHAR2(8),suchasHH24:MM:SS,last_date,date,hour,minuteandsecondTHIS_DATEDATEisrunningthestarttimeofthetask.Ifthereisnorunningtask,nullisTHIS_SECVARCHAR2(8),suchasHH2