B*g
2 楼
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
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
s*l
3 楼
好歌！
MV配的漓江山水跟这首歌的大气不太搭
贴个live
http://www.youtube.com/watch?v=Zazxo8um5Ew
【在 L*L 的大作中提到】
MV配的漓江山水跟这首歌的大气不太搭
贴个live
http://www.youtube.com/watch?v=Zazxo8um5Ew
【在 L*L 的大作中提到】
B*g
4 楼
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;
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;
J*G
5 楼
这歌文章有条件唱得更大气，更有沧桑感，不知为什么他唱得这么抒情，这么软，尤其
前半部分。
看来这歌没写出大气来。
前半部分。
看来这歌没写出大气来。
c*d
6 楼
还没人出来说说？
我这几天没时间，要不就自己试试了
【在 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 的大作中提到】
: 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
7 楼
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 的大作中提到】
: 还没人出来说说？
: 我这几天没时间，要不就自己试试了
And has plenty of time at work, but can not test.
【在 c*****d 的大作中提到】
: 还没人出来说说？
: 我这几天没时间，要不就自己试试了
相关阅读
Late afternoon 腦不好使upgrade Microsoft SQL standard 2003 to SQL Enterprise 2003拜年了 (转载)一个oracle performance 的问题。Hyperthreading enable or disable?工作之事，当DBA会不会很烦这个QUERY怎么优化啊？Linked server problem好冷清how to upgrade sql 2005 to sql 2008?谁可以提供一下哪里有数据库相关工作怎么把这个表转换成另外一个表？请教高手，包子谢菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?好多工作都说最好懂数据库，怎么先补啊怎么写这个query呢？问一个转行到数据库方面的事,急求大家建议!Digg says yes to NoSQL, bye to MySQL (ZZ)sybase 问题请教兩台 19" 彩顯 可以怎麼玩?