Oracle AWR and STATSPACK Manual snapshot commands
There are times when you want to manually collect AWR and STATSPACK snapshots, such as when you are experiencing a performance problem or doing a stress test. You can issue these commands to get a manual AWR or STATSPACK snapshot at whatever elapsed time interval you desire:
AWR manual snapshot:
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;
STATSPACK manual snapshot:
exec statspack.snap;
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/412/viewspace-912303/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/412/viewspace-912303/