Database Administration
When you get, give. When you Know, Share. When we Give and Share, we get and acquire more.
Monday, 8 October 2012
Archive log generation per day In GB
select trunc(completion_time), sum(blocks*block_size)/1073741824 Gb
from gv$archived_log
group by trunc(completion_time);
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment