- Integrity constraints are good
- Get In, get out (db is bottleneck, avoid PL/SQL)
- Stay away from EJB
- Watch out for self-joins
- EXISTS can be slower than IN
- ANALYZEd tables can result in a SEGV in RBO
- Wrap Oracle
http://www.bivio.com/freeware/files/presentations/oracle-tidbits/Connection.pm
- strace to find files which Oracle uses
- Turn on SQL*PLUS error checking:
whenever sqlerror exit sql.sqlcode rollback
whenever oserror exit sql.sqlcode rollback
- Turn on autotrace (auto EXPLAIN PLAN)
-- Create PLUSTRACE role
connect internal
@$ORACLE_HOME/sqlplus/admin/plustrce.sql
grant plustrace to USER;
-- Create the explain_plan table
connect USER/PASSWORD
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
SET autotrace ON;
|