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
OEM Cloud Control
Advisor Central
Memory advisor
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
ReplyDeleteI’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... Gestoria en madrid
ReplyDeleteAn online business isn't for everyone. It takes hard work and dedication to make a success of it. But the benefits far outweigh the drawbacks. Working from anywhere with a laptop and never having to work for anyone else again are two of my most compelling reasons to keep working hard at my home based business. theloanrepublic has long term loans
ReplyDeleteI agree with most of your points, but a few need to be discussed further, I will hold a small talk with my partners and maybe I will look for you some suggestion soon. navigate to these guys
ReplyDeleteI'm truly enjoying the design and layout of your site. It's a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme? Superb work! FaceTune Free Download
ReplyDeleteInformative Site… Hello guys here are some links that contains information that you may find useful yourselves. It’s Worth Checking out…. instagram likes free
ReplyDeleteGreat job, I was doing a google search and your site came up for homes for sale in Altamonte Springs, FL but anyway, I have enjoyed reading it, keep it up! kinemaster download
ReplyDeleteThis is a excellent blog, would you be involved in doing an interview about just how you designed it? If so e-mail me! cotomovies download
ReplyDeleteNice post. I learn something more challenging on distinct blogs everyday. It will always be stimulating to read content off their writers and practice a little something from their store. I’d choose to use some with all the content in my small weblog whether you do not mind. Natually I’ll provide a link on your own internet weblog. Many thanks sharing. Dead Target unlimited gold
ReplyDeleteGlad to be one of the visitors on this awe inspiring web site : D. Patreon Hack
ReplyDeleteCheap Gucci Handbags Is usually blogengine much better than wp for reasons unknown? Should be which is turning out to be popluar today. how to get Tweakbox for free
ReplyDeleteThank you for your very good information and feedback from you. san jose used car valentines day gifts
ReplyDeleteThis is a excellent blog, would you be involved in doing an interview about just how you designed it? If so e-mail me! youtube++
ReplyDeleteFashion Courses Online… [...]here are some links to sites that we link to because we think they are worth visiting[...]… how to get videostar++
ReplyDeleteHello Guru, what entice you to post an article. This article was extremely interesting, especially since I was searching for thoughts on this subject last Thursday. btd battles mod
ReplyDeleteAbsolutely pent subject matter, appreciate it for selective information . mkx souls glitch
ReplyDeleteI think that may be an enchanting aspect, it made me assume a bit. Thank you for sparking my considering cap. Now and again I get such a lot in a rut that I just feel like a record. putlocker
ReplyDeleteRight here is the perfect site for anyone who hopes to understand this topic. You understand so much its almost hard to argue with you (not that I actually will need to…HaHa). You definitely put a new spin on a subject which has been discussed for many years. Wonderful stuff, just excellent!
ReplyDeleteClick here to get More information.
This is the appropriate blog for anyone who wants to learn about this topic. You are aware of so much its virtually not easy to argue together with you (not that When i would want…HaHa). You actually put a brand new spin on a topic thats been discussing for some time. Wonderful stuff, just wonderful! hd movie online
ReplyDeleteWhen a blind man bears the standard pity those who follow…. Where ignorance is bliss ‘tis folly to be wise…. Plague Inc. free download
ReplyDeletecheers for the actual article i have recently been on the lookout with regard to this kind of advice on the net for sum time right now so many thanks free apple music
ReplyDeleteYou should be a part of a contest for one of the greatest sites online press. I most certainly will recommend this website!
ReplyDelete