1.AWR OR STATSPACK
2 EXPLAIN TABLE
3 SQL TRACE AND TKPROF
SQL> alter session set SQL_TRACE=true;
Session altered
SQL> select * from t_abs_data_flightinfo where obj_id='1765465';
0 0
SQL> alter session set SQL_TRACE=false;
Session altered
SQL> show parameters dump;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string d:\app\administrator\diag\rdbms\amdb\amdb\trace
core_dump_dest string d:\app\administrator\diag\rdbms\amdb\amdb\cdump
max_dump_file_size string unlimited
shadow_core_dump string none
user_dump_dest string d:\app\administrator\diag\rdbms\amdb\amdb\trace
查看user_dump_dest 路径下得trace文件,
tkprof aaa.trace aaa.txt
查看aaa.txt 文件
4 .AUTOTRACE