From Oracle 10g, Oracle has introduce many advisors to assist DBA maintenance work.
From the DBA_ADVISOR_DEFINITIONS table, we can get some of the advisors.
SELECT * FROM dba_advisor_definitions;
We can categorize the advisors as below:
SQL Tuning:
- SQL Tuning Advisor ( STA): DBMS_SQLTUNE
- SQL Access Advisor ( SAA)
- SQL Performance Analyzer ( SPA): DBMS_SQLPA
- Tune MView : http://www.dba-oracle.com/tips_rittman_dbazine_mtune.htm
Space Advisor:
- Undo Advisor
- Segment Advisor
- Compression advisor
Memory Advisor:
- Shared Pool Advisor: V$SHARED_POOL_ADVICE
- Buffer Cache Advisor: V$DB_CACHE_ADVICE.
- PGA Advisor: V$PGA_TARGET_ADVICE
- Total SGA Size Advisor: When enable ASMM. V$SGA_TARGET_ADVICE
- Total Memory size Advisor: When enable the AMM. V$MEMORY_TARGET_ADVICE
High Availability advisor
- Data Recovery Advisor
- Mean Time to recovery advisor : FAST_START_MTTR_TARGET
- Maximum Availability architecture advisor (MAA)
Related table
- DBA_ADVISOR_TASKS: Basic information for tasks
- DBA_ADVISOR_LOG: Status for tasks.
- DBA_ADVISOR_FINDINGS:Findings identified by tasks
- DBA_ADVISOR_RECOMMENDATIONS:Recommendations for tasks
There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.
ReplyDeleteOracle Course in Chennai
Oracle Training in Chennai
Oracle Training
I am following your blog from the beginning, it was so distinct & I had a chance to collect conglomeration of information that helps me a lot to improvise myself. I hope this will help many readers who are in need of this vital piece of information. Thanks for sharing & keep your blog updated.
ReplyDeleteRegards,
CCNA Training in Chennai | CCNA Training institute in Chennai | CCNA Training
That is a excellent striking write-up. I'm basically pleased with your current excellent operate. People placed genuinely great facts. Continue. Maintain writing a blog. Seeking to reading the following write-up.seo packages prices
ReplyDelete