Home » RDBMS Server » Server Administration » Max redo size
Max redo size [message #211114] Tue, 26 December 2006 07:47 Go to next message
hebik
Messages: 1
Registered: December 2006
Junior Member
How can I retrieve the max redo size in MB/sec for a given time period?
Re: Max redo size [message #211924 is a reply to message #211114] Wed, 03 January 2007 02:19 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Will something like this do?

SQL> SELECT TO_CHAR(first_time, 'DD-MON-YY HH24:MI:SS') AS "From",
  2         TO_CHAR(next_time,  'DD-MON-YY HH24:MI:SS') AS "To",
  3         blocks*block_size AS "Bytes"
  4    FROM v$archived_log
  5  /

From               To                      Bytes
------------------ ------------------ ----------
22-SEP-06 10:10:25 22-SEP-06 10:34:10   10008576
22-SEP-06 10:34:10 22-SEP-06 10:34:16       6656
22-SEP-06 10:34:16 22-SEP-06 10:35:35   10569216
22-SEP-06 10:35:35 22-SEP-06 10:41:39   50049024
22-SEP-06 10:41:39 22-SEP-06 10:49:50   50049024
22-SEP-06 10:49:50 22-SEP-06 11:00:45    1704448
22-SEP-06 11:00:45 22-SEP-06 11:29:48   17866752
22-SEP-06 11:29:48 22-SEP-06 12:14:06   11990528
22-SEP-06 12:14:06 22-SEP-06 13:18:40   10932224
22-SEP-06 13:18:40 22-SEP-06 13:24:29    5315584
Previous Topic: error in import
Next Topic: Hi all is thire any difference between Oracle 10g(windows) and Oracle 10g(Solaris)
Goto Forum:
  


Current Time: Sat Dec 03 12:25:55 CST 2016

Total time taken to generate the page: 0.07212 seconds