由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Oracle CPU Time limit problem
相关主题
[转载] 真的没有人懂 ORACLE pro*c阿? :((((求助:SQL SETUP过程中的问题
how to make this queryOracle 8i for Linux
讨论一下经验积累型,能防老的工种吧!如何对ORACLE的结果既分页又排序?
Oracle 8i InstallationMS Access在工业界用得多普遍吗?
Does VB works with Oracleoracle license
怎样让oracle不要fail on errorOracle8概 述
why did this sql statement always fail in oracle?求职Oracle DBA
oracle 11gr2 installation problemProblems about runing Oracle8i
相关话题的讨论汇总
话题: secs话题: cpu话题: sp1话题: time话题: sql
进入Database版参与讨论
1 (共1页)
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 的大作中提到】
: 还没人出来说说?
: 我这几天没时间,要不就自己试试了

1 (共1页)
进入Database版参与讨论
相关主题
Problems about runing Oracle8iDoes VB works with Oracle
Problems on ACCESS + VB怎样让oracle不要fail on error
Mysqld cannot start with httpd problem, please hewhy did this sql statement always fail in oracle?
A problem in Accessoracle 11gr2 installation problem
[转载] 真的没有人懂 ORACLE pro*c阿? :((((求助:SQL SETUP过程中的问题
how to make this queryOracle 8i for Linux
讨论一下经验积累型,能防老的工种吧!如何对ORACLE的结果既分页又排序?
Oracle 8i InstallationMS Access在工业界用得多普遍吗?
相关话题的讨论汇总
话题: secs话题: cpu话题: sp1话题: time话题: sql