OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Max redo size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Max redo size [message #211114]

Tue, 26 December 2006 07:47

hebik
Messages: 1
Registered: December 2006

Junior Member

How can I retrieve the max redo size in MB/sec for a given time period?

Report message to a moderator

Re: Max redo size [message #211924 is a reply to message #211114]

Wed, 03 January 2007 02:19

Frank Naude
Messages: 4580
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

Report message to a moderator

Previous Topic:	error in import
Next Topic:	Hi all is thire any difference between Oracle 10g(windows) and Oracle 10g(Solaris)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:27:45 CDT 2024