blocks|key|1858618|text|这两者之间应该没有区别。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1858619|包的主要用途是对一组相似/关联的functions%2Bprocedures进行分组|1858620|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

There should be no difference between the two.

A major use of packages is to group a set of similar/associeted functions+procedures

blocks|key|579006|text|除了包可以有状态和独立的过程和函数之外，没有性能差异。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|579007|package的使用更多的是关于代码的编排和分组。您可以将它们视为名称空间的替代。|579008|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

There isn't a performance difference except that packages can have state and standalone procedures and functions not. 

The use of package is more about ordening and grouping of code. You could see them as an alternative of namespaces.

blocks|key|556014|text|Tom+|type|unstyled|depth|inlineStyleRanges|entityRanges|data|556015|556016|总是使用包。|blockquote|556017|556018|除了演示、测试和独立实用程序(它们不调用任何东西，也不会被任何东西调用)之外，永远不要使用独立的过程。|556019|556020|在那里，您还可以找到关于它们的性能的非常好的讨论。只需在该页面上搜索“性能”即可。|556021|如果仍然有严重的疑问，你可以随时测试自己哪一个更快。通过这样做，你肯定会学到一些新东西。|556022|我对你的问题的看法是:虽然在某些情况下，调用包过程/函数似乎比调用独立的过程/函数慢，但使用包时提供的附加功能提供的优势远远超过了性能损失。所以，就像Tom说的那样，使用包。|556023|556024|链接：http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7452431376537|offset|length|556025|556026|测试代码(2000万次调用，runstats_pkg是我基于runstats+package+by+Tom+Kyte编写的包)：|556027|CREATE+OR+REPLACE+PACKAGE+testperf+AS
+++FUNCTION+pow(i+INT)+RETURN+INT;
END;
/

CREATE+OR+REPLACE+PACKAGE+BODY+testperf+AS
+++FUNCTION+pow(i+int)+RETURN+INT+AS
+++BEGIN
++++++RETURN+i+*+i;
+++END;
END;
/

CREATE+OR+REPLACE+FUNCTION+powperf(i+INT)+RETURN+INT+AS
BEGIN
+++RETURN+i+*+i;
END;
/

DECLARE
+++I+INT;
+++S+INT+DEFAULT+0;
BEGIN
+++runstats_pkg.start1;
+++FOR+I+IN+1+..+20000000+LOOP
++++++s+:=+s+%2B+(powperf(i)+/+i);
+++END+LOOP;
+++runstats_pkg.stop1;

+++dbms_output.put_line(s);
+++s+:=+0;

+++runstats_pkg.start2;
+++FOR+I+IN+1+..+20000000+LOOP
++++++s+:=+s+%2B+(testperf.pow(i)+/+i);
+++END+LOOP;
+++runstats_pkg.stop2;

+++dbms_output.put_line(s);

+++runstats_pkg.show;
END;|code-block|syntax|javascript|556028|Results(Oracle+XE)：|style|BOLD|556029|Run1+latches+total+versus+runs+--+difference+and+pct
++++++++Run1++++++++Run2++++++++Diff+++++++Pct
+++++++2,491+++++++2,439+++++++++-52++++102.13%25

Run1+ran+in+2304+hsecs
Run2+ran+in+2364+hsecs
run+1+ran+in+97.46%25+of+the+time|556030|Results(Oracle+11g+R1，不同的计算机)：|556031|Run1+latches+total+versus+runs+--+difference+and+pct
++++++++Run1++++++++Run2++++++++Diff+++++++Pct
+++++++2,990+++++++3,056++++++++++66+++++97.84%25

Run1+ran+in+2071+hsecs
Run2+ran+in+2069+hsecs
run+1+ran+in+100.1%25+of+the+time|556032|所以，就是这样。真的没有多大区别。想要更复杂、也涉及SQL+DML的数据吗？你得自己测试一下。|556033|entityMap|0|LINK|mutability|MUTABLE|url|http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7452431376537|1|http://appsdba.com/sql/runstats.sql^0|0|0|0|0|0|0|0|0|0|0|3|29|0|0|0|U|S|1|0|0|0|7|0|0|0|7|0|0|0^^$0|@$1|2|3|4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1Q|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1S|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1V|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1W|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1Y|8|@]|9|@$S|1Z|T|20|1|21]]|A|$]]|$1|U|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|23|8|@]|9|@$S|24|T|25|1|26]]|A|$]]|$1|X|3|Y|5|Z|7|27|8|@]|9|@]|A|$10|11]]|$1|12|3|13|5|6|7|28|8|@$S|29|T|2A|14|15]]|9|@]|A|$]]|$1|16|3|17|5|Z|7|2B|8|@]|9|@]|A|$10|11]]|$1|18|3|19|5|6|7|2C|8|@$S|2D|T|2E|14|15]]|9|@]|A|$]]|$1|1A|3|1B|5|Z|7|2F|8|@]|9|@]|A|$10|11]]|$1|1C|3|1D|5|6|7|2G|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|2H|8|@]|9|@]|A|$]]]|1F|$1G|$5|1H|1I|1J|A|$1K|1L]]|1M|$5|1H|1I|1J|A|$1K|1N]]]]

