• 全部
  • 经验案例
  • 典型配置
  • 技术公告
  • FAQ
  • 漏洞说明
  • 全部
  • 全部
  • 大数据引擎
  • 知了引擎
产品线
搜索
取消
案例类型
发布者
是否解决
是否官方
时间
搜索引擎
匹配模式
高级搜索

为什么plsql直接执行很快,调试的话很慢?

2025-05-07提问
  • 0关注
  • 0收藏,5618浏览
粉丝:0人 关注:0人

问题描述:

为什么plsql直接执行很快,调试的话很慢

 

对同一个存储过程,直接F8几秒钟就执行完了,但是F9单步调试执行到execute immediate v_sql就很慢很慢,这是什么原因?

 

组网及组网描述:

weibo.com/ttarticle/p/show?id=2309405163607100096699

weibo.com/ttarticle/p/show?id=2309405163607104291006

weibo.com/ttarticle/p/show?id=2309405163607104028825

weibo.com/ttarticle/p/show?id=2309405163607108485302

weibo.com/ttarticle/p/show?id=2309405163607112417327

weibo.com/ttarticle/p/show?id=2309405163607125000305

weibo.com/ttarticle/p/show?id=2309405163607175594115

weibo.com/ttarticle/p/show?id=2309405163607229858001

weibo.com/ttarticle/p/show?id=2309405163607229858068

weibo.com/ttarticle/p/show?id=2309405163607229858110

weibo.com/ttarticle/p/show?id=2309405163607230120189

weibo.com/ttarticle/p/show?id=2309405163607234314530

weibo.com/ttarticle/p/show?id=2309405163607238508567

weibo.com/ttarticle/p/show?id=2309405163607246635300

weibo.com/ttarticle/p/show?id=2309405163607259480070

weibo.com/ttarticle/p/show?id=2309405163607280189511

weibo.com/ttarticle/p/show?id=2309405163607288578302

weibo.com/ttarticle/p/show?id=2309405163607326327120

weibo.com/ttarticle/p/show?id=2309405163607326589233

weibo.com/ttarticle/p/show?id=2309405163607330783368

weibo.com/ttarticle/p/show?id=2309405163607334715688

weibo.com/ttarticle/p/show?id=2309405163607334977773

weibo.com/ttarticle/p/show?id=2309405163607343104201

weibo.com/ttarticle/p/show?id=2309405163607347298319

weibo.com/ttarticle/p/show?id=2309405163607351492699

weibo.com/ttarticle/p/show?id=2309405163607376920746

weibo.com/ttarticle/p/show?id=2309405163607376920801

weibo.com/ttarticle/p/show?id=2309405163607385309205

weibo.com/ttarticle/p/show?id=2309405163607406018680

weibo.com/ttarticle/p/show?id=2309405163607422795927

weibo.com/ttarticle/p/show?id=2309405163607423058126

weibo.com/ttarticle/p/show?id=2309405163607423058198

weibo.com/ttarticle/p/show?id=2309405163607435641003

weibo.com/ttarticle/p/show?id=2309405163607443767303

weibo.com/ttarticle/p/show?id=2309405163607444029529

weibo.com/ttarticle/p/show?id=2309405163607443767428

weibo.com/ttarticle/p/show?id=2309405163607448223788

weibo.com/ttarticle/p/show?id=2309405163607473389664

weibo.com/ttarticle/p/show?id=2309405163607473127576

weibo.com/ttarticle/p/show?id=2309405163607481516042

weibo.com/ttarticle/p/show?id=2309405163607485710406

weibo.com/ttarticle/p/show?id=2309405163607485710485

weibo.com/ttarticle/p/show?id=2309405163607489904914

weibo.com/ttarticle/p/show?id=2309405163607494099017

weibo.com/ttarticle/p/show?id=2309405163607506944056

weibo.com/ttarticle/p/show?id=2309405163607519526932

weibo.com/ttarticle/p/show?id=2309405163607519264842

weibo.com/ttarticle/p/show?id=2309405163607519527046

weibo.com/ttarticle/p/show?id=2309405163607531847758

weibo.com/ttarticle/p/show?id=2309405163607540236374

weibo.com/ttarticle/p/show?id=2309405163607540236413

weibo.com/ttarticle/p/show?id=2309405163607540236441

weibo.com/ttarticle/p/show?id=2309405163607544430844

weibo.com/ttarticle/p/show?id=2309405163607569858690

weibo.com/ttarticle/p/show?id=2309405163607573790805

weibo.com/ttarticle/p/show?id=2309405163607582441491

weibo.com/ttarticle/p/show?id=2309405163607582179372

weibo.com/ttarticle/p/show?id=2309405163607586635900

weibo.com/ttarticle/p/show?id=2309405163607586374010

