Re: OEM repository redo generation
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Tue, 11 Nov 2014 15:03:54 -0600 (CST)
Message-ID: <335a13b7ef0dbe8ea984cea8c345d82a.squirrel_at_society.servebeer.com>
Jeremy posted:
Date: Tue, 11 Nov 2014 15:03:54 -0600 (CST)
Message-ID: <335a13b7ef0dbe8ea984cea8c345d82a.squirrel_at_society.servebeer.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 11 2014 - 22:03:54 CET