B*****g
发帖数: 34098 | 1 How does this resource limit work? it says per sql or per call. What does
per call mean for pl/sql?
If I have following pl/sql and cpu time limit is 9 secs.
begin
sp1( -- cpu 10 secs
sp1_1; -- cpu 8 secs
sp1_2; -- cpu 2 secs
);
sp2(); -- cpu 5 secs
end;
*** will this fail? ***
Thanks |
B*****g
发帖数: 34098 | 2 ding
How does this resource limit work? it says per sql or per call. What does
per call mean for pl/sql?
If I have following pl/sql and cpu time limit is 9 secs.
begin
sp1( -- cpu 10 secs
sp1_1; -- cpu 8 secs
sp1_2; -- cpu 2 secs
);
sp2(); -- cpu 5 secs
end;
*** will this fail? ***
Thanks
【在 B*****g 的大作中提到】
: How does this resource limit work? it says per sql or per call. What does
: per call mean for pl/sql?
: If I have following pl/sql and cpu time limit is 9 secs.
: begin
: sp1( -- cpu 10 secs
: sp1_1; -- cpu 8 secs
: sp1_2; -- cpu 2 secs
: );
: sp2(); -- cpu 5 secs
: end;
|
c*****d
发帖数: 6045 | 3 还没人出来说说？
我这几天没时间，要不就自己试试了
【在 B*****g 的大作中提到】
: ding
:
: How does this resource limit work? it says per sql or per call. What does
: per call mean for pl/sql?
: If I have following pl/sql and cpu time limit is 9 secs.
: begin
: sp1( -- cpu 10 secs
: sp1_1; -- cpu 8 secs
: sp1_2; -- cpu 2 secs
: );
|
B*****g
发帖数: 34098 | 4 what if the sps change to sql, also too busy this week, no time to test.
And has plenty of time at work, but can not test.
【在 c*****d 的大作中提到】
: 还没人出来说说？
: 我这几天没时间，要不就自己试试了
|
