连接池效率测试（Connection pool efficiency test）.docVIP

连接池效率测试（Connection pool efficiency test） Connection pool efficiency test.Txt what is called myth? Listen to men express love to you. What is the legend? Listen to the mans promise to you. What is a dream? See how you react when you hear the first two. Part 1: the following steps are a complete demonstration of the job creation process: 1, first create a pig table, and the field is a date format SQL, create, table, pig (a, date); Table created SQL commit; Commit complete 2, create a stored procedure BB that acts to insert data into the pig table SQL, create, or, replace, procedure, BB, as 2 begin 3, insert, into, pig, values (sysdate); 4 end; 5 / Procedure created 3, create a job named job2009; the function is to execute a stored procedure BB every minute (60 * 24=1440). SQL declare SQL job2009 number; SQL begin 2, dbms_job.submit (job2009,bb,sysdate+1/1440, sysdate); Dbms_job.run (job2009); 3 end; 4 / Note: the system here automatically generates job ID for 41 PL/SQL procedure successfully completed Job2009 - Forty-one 4, run job2009 SQL begin 2 dbms_job.run (: job2009); 3 end; 4 / PL/SQL procedure successfully completed Job2009 - Forty-one 5, delete job2009 SQL begin 2 dbms_job.remove (: job2009); 3 end; 4 / 6, query the relevant view of jobs Select, job, last_date, last_sec, broken, failures, interval, what, from, dba_jobs Explain some of the more important fields in dba_jobs Job: refers to the ID number of job. For example, the 41 above When failures:job executes the number of failures, if more than 15 times, then the broken column will be labeled Y and will not run the job later Broken: defaults to N, and if it is Y, it means that the job is no longer executed! Interval: the interval between executing job. What: the actual work of the job. The second part: the related knowledge of job: 1, DBA_JOBS DBA_JOBS = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Field (column) type description Unique sign number for JOB NUMBER task LOG_USER VARCHAR2 (30) the