Database DataWarehousing (MOSC)

MOSC Banner

Health Check & Recommended Settings for DWH database

edited Mar 26, 2013 9:39AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi All,
Is there any health check report or sql to find the overall health check of datawarehouse database and find the missing settings and recommended settings 
I know, AWR is  option to find overall performance of database invariably whether it is DSS or OLTP
However, am looking for specific diag report to find basic & important settings required for DSS system and possible recommended settings /parameters to support or better performance on a DSS system.

I see there is Health Check for MVhcdr which shows all MVs and its complete details, however it is NOT clear what is the observation/issues found and possible recommendation.

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