| Archive log summary [message #281919] |
Tue, 20 November 2007 00:45  |
pooja_g
Messages: 56
Registered: December 2005
Location: India
|
Member |
|
|
Hi,
I need to write a sql which gives sum of total size of archives generated per day.It needs to be in the below format
date size
------ ------
11.10. thursday 607
|
|
|
|
|
|
| Re: Archive log summary [message #281927 is a reply to message #281919] |
Tue, 20 November 2007 01:08  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
SELECT A.*,
Round(A.Count#*B.AVG#/1024/1024) Daily_Avg_Mb
FROM
(
SELECT
To_Char(First_Time,’YYYY-MM-DD’) DAY,
Count(1) Count#,
Min(RECID) Min#,
Max(RECID) Max#
FROM
v$log_history
GROUP
BY To_Char(First_Time,’YYYY-MM-DD’)
ORDER
BY 1 DESC
) A,
(
SELECT
Avg(BYTES) AVG#,
Count(1) Count#,
Max(BYTES) Max_Bytes,
Min(BYTES) Min_Bytes
FROM
v$log
) B;
http://kubilaykara.wordpress.com/2007/09/05/redo-log-generation/
|
|
|
|
|
|
|
|
|
|
| Re: Archive log summary [message #281954 is a reply to message #281940] |
Tue, 20 November 2007 03:01 |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Yes, he wants to know that and you can't give him from Oracle data as you don't know archived log size.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
