PL/SQL 一编辑数据就卡，why???

eva_1st 2015-10-30 08:37:05

在PL/SQL里直接执行insert,update这些非常快。但是只要是先select ，再for update。去点那个锁准备编辑查询结果的时候就要卡几十秒才能编辑。编辑的时候一切正常，提交也正常。

不管什么表都这样。只要查询，编辑，点锁就卡。
什么情况啊？有高人来指导一下吗？

最近才这样的，以前几年都不这样。

...全文

209 3 打赏收藏转发到动态举报

写回复

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

liuzhe_521 2015-10-30

打赏
举报

回复

用plsql做修改的时候干嘛不用rowid的方式去修改数据呢？你for update的时候锁定了当前的数据，不危险吗？

wu1048745542 2015-10-30

打赏
举报

回复

引用 1 楼 wildwave 的回复:

估计是工具问题，重装 pl/sql developer吧

我感觉不是，我也是这样，感觉和网速有关，我直连数据库就不会卡，vpn就会卡。

小灰狼W 2015-10-30

打赏
举报

回复

估计是工具问题，重装 pl/sql developer吧

This book explains the best way to construct packages, a powerful part of Oracle's PL/SQL procedural language that can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. It comes with PL/Vision software, a library of PL/SQL packages developed by the author, and takes you behind the scenes as it examines how and why the PL/Vision packages were implemented the way they were.

这是英文版，英文很烂的不要下。一般的都能读懂。 This book is separated into six parts as follows: Part I: Working With Packages This part introduces packages, the most important construct in PL/SQL for building reusable code and employing object-oriented design techniques. Chapter 1, PL/SQL Packages describes how and when you should create packages and explains why PL/SQL developers should learn to center their entire development process around packages Chapter 2, Best Practices for Packages presents my tried-and-true "best practices" for building packages. Chapter 3, The PL/SQL Development Spiral puts packages in the context of overall PL/SQL development by providing a tutorial on solving a typical problem in PL/SQL. Part II: PL/Vision Overview Chapter 4, Getting Started with PL/Vision gets you started with PL/Vision, a collection of PL/SQL packages and supporting SQL*Plus scripts that can radically change the way you develop applications with the PL/SQL language. Chapter 5, PL/Vision Package Specifications provides a brief summary of all of the specifications for the PL/Vision packages, and is marked with a thumb-tab for quick reference. Part III: Building Block Packages Chapters 6 through 13 describe the building block packages of PL/Vision; these are low-level packages that you can use to enhance your development -- for example, string parsers, a list manager, and an interface to PL/SQL tables. ············

SQL Developers Guide

Part 1 covers some basics that are required to read the rest of the book. Chapter 1, “Performance Problems,” explains not only why it’s essential to approach performance problems at the right moment and in a methodological way, but also why understanding business needs and problems is essential. It also describes the most common database-related design problems that lead to suboptimal performance. Chapter 2, “Key Concepts,” describes the operations carried out by the database engine when parsing and executing SQL statements and how to instrument application code and database calls. It also introduces some important terms that are frequently used in the book. Part 2 explains how to approach performance problems in an environment that uses Oracle Database. Chapter 3, “Analysis of Reproducible Problems,” describes how to identify performance problems with the help of SQL trace and PL/SQL profilers. Chapter 4, “Real-time Analysis of Irreproducible Problems,” describes how to take advantage of information provided by dynamic performance views. Several tools and techniques that can be used with them are also introduced. Chapter 5, “Postmortem Analysis of Irreproducible Problems,” describes how to analyze performance problems that happened in the past with the help of Automatic Workload Repository and Statspack. Part 3 describes the component that is responsible for turning SQL statements into execution plans: the query optimizer. Chapter 6, “Introducing the Query Optimizer,” provides an overview of what the query optimizer does and how it does it. Chapters 7 and 8, “System Statistics” and “Object Statistics,” describe what system statistics and object statistics are, how to gather them, and why they are important for the query optimizer. Chapter 9, “Configuring the Query Optimizer,” covers a configuration road map that you can use to find a good configuration for the query optimizer. Chapter 10, “Execution Plans,” describes in detail how to obtain, interpret, and judge the efficiency of execution plans.

最新052考试题库，内容充分带答案解析，有需要的同学抓紧下载

基础和管理

17,378

社区成员

95,113

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章