archived logs
From: Joseph David Paparo <jpaparo_at_uark.edu>
Date: Tue, 16 Apr 2013 13:38:53 +0000
Message-ID: <5AB9968CF54E564E92EBD0C3F4FACCEA3F81B1FE_at_ex-mbx1b.uark.edu>
Hello,
I am trying to find the total size of our accumulated backup archived logs. Does anyone have any idea how I can get this information? I found this query on an oracle forum but I wanted to see anyone else has any other information.
Date: Tue, 16 Apr 2013 13:38:53 +0000
Message-ID: <5AB9968CF54E564E92EBD0C3F4FACCEA3F81B1FE_at_ex-mbx1b.uark.edu>
Hello,
I am trying to find the total size of our accumulated backup archived logs. Does anyone have any idea how I can get this information? I found this query on an oracle forum but I wanted to see anyone else has any other information.
select round(sum(blocks*block_size)/1024/1024/1024) arc_size, trunc(first_time) arc_date from v$archived_log where dest_id=1 group by trunc(first_time) order by 2 desc;
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 16 2013 - 15:38:53 CEST