Health Check & Recommended Settings for DWH database
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.
0