select * from SYS.V_$RMAN_STATUS很久不出结果加hint/+rule/解决
SELECT/*+rule*/ OBJECT_TYPE BACKUP_TYPE, ，
(SYSDATE - MAX(END_TIME)) DAYS_SINCE_BACKUP,
MAX(END_TIME) LAST_SUCCESSFUL_BACKUP
FROM SYS.V_$RMAN_STATUS
WHERE STATUS = 'COMPLETED'
AND OPERATION = 'BACKUP'
GROUP BY OBJECT_TYPE;
查询SYS.V_$RMAN_STATUS很慢
最新推荐文章于 2024-07-21 11:20:36 发布
扫一扫
1363
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