Tom <a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7452431376537" rel="noreferrer">says</a>:

<blockquote>
 Always use a package. 
 Never use a standalone procedure
 except for demos, tests and standalone
 utilities (that call nothing and are
 called by nothing)
</blockquote>

There you can also find a very good discussion about their performance. Just search for "performance" on that page. 
If still seriously in doubt, you can always test yourself which one is faster. You'll certainly learn something new by doing so.

My take on your question: while it's true that calling package procedures/functions seems to be slower in certain situations than calling standalone procedures/functions, the advantages offered by the additional features available when using packages far outweigh the performance loss. So, just like Tom puts it, use packages.

<hr>

The link: <a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7452431376537" rel="noreferrer">http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7452431376537</a>

<hr>

Test code(20 million calls, runstats_pkg is a package I wrote based on the <a href="http://appsdba.com/sql/runstats.sql" rel="noreferrer">runstats package by Tom Kyte</a>):

<pre><code>CREATE OR REPLACE PACKAGE testperf AS
 FUNCTION pow(i INT) RETURN INT;
END;
/

CREATE OR REPLACE PACKAGE BODY testperf AS
 FUNCTION pow(i int) RETURN INT AS
 BEGIN
 RETURN i * i;
 END;
END;
/

CREATE OR REPLACE FUNCTION powperf(i INT) RETURN INT AS
BEGIN
 RETURN i * i;
END;
/

DECLARE
 I INT;
 S INT DEFAULT 0;
BEGIN
 runstats_pkg.start1;
 FOR I IN 1 .. 20000000 LOOP
 s := s + (powperf(i) / i);
 END LOOP;
 runstats_pkg.stop1;

 dbms_output.put_line(s);
 s := 0;

 runstats_pkg.start2;
 FOR I IN 1 .. 20000000 LOOP
 s := s + (testperf.pow(i) / i);
 END LOOP;
 runstats_pkg.stop2;

 dbms_output.put_line(s);

 runstats_pkg.show;
END;
</code></pre>

Results(Oracle XE):

<pre><code>Run1 latches total versus runs -- difference and pct
 Run1 Run2 Diff Pct
 2,491 2,439 -52 102.13%

Run1 ran in 2304 hsecs
Run2 ran in 2364 hsecs
run 1 ran in 97.46% of the time
</code></pre>

Results(Oracle 11g R1, different machine):

<pre><code>Run1 latches total versus runs -- difference and pct
 Run1 Run2 Diff Pct
 2,990 3,056 66 97.84%

Run1 ran in 2071 hsecs
Run2 ran in 2069 hsecs
run 1 ran in 100.1% of the time
</code></pre>

So, there you go. Really not much of a difference.
Want data for something more complex that also involves SQL DML? You gotta test it yourself.

blocks|key|579089|text|使用包的主要原因是它们破坏了依赖链。例如，如果您有两个独立的过程，过程A调用过程B，而您重新编译过程B，则还需要重新编译过程A。随着过程和函数数量的增加，这将变得相当复杂。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|579090|如果你把它们移到两个不同的包中，只要规范没有改变，你就不需要重新编译它们。|579091|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The primary reason to use packages is they break the dependency chain. For instance if you have two stand-alone procedures, procedure A which calls procedure B and you recompile procedure B you will also need to recompile procedure A. This gets quite complicated as you increase the number of procedures and functions.

If you move these to two to different packages you will not need to recompile them as long as the specification does not change.

blocks|key|1858677|text|这里的其他答案都很好(例如包有状态，它们将接口从实现中分离出来，等等)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1858678|另一个不同之处是，当过程或包被包装时-解开过程很简单，但不是包体。|1858679|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The other answers here are all good (e.g. packages have state, they separate interface from implementation, etc).

Another difference is when procedures or packages are wrapped - it is simple to unwrap a procedure, but not a package body.

What is the difference of performance between standalone procedure and packaged procedure? Which will be good performance wise and why? Is there any difference in execution of both?

Performance Standalone Procedure vs Packaged Procedure in Oracle

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

独立过程和打包过程之间的性能差异是什么？哪一种性能更好?为什么？两者的执行有什么不同吗？

问Oracle中性能独立过程与打包过程的比较
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle中性能独立过程与打包过程的比较EN