Oracle diagnostic and tuning tools

alert log file: show parameter dump
ORA-600 internal error,block corruption error
clear alterlog: cat /dev/null >alert*.log
log_checkpoints_to_alert set true
alter session set sql_trace =true;
execute dbms_system.set_sql_trace_in_session(sid,serial#,true)
dbms_stats package
statspack *
v$xxx
dba_xxx
oracle wait events
utlbstat.sql utlestat.sql
$ORACLE_HOME/rdbms/admin/spdoc.txt
system:v$sysstat v$sgastat v$event_name v$system_event
session:v$statname v$sesstat v$session v$session_event v$event_name v$session_wait
db/instance:v$database v$instance v$option v$parameter v$backup v$px_process_sysstat v$process v$waitstat v$system_event
disk:v$datafile v$filestat v$log v$log_history v$dbfile v$tempfile v$tempstat v$segment_statistics
contention:v$lock v$rollname v$rollstat v$waitstat v$latch
memory:v$buffer_pool_statistics v$db_object_cache v$librarycache v$rowcache v$sysstat v$sgastat
user/session:v$lock v$open_cursor v$process v$transaction v$px_sesstat v$px_session v$sesstat v$session_event v$sort_usage v$session_wait v$session v$session_object_cache