Thursday, February 21, 2013

65 Oracle Database Advisor overview

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;

image

We can categorize the advisors as below:

SQL Tuning:

Space Advisor:

Memory Advisor:

High Availability advisor

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

image

Memory advisor

image

65 comments:

  1. 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.

    Oracle Course in Chennai
    Oracle Training in Chennai
    Oracle Training

    ReplyDelete
    Replies
    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. 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.
    Regards,
    CCNA Training in Chennai | CCNA Training institute in Chennai | CCNA Training

    ReplyDelete
  3. 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
  4. I’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

    ReplyDelete
  5. An 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

    ReplyDelete
  6. I 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

    ReplyDelete
  7. I'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

    ReplyDelete
  8. Informative Site… Hello guys here are some links that contains information that you may find useful yourselves. It’s Worth Checking out…. instagram likes free

    ReplyDelete
  9. Great 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

    ReplyDelete
  10. This 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

    ReplyDelete
  11. Nice 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

    ReplyDelete
  12. Glad to be one of the visitors on this awe inspiring web site : D. Patreon Hack

    ReplyDelete
  13. Cheap 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

    ReplyDelete
  14. Thank you for your very good information and feedback from you. san jose used car valentines day gifts

    ReplyDelete
  15. This is a excellent blog, would you be involved in doing an interview about just how you designed it? If so e-mail me! youtube++

    ReplyDelete
  16. Fashion Courses Online… [...]here are some links to sites that we link to because we think they are worth visiting[...]… how to get videostar++

    ReplyDelete
  17. Hello 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

    ReplyDelete
  18. Absolutely pent subject matter, appreciate it for selective information . mkx souls glitch

    ReplyDelete
  19. I 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

    ReplyDelete
  20. Right 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!
    Click here to get More information.

    ReplyDelete
  21. 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

    ReplyDelete
  22. When a blind man bears the standard pity those who follow…. Where ignorance is bliss ‘tis folly to be wise…. Plague Inc. free download

    ReplyDelete
  23. cheers 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

    ReplyDelete
  24. You should be a part of a contest for one of the greatest sites online press. I most certainly will recommend this website!

    ReplyDelete
  25. First, let’s kill off a genuine fabrication: You can not use a reverse cellular phone number lookup for totally free anywhere, anytime. YouTube++ ios download

    ReplyDelete
  26. Blogs ou should be reading… [...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]…… pokemon go hack

    ReplyDelete
  27. This is a excellent blog, would you be involved in doing an interview about just how you designed it? If so e-mail me! coin hack hack

    ReplyDelete
  28. I simply present your website a couple weeks ago and that i tend to be learning the idea daily. You’ve substantial amount of tips next and i also relish your thing about the homepage insanely. Cultivate acknowledge that there are energy! free Netflix account

    ReplyDelete
  29. I wouldn’t normally be so intrigued by content on this topic but the way you wrote this really grabbed my attention. It is very well thought out and interesting informative content. Thank you for sharing! download tutuapp

    ReplyDelete
  30. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also.

    Data Science Course

    ReplyDelete
  31. It is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it!

    Data Science Training

    ReplyDelete
  32. Nice post thanks for share article. Frases

    ReplyDelete
  33. Awesome, I’m really thank you for this amazing blog. Visit Ogen Infosystem for creative website designing and development services in Delhi, India.
    Website Designing Company

    ReplyDelete
  34. It is really amazing blog, Thanks for sharing.
    pincode of bawana

    ReplyDelete
  35. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Security Guard License
    Ontario Security License
    Security License Ontario
    Security License

    Thank you..

    ReplyDelete
  36. Software IT Training Institute in Chennai for Java, DevOps, PHP, .NET, Oracle, RPA, Python, Testing, Hadoop, Informatica courses with placement ..
    btreesystems

    ReplyDelete
  37. I like the information. Good work and keep update more.
    Read more ProWeb365

    ReplyDelete
  38. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environment react training in vijayawada. ,

    ReplyDelete
  39. SAP stands for Systems Applications and Products in Data Processing. SAP, by definition, is also the name of the ERP (Enterprise Resource Planning) software as well as the name of the company.
    tally training in chennai

    hadoop training in chennai

    sap training in chennai

    oracle training in chennai

    angular js training in chennai

    ReplyDelete
  40. There are very good comments, thank you very much for the http://java37.com/

    ReplyDelete
  41. iot training in chennai - IoT Training in Chennai - IoT is one of the technologies which has a lot of scope at the very same time very less number of skilled employees in this technology which means this particular technology will give a huge success rate. Join the Best IOT Training Institute in Chennai now.

    Devops training Institute in Chennai - DevOps a combination of Development and operations has an better career .Jobs opportunities are there from startup companies to big mnc. Start to learn DevOps technology soon and secure your job now.

    blue prism training in Chennai - If you choose to learn the blue prism or automation tool you are supposed to have the programming language. start to learn the blue prism training from the Best Blue prism Training Institute in Chennai.

    uipath training in Chennai - UI path technology is one of the fastest developing fields which has a lot of job opportunities such as software developer, Programmer and lot more. Join the Best Uipath Training Institute in Chennai.

    microsoft azure training in chennai -Microsoft azure technology is growing and soon it will be competitive aws. So students who start to learn Microsoft azure now will be well - paid in the future. Start to learn Microsoft azure training in Chennai.

    Chennai IT Training Center

    ReplyDelete
  42. Remarkable post. I simply came across your blog and desired to say that I have really enjoyed searching your blog posts. Thank you for sharing such blogs. oracle apps cloud training

    ReplyDelete
  43. This, we could become familiar with ourselves, our association and the climate we work in - including the media - and if adequately keen, the exercises learned will be a significant instrument in rolling out a positive improvement in our organization, foundation and business viewpoint. Disability insurance broker

    ReplyDelete
  44. Chennai IT Training Center
    Artificial Intelligence training in chennai - Basically AI Artificial Intelligence is a programming which is created for robots to think and work on there own without the help of humans.

    RPA Training Institute in Chennai - RPA is useful in making complex decision by collaborating with Artificial Intelligence. And it will also contribute to the market of Big data and IOT. Join the Best RPA Training Institute in Chennai now.

    Load runner training in Chennai - Load runner is an software testin tool. It is basically used to test application measuring system behaviour and performance under load. Here comes an Opportunity to learn Load Runner under the guidance of Best Load Runner Training Institute in Chennai.

    apache Spark training in Chennai - Apache Spark is an open- source, Split Processing System commonly used for big data workloads. Learn this wonderful technology from and under the guidance of Best Apache spark Training Institute in Chennai.

    mongodb training in chennai - MongoDB is a cross platform document - oriented database Program. It is also classified as NO sql database Program. Join the Best Mongo DB Training Institute in Chennai now.

    ReplyDelete
  45. Do you absolutely like watching good movies? Well, most of us do! But what you probably don't know is how Internet can be an effective tool for getting and watching your favourite movies. ดูอนิเมะออนไลน์

    ReplyDelete
  46. This comment has been removed by the author.

    ReplyDelete
  47. This is an awesome motivating article. I am practically satisfied with your great work. You put truly extremely supportive data. Keep it up. Continue blogging. Hoping to pursue your next post

    Best Data Science courses in Hyderabad

    ReplyDelete
  48. Wow, happy to see this awesome post. I hope this think help any newbie for their awesome work and by the way thanks for share this awesomeness, i thought this was a pretty interesting read when it comes to this topic. Thank you...

    DevOps Training in Hyderabad

    ReplyDelete
  49. Excellent information Providing by your Article, thank you for taking the time to share with us such a nice article. Amazing insight you have on this, it's nice to find a website that details so much information about different artists...

    DevOps Training in Hyderabad

    ReplyDelete
  50. Thanks for writing in with such positive feedback about my post. I took a quick glance at it and couldn’t stop reading!
    Data Science Training in Hyderabad
    Data Science Course in Hyderabad

    ReplyDelete
  51. Glad to chat with you as well. This is not my first time commenting here but it's always nice to stop by this blog and see what's new. I have been following your blog for quite some time and I am glad to say that I do appreciate a lot of the articles you publish on here.
    AWS Training in Hyderabad
    AWS Course in Hyderabad

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates