Re: OEM repository redo generation
- From: Wenping Bo <wbo1@xxxxxxxxxxxxxx>
- To: rjoralist3@xxxxxxxxxxxxxxxxxxxxx
- Date: Wed, 12 Nov 2014 10:18:54 -0500 (EST)
For comparison purpose, our 12.1.0.4 EM repository redo generates about
137MB/hr.
- 7 DB instances
- 11 hosts /6 listeners / 11 agents
- 72 targets with status
Thanks Rich for the nice query.
Wenping
----- Original Message -----
From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tuesday, November 11, 2014 4:03:54 PM
Subject: Re: OEM repository redo generation
Jeremy posted:
> Quick question for someone out there with an OEM repository - how many
> targets and hosts do you have, and what's your typical hourly redo
> generation rate on the repository database?
For a smaller scale comparison, my 12.1.0.3 EM does 120MB/hr redo with:
- 18 DB instances
- 5 hosts / 5 listeners / 5 agents
- 86 total targets / 64 targets with status
I used this to determine average redo generation on the EM12c repo DB:
SELECT
(SUM(BLOCKS*BLOCK_SIZE)/1024/1024 / (MAX(NEXT_TIME) - MIN(FIRST_TIME))) / 24
REDO_MB_PER_HOUR
FROM V$ARCHIVED_LOG;
Rich
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
