Step1 Enabling and Disabling Workload Capture
SQL> @$ORACLE_HOME/rdbms/admin/wrrenbl.sql
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL> alter system set PRE_11G_ENABLE_CAPTURE=true sid='*';
System altered.
SQL> @$ORACLE_HOME/rdbms/admin/wrrdsbl.sql
Step2 Restarting the Database
Step3 Capturing a Database Workload Using Enterprise Manager
Step4 Workload Preprocessing & Workload Replay on Oracle Database 11g Release 1 (11.1) and subsequent releases
So,see you ..
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16348200/viewspace-614511/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16348200/viewspace-614511/