查看awr保留日期
Select extract(day from snap_interval) * 24 * 60 +
extract(hour from snap_interval) * 60 +
extract(minute from snap_interval) "Snapshot Interval",
extract(day from retention) * 24 * 60 +
extract(hour from retention) * 60 + extract(minute from retention) "Retention Interval(Minutes) ",
extract(day from retention) "Retention(in Days) "
from dba_hist_wr_control;
extract(hour from snap_interval) * 60 +
extract(minute from snap_interval) "Snapshot Interval",
extract(day from retention) * 24 * 60 +
extract(hour from retention) * 60 + extract(minute from retention) "Retention Interval(Minutes) ",
extract(day from retention) "Retention(in Days) "
from dba_hist_wr_control;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-751806/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
调整Redo log size
下一篇：
SQL追踪和事件追踪
请登录后发表评论
登录
全部评论
