<< Oracle In Ubuntu | Journals | Dropping Partitions >>
1. Killing a Session
alter system kill session ‘sid,serial#’;
2. Set TRACE for an Explain Plan
set autotrace traceonly explain
3. Estimate Statistics
ANALYZE TABLE|CLUSTER|INDEX [<schema>.]<name>[<method>] STATISTICS [SAMPLE <n>[ROWS|PERCENT]]
4. Whenever you want to exit
whenever sqlerror exit sql.sqlcode rollback whenever oserror exit failure rollback
5. Escape Character _
select table_name from user_tables where table_name like 'MOS\_%' ESCAPE '\';
6. Recompile Package Bodies
alter package <package_name> compile body;
7. Archive Log Start Stop and switching logs
alter system archive log stop; alter system archive log start; alter system switch logfile;