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博客 ” ，链接：https://blog.itpub.net/412/viewspace-912303/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
