Recently,I saw one of my colleagues operating data in the product database.when he query data he used the statement of "select **** from A for update" in the SQL window of the PL/SQL developer tool.we knowed that the FOR UPDATE would make the table A be locked,therefore this will result in other operations crash for waiting all the time!
As we know,the clause of For UPDATE would bring a row lock for the table,so just cautiously used "FOR UPDATE" especially in the product database.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/38542/viewspace-954024/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
OMA->OMS->OMR
请登录后发表评论
登录
全部评论
-
博文量235
-
访问量1707881
最新文章
- Two errors after cloning eBS
- An error from listener
- How to change the APPS db password in Oracle EBS
- Management on database link
- Three ways to quickly login into EBS 11i
- SMART Goal Setting
- A good template email on how to apply for training program
- 4C
- My understanding of AD configuration
- Taught Oracle database OCP training course