weibo.com/ttarticle/p/show?id=2309405163607603413076

weibo.com/ttarticle/p/show?id=2309405163607603151042

weibo.com/ttarticle/p/show?id=2309405163607615995994

weibo.com/ttarticle/p/show?id=2309405163607615733999

weibo.com/ttarticle/p/show?id=2309405163607615733792

weibo.com/ttarticle/p/show?id=2309405163607636967426

weibo.com/ttarticle/p/show?id=2309405163607636967556

weibo.com/ttarticle/p/show?id=2309405163607641161737

weibo.com/ttarticle/p/show?id=2309405163607640899683

weibo.com/ttarticle/p/show?id=2309405163607640899848

weibo.com/ttarticle/p/show?id=2309405163607666327700

weibo.com/ttarticle/p/show?id=2309405163607678910574

weibo.com/ttarticle/p/show?id=2309405163607682842768

weibo.com/ttarticle/p/show?id=2309405163607683104982

weibo.com/ttarticle/p/show?id=2309405163607687036951

weibo.com/ttarticle/p/show?id=2309405163607699619959

weibo.com/ttarticle/p/show?id=2309405163607703814198

weibo.com/ttarticle/p/show?id=2309405163607712464915

weibo.com/ttarticle/p/show?id=2309405163607720591367

weibo.com/ttarticle/p/show?id=2309405163607720591584

weibo.com/ttarticle/p/show?id=2309405163607720591439

weibo.com/ttarticle/p/show?id=2309405163607733174328

weibo.com/ttarticle/p/show?id=2309405163607733174319

weibo.com/ttarticle/p/show?id=2309405163607737368676

weibo.com/ttarticle/p/show?id=2309405163607737368667

weibo.com/ttarticle/p/show?id=2309405163607745757257

weibo.com/ttarticle/p/show?id=2309405163607762534588

weibo.com/ttarticle/p/show?id=2309405163607771185363

weibo.com/ttarticle/p/show?id=2309405163607779311619

weibo.com/ttarticle/p/show?id=2309405163607775117473

weibo.com/ttarticle/p/show?id=2309405163607779311717

weibo.com/ttarticle/p/show?id=2309405163607783768094

weibo.com/ttarticle/p/show?id=2309405163607800283182

weibo.com/ttarticle/p/show?id=2309405163607812866141

weibo.com/ttarticle/p/show?id=2309405163607813128464

weibo.com/ttarticle/p/show?id=2309405163607817322698

weibo.com/ttarticle/p/show?id=2309405163607821254778

weibo.com/ttarticle/p/show?id=2309405163607833837715

weibo.com/ttarticle/p/show?id=2309405163607833837743

weibo.com/ttarticle/p/show?id=2309405163607846420575

weibo.com/ttarticle/p/show?id=2309405163607863460005

weibo.com/ttarticle/p/show?id=2309405163607867654209

weibo.com/ttarticle/p/show?id=2309405163607871586390

weibo.com/ttarticle/p/show?id=2309405163607876042813

weibo.com/ttarticle/p/show?id=2309405163607876042940

weibo.com/ttarticle/p/show?id=2309405163607876042968

weibo.com/ttarticle/p/show?id=2309405163607876042982

weibo.com/ttarticle/p/show?id=2309405163607896752316

weibo.com/ttarticle/p/show?id=2309405163607909335224

weibo.com/ttarticle/p/show?id=2309405163607917723710

weibo.com/ttarticle/p/show?id=2309405163607930568878

weibo.com/ttarticle/p/show?id=2309405163607930568877

weibo.com/ttarticle/p/show?id=2309405163607938957384

weibo.com/ttarticle/p/show?id=2309405163607947083865

weibo.com/ttarticle/p/show?id=2309405163607959666791

weibo.com/ttarticle/p/show?id=2309405163607968055396

weibo.com/ttarticle/p/show?id=2309405163607968055534

weibo.com/ttarticle/p/show?id=2309405163607972511810

weibo.com/ttarticle/p/show?id=2309405163607972511891

weibo.com/ttarticle/p/show?id=2309405163607972511955

weibo.com/ttarticle/p/show?id=2309405163607985094852

weibo.com/ttarticle/p/show?id=2309405163607989026890

weibo.com/ttarticle/p/show?id=2309405163608001609733

weibo.com/ttarticle/p/show?id=2309405163608022843500

weibo.com/ttarticle/p/show?id=2309405163608048009361

weibo.com/ttarticle/p/show?id=2309405163608064786744

weibo.com/ttarticle/p/show?id=2309405163608110923868

weibo.com/ttarticle/p/show?id=2309405163608127701013

weibo.com/ttarticle/p/show?id=2309405163608160993449

weibo.com/ttarticle/p/show?id=2309405163608165187593

weibo.com/ttarticle/p/show?id=2309405163608215781400

weibo.com/ttarticle/p/show?id=2309405163608249073844

weibo.com/ttarticle/p/show?id=2309405163608257724537

weibo.com/ttarticle/p/show?id=2309405163608266113133

weibo.com/ttarticle/p/show?id=2309405163608354193498

weibo.com/ttarticle/p/show?id=2309405163608353931369

weibo.com/ttarticle/p/show?id=2309405163608374902920

weibo.com/ttarticle/p/show?id=2309405163608450662413

weibo.com/ttarticle/p/show?id=2309405163608459051028

weibo.com/ttarticle/p/show?id=2309405163608484217035

weibo.com/ttarticle/p/show?id=2309405163608542675027

weibo.com/ttarticle/p/show?id=2309405163608559714488

weibo.com/ttarticle/p/show?id=2309405163608605589651

weibo.com/ttarticle/p/show?id=2309405163608664309785

weibo.com/ttarticle/p/show?id=2309405163608714641617

weibo.com/ttarticle/p/show?id=2309405163608765235374

weibo.com/ttarticle/p/show?id=2309405163608815567036

weibo.com/ttarticle/p/show?id=2309405163608870092836

weibo.com/ttarticle/p/show?id=2309405163608915968145

weibo.com/ttarticle/p/show?id=2309405163608974950574

2 个回答
zhiliao_m6l9Bf 知了小白
粉丝:0人 关注:0人

对同一个存储过程,直接F8几秒钟就执行完了,但是F9单步调试执行到execute immediate v_sql就很慢很慢

暂无评论

粉丝:0人 关注:0人

调试器占用开销了吧。调试模式需要跟踪每一行代码的执行状态,需要维护调用堆栈和变量监视

暂无评论

编辑答案

你正在编辑答案

如果你要对问题或其他回答进行点评或询问,请使用评论功能。

分享扩散:

提出建议

    +

亲~登录后才可以操作哦!

确定

亲~检测到您登陆的账号未在http://hclhub.h3c.com进行注册

注册后可访问此模块

跳转hclhub

你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作

举报

×

侵犯我的权益 >
对根叔社区有害的内容 >
辱骂、歧视、挑衅等(不友善)

侵犯我的权益

×

泄露了我的隐私 >
侵犯了我企业的权益 >
抄袭了我的内容 >
诽谤我 >
辱骂、歧视、挑衅等(不友善)
骚扰我

泄露了我的隐私

×

您好,当您发现根叔知了上有泄漏您隐私的内容时,您可以向根叔知了进行举报。 请您把以下内容通过邮件发送到pub.zhiliao@h3c.com 邮箱,我们会尽快处理。
  • 1. 您认为哪些内容泄露了您的隐私?(请在邮件中列出您举报的内容、链接地址,并给出简短的说明)
  • 2. 您是谁?(身份证明材料,可以是身份证或护照等证件)

侵犯了我企业的权益

×

您好,当您发现根叔知了上有关于您企业的造谣与诽谤、商业侵权等内容时,您可以向根叔知了进行举报。 请您把以下内容通过邮件发送到 pub.zhiliao@h3c.com 邮箱,我们会在审核后尽快给您答复。
  • 1. 您举报的内容是什么?(请在邮件中列出您举报的内容和链接地址)
  • 2. 您是谁?(身份证明材料,可以是身份证或护照等证件)
  • 3. 是哪家企业?(营业执照,单位登记证明等证件)
  • 4. 您与该企业的关系是?(您是企业法人或被授权人,需提供企业委托授权书)
我们认为知名企业应该坦然接受公众讨论,对于答案中不准确的部分,我们欢迎您以正式或非正式身份在根叔知了上进行澄清。

抄袭了我的内容

×

原文链接或出处

诽谤我

×

您好,当您发现根叔知了上有诽谤您的内容时,您可以向根叔知了进行举报。 请您把以下内容通过邮件发送到pub.zhiliao@h3c.com 邮箱,我们会尽快处理。
  • 1. 您举报的内容以及侵犯了您什么权益?(请在邮件中列出您举报的内容、链接地址,并给出简短的说明)
  • 2. 您是谁?(身份证明材料,可以是身份证或护照等证件)
我们认为知名企业应该坦然接受公众讨论,对于答案中不准确的部分,我们欢迎您以正式或非正式身份在根叔知了上进行澄清。

对根叔社区有害的内容

×

垃圾广告信息
色情、暴力、血腥等违反法律法规的内容
政治敏感
不规范转载 >
辱骂、歧视、挑衅等(不友善)
骚扰我
诱导投票

不规范转载

×

举报说明