Oracle:tuning
-
编辑 删除
SQL Tuning
select sql_text from v$sqltext a where a.hash_value = (select sql_hash_value from v$session b where b.sid='&sid') order by piece ascSQL> set autotrace trace explainSQL> select index_name,column_name from user_ind_columns where table_name ='my_tables';SQL> alter session set sql_trace=true;SQL> exec dbms_system.set_sql_trace_in_session(7,284,true)[@more@]
