Oracle - 需要查询以最大化CPU

作者: 十二*
发布时间: 2024-12-23 02:55:05 (11天前)
转自：

2 条回复

0#
回复此人
誓言你好 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 试试这个 </p> <pre> <code> declare l_job_out integer; l_what dba_jobs.what%type; l_cpus_to_hog CONSTANT integer :=4; l_loop_count varchar2(10) := '500000000'; begin /* ** Create some jobs to load the CPU */ for l_job in 1..l_cpus_to_hog loop dbms_job.submit( job => l_job_out , what => 'declare a number := 1; begin for i in 1..'||l_loop_count||' loop a := ( a + i )/11; end loop; end;' ); commit; dbms_output.put_line( 'job - '|| l_job_out ); select what into l_what from dba_jobs where job = l_job_out; dbms_output.put_line( 'what - '|| l_what ); end loop; end; </code> </pre> </DIV>

编辑

登录后才能参与评论