SELECT TRUNC (completion_time),
TRUNC(SUM (blocks * block_size) / 1024 / 1024 / 1024)||'G'
FROM gv$archived_log
GROUP BY TRUNC (completion_time);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764973/viewspace-1173615/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764973/viewspace-1173615/