Oracle DB Management Notes

Notations:
(M): Menu
(A): Area

Check and kill the blocking sessions:
(M)Performance > (A)Additional Monitoring Links > Blocking Sessions


Grant execute and create privilege to procedures:
As dba, issue:
> grant create any procedure to [user];
> grant execute any procedure to  [user];


SQL 及 PL/SQL 命名慣例:
Naming and Coding Standards for SQL and PL/SQL


PL/SQL developer 的 plsqldoc plug-in 的 document tag.
Source: PL/SQL Developer plsqldoc Plug-In 1.2 User’s Guide, AllRoundAutomations Inc.