Database DataWarehousing (MOSC)

MOSC Banner

Is it good to have around 300 log swithes every day in DW environment ?

edited May 24, 2010 3:31AM in Database DataWarehousing (MOSC) 4 commentsAnswered
 Hi,
I have following situation in my DW environment :

MONTH     ARCH_DATE                        SWITCHES     DAILY_AVG_GB
--------- -----------------------                           ----------            ------------
May       Saturday  :    08-May-2010        298                 447
May       Sunday    :    09-May-2010        185                 277
May       Monday    :   10-May-2010        481                  721
May       Tuesday   :   11-May-2010        479                  718
May       Wednesday :12-May-2010        474                  711
May       Thursday  :   13-May-2010        548                  821
May       Friday    :     14-May-2010        327                  490
May       Saturday  :   15-May-2010        204                  306
May       Sunday    :   16-May-2010        236                  354
May       Monday    :   17-May-2010        394                  591
May       Tuesday   :   18-May-2010        350                  525
May       Wednesday :19-May-2010        324                  486
May       Thursday  :   20-May-2010        372                  558


Facts :
1. we have mostly ETL powercenter jobs running whole day.
2. Size of our database is 10 TB
3. We do not have update/delete statements mostly INSERT statements happening in system.
4. size of log file is 1.5 GB and we have 12 files.

Question : Does 500GB redo( or 300 switches)  every day in the DW system like us, is more or normal or extreme ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center