Chapter 2 procedural performance tuning of PL/SQL applications
I. Reasons for PL/SQL Performance problems
When the execution efficiency of PL/SQL-based applications is low, it is usually caused by poor SQL statements and programming methods,
http://uule.iteye.com/blog/2061773 (source)Bulk Import Script :Open a Command Window > enter @ > It will let you select the file you want to import (you need to know the order of the imported files, Plsql will not automatically recognize this or
PL/SQL usage tipsEdit/undo Ctrl+zedit/redo shift+ctrl+zedit/pl/sql beautifier ctrl+w (Custom) Shift+home Select the cursor position to the beginning of the line Shift+end select the cursor position To the end of the line Ctrl+shift+home select the
Shortcut:===============================================================================Edit/undo Ctrl + ZEdit/redo shift+ctrl+zEdit/pl/sql beautifier ctrl+w (Custom) shift+home Select the cursor position to the beginning of the line
1. PL/SQL Developer remember login password when using PL/SQL developer, in order to work conveniently hope PL/SQL Developer remember login Oracle user name and password; Setup method: PL/SQL Developer->tools->preferences->oracle->logon history,
From: http://livenzhao.spaces.live.com/blog/cns! 6e0000be9f6ddd872! 595. entry· PL/SQL Developer skills
1. PL/SQL Developer remember the Login Password
When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password
1. My Objects is automatically selected by default after logon.By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after
1, PL/SQL developer remember login passwordWhen using PL/SQL developer, you want PL/SQL developer to remember the username and password to log in to Oracle for your convenience;Setup method: PL/SQL Developer 7.1.2->tools->preferences->oracle->logon,
1. My Objects is automatically selected by default after logon.By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after
1, default automatically check my Objects after loginBy default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you will need to wait a few seconds for the tables directory to expand, and the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.