Oracle系統環境有改時都要執行

exec dbms_stats.gather_system_stats('noworkload'); select * from sys.aux_stats$; exec dbms_stats.set_system_stats.. 可以設定 11g alter database backup controlfile to trace; -- trace select value from v$diag_info where name='Default Trace File'; -- 查詢 log file的位置 10g select spid from v$process where addr=(select paddr from v$session where sid = (select ...)); show parameter user_dump_dest;