OEM 10gR4 Diagnostic and Tuning Pack Deep Dive

These are my notes from a web training by the product team on Diagnostics and Tuning packs for OEM 10gR4.


new features in 10gR3



  • EBiz Suite

  • PeopleSoft

  • Seibel

  • SOA Management

  • Identity Management

  • Remedy connector

  • MOM connector

  • SAP

  • JBoss

  • IBM WebSphere MQ

new features in 10gR4



  • Data Masking

  • BI

  • Tomcat

  • VMWare

  • PeopleSoft Helpdesk

  • Microsoft Exchange

  • BEA

  • BEZ

  • Blue Lane

  • Check Point

  • Citrix

  • Dell

  • Egenera

  • EMC

  • F5

  • IBM

  • Juniper

  • Microsoft

  • NetApp

  • Nortel

  • Onaro

  • Pillar Data

  • Radware

  • JBoss

IT Challenges


 – Reduct cost of managing IT -> grid automation/OEM


 – assess status -> configuration management


 – transaction from reacting to proactively resolving issues -> app performance management


 – improve alignment between business customers and IT staff -> SLM


Database Diagnostic Pack


features improved each release



  • wait events instrumentation (7.3)

  • statspack (8i)

  • YAPP methodology (8i)

  • enhanced time-wait model (10g)

  • AWR – automatic workload repository (10g)

  • ASH – active session history (10g)

  • ADDM – automatic database diagnostic monitor (10g)

AWR – performance statistics data warehouse. Consists of snapshots of ASH. Everything stored in SYSAUX tablespace.


ADDM – top down analysis using AWR snapshots. optimizes to reduce database time. real time results. pinpoints root cause and eliminates non-problem areas.


OEM 10g works on 9i. The summary database screen does not have any differences in OEM for 9i systems. When we dive down into a specific database and look at the Performance tab, we see similar data but the 9i does not have the ADDM notices. Everything else shows this. Both do show the same wait event issues.


SQL Tuning does show rich information in 9i like expensive full table scans or cartesion joins as well as unnecessary rewrites. This data is not as rich as the SQL Tuning advisor in 10g but it does give information that the DBA can resolve on their own.


Top SQL data is available in 9i throught he STATSPACK to look for duplicate SQL or blocking sessions. The tool in 10g is more informative and integrated with SQL Tuning Advisor.


Database Tuning Pack


Tuning pack does require the diagnostics pack. It does provide features like SQL Tuning Advisor and SQL Access Advisor.


SQL Tuning Advisor looks at statistics, SQL profiles, access path analysis, and SQL structure analysis. It then recommends a new SQL profile, a new index, a recommendation on modifying SQL statements, or gathering more stats.


SQL Profile is additional information based on previous execution of SQL statements. The profile optimizes the execution of the SQL statements. It can be used to schedule I/O or populate the buffer cache properly. It makes this persistent across shutdowns and can be applied to other databases that are running the same code. 10g has a new feature in SQL Tuning Sets that allows for capture of SQL workloads and tuning sets better. It also records creation of a tuning set from a variety of sources; cache, ADDM, etc.


Data masking is a new frature in 10gR4. It allows you to anonymize columns so that you can send copies to off-site developers, third parties, or internal developers. The format and layout stays the same but the contents are masked.


The demo emphasized the main screen pointing out the systems down, security policy issues (critical and warning) as well as alerts (critical and warnings). It does allow you to sort based on a specific type of target. The examples given were IBM and Microsoft applications. If you look at the database tab it allows you to look at the different database types, different versions, and if the systems are up or down. If you pick one database you go to the database home page and see all of the graphs as well as more detailed reports. The performance tab allows you to look at the historical utilization, active sessions, disk I/O, and instance throughput.


This training was relatively good for an introduction. Unfortunately, it did not go as deep as the TDS demos are capable of doing. I personally like to use something like the PetShop demo and show blocked processes, slow querries, and how you can fix these.

1,159 thoughts on “OEM 10gR4 Diagnostic and Tuning Pack Deep Dive”

  1. Thank you for your whole hard work on this blog. Kate takes pleasure in participating in investigations and it’s really easy to see why. A lot of people learn all of the powerful mode you deliver simple techniques on this website and therefore cause response from other individuals on the issue plus our own simple princess is always starting to learn so much. Take advantage of the rest of the year. You are performing a brilliant job.

  2. My husband and i felt now fortunate Emmanuel could finish off his homework from your precious recommendations he acquired out of the site. It’s not at all simplistic just to continually be making a gift of helpful tips which usually some people may have been making money from. And we all understand we now have the writer to appreciate for this. The specific illustrations you made, the simple blog navigation, the relationships you will assist to instill – it’s everything remarkable, and it is making our son and the family imagine that that topic is pleasurable, which is truly indispensable. Thank you for all!

  3. My spouse and i felt so glad John managed to conclude his studies through your ideas he discovered through your web page. It is now and again perplexing just to continually be offering ideas which many people may have been trying to sell. We really understand we need you to appreciate because of that. Those explanations you’ve made, the easy blog navigation, the friendships you help create – it’s all amazing, and it’s assisting our son in addition to our family understand the issue is fun, and that is tremendously mandatory. Thanks for all the pieces!

  4. I enjoy you because of every one of your labor on this website. Kim really loves participating in investigation and it is easy to understand why. A lot of people know all about the powerful method you create both interesting and useful guidance through the website and even encourage response from other ones about this subject so our own daughter is undoubtedly understanding a lot. Take pleasure in the rest of the year. You’re conducting a great job.

  5. I wish to convey my gratitude for your kindness for those who absolutely need help with this important subject. Your very own dedication to getting the solution along has been particularly practical and has surely made women like me to realize their objectives. Your own warm and friendly recommendations indicates a great deal a person like me and a whole lot more to my colleagues. Many thanks; from everyone of us.

  6. I’m just commenting to make you be aware of of the impressive encounter my friend’s child gained using the blog. She even learned lots of issues, most notably how it is like to possess an awesome teaching style to get many others with ease learn about several problematic issues. You undoubtedly surpassed my desires. Thanks for giving such powerful, trusted, informative and as well as unique thoughts on your topic to Emily.

  7. I simply wanted to write down a simple word so as to say thanks to you for these remarkable points you are placing at this website. My long internet research has at the end been honored with reliable knowledge to exchange with my friends and family. I ‘d express that most of us visitors are definitely lucky to dwell in a good website with very many special professionals with beneficial solutions. I feel somewhat happy to have used your entire website and look forward to plenty of more cool times reading here. Thanks once again for everything.

  8. I am just commenting to let you be aware of what a helpful discovery my cousin’s child encountered viewing the blog. She discovered plenty of pieces, with the inclusion of what it is like to have a very effective helping spirit to let other individuals with ease gain knowledge of certain advanced things. You undoubtedly surpassed people’s desires. I appreciate you for churning out the great, trusted, informative as well as unique thoughts on your topic to Tanya.

  9. I have to express thanks to the writer for rescuing me from such a circumstance. Right after surfing through the online world and meeting proposals which were not beneficial, I thought my life was gone. Existing without the approaches to the problems you have sorted out by means of the posting is a critical case, and ones which may have adversely damaged my career if I hadn’t encountered your site. The understanding and kindness in maneuvering a lot of stuff was very useful. I am not sure what I would’ve done if I had not come upon such a step like this. I’m able to at this point look ahead to my future. Thanks so much for the professional and results-oriented help. I won’t be reluctant to suggest your web site to anyone who requires guidance on this topic.

  10. I want to point out my love for your kind-heartedness supporting individuals who must have help with this one subject. Your very own commitment to passing the solution up and down came to be quite invaluable and has truly enabled workers like me to attain their desired goals. The useful instruction can mean a lot to me and still more to my peers. Thank you; from all of us.

  11. I definitely wanted to post a quick word in order to thank you for some of the fantastic concepts you are sharing at this website. My rather long internet lookup has at the end of the day been rewarded with extremely good concept to talk about with my relatives. I ‘d believe that most of us visitors actually are extremely fortunate to dwell in a fabulous network with very many lovely professionals with great opinions. I feel extremely fortunate to have used the web pages and look forward to many more enjoyable times reading here. Thanks once again for all the details.

  12. I am glad for writing to make you know of the awesome discovery my cousin’s child had using your web site. She came to understand many details, with the inclusion of how it is like to have an awesome teaching character to get the others just learn a variety of tricky subject areas. You truly did more than readers’ expectations. Thank you for offering the precious, healthy, edifying and fun thoughts on this topic to Emily.

  13. I must express appreciation to the writer just for rescuing me from this circumstance. As a result of scouting through the the web and meeting thoughts that were not beneficial, I figured my entire life was done. Living without the presence of approaches to the difficulties you have solved by means of your entire short article is a serious case, and the kind that could have in a negative way damaged my career if I had not come across your web page. Your primary mastery and kindness in playing with the whole lot was priceless. I am not sure what I would have done if I hadn’t encountered such a step like this. I can at this time relish my future. Thanks so much for your professional and effective help. I will not be reluctant to recommend your blog to any individual who will need guidance about this issue.

  14. I must voice my appreciation for your generosity in support of folks that require assistance with the theme. Your real commitment to passing the solution all-around was unbelievably practical and have continually enabled workers just like me to reach their ambitions. Your new informative guidelines signifies so much to me and far more to my peers. Regards; from everyone of us.

  15. I wish to convey my appreciation for your kindness in support of persons that need guidance on this particular concern. Your special dedication to getting the solution all-around appeared to be unbelievably useful and has in most cases empowered many people like me to arrive at their pursuits. Your own important report signifies a lot to me and further more to my peers. Thank you; from everyone of us.

  16. I in addition to my pals were found to be reading through the excellent ideas on the website and then the sudden I had a terrible suspicion I never expressed respect to the website owner for those strategies. The guys are already for this reason warmed to learn all of them and have in effect without a doubt been taking advantage of these things. Thanks for truly being really accommodating and then for making a decision on this kind of remarkable tips most people are really desperate to learn about. My personal sincere regret for not saying thanks to sooner.

  17. I like the helpful info you provide in your articles.I’ll bookmark your blog and check again here frequently.I am quite sure I’ll learn many new stuff right here!Good luck for the next!

  18. To announce true to life news, dog these tips:

    Look representing credible sources: http://anti-labor-trafficking.org/content/pag/?where-is-katie-dupree-on-channel-8-news.html. It’s important to safeguard that the expos‚ source you are reading is reliable and unbiased. Some examples of good sources categorize BBC, Reuters, and The Fashionable York Times. Read multiple sources to pick up a well-rounded view of a discriminating info event. This can improve you carp a more complete display and avoid bias. Be hep of the perspective the article is coming from, as constant good telecast sources can contain bias. Fact-check the information with another source if a expos‚ article seems too unequalled or unbelievable. Forever fetch inevitable you are reading a fashionable article, as scandal can change-over quickly.

    By following these tips, you can evolve into a more au fait scandal reader and best apprehend the cosmos around you.

  19. pharmacy canadian: no.rx – canadadrugpharmacy promo code
    health canada approved online pharmacies – internationalpharmacy.icu Their cross-border services are unmatched.

  20. Быстромонтажные здания: прибыль для бизнеса в каждом элементе!
    В современной сфере, где часы – финансовые ресурсы, быстровозводимые здания стали настоящим спасением для коммерции. Эти новаторские строения комбинируют в себе устойчивость, эффективное расходование средств и молниеносную установку, что придает им способность лучшим выбором для различных бизнес-проектов.
    Строительство каркасных зданий из металлоконструкций
    1. Быстрота монтажа: Часы – ключевой момент в коммерческой деятельности, и сооружения моментального монтажа обеспечивают существенное уменьшение сроков стройки. Это преимущественно важно в ситуациях, когда срочно требуется начать бизнес и начать прибыльное ведение бизнеса.
    2. Бюджетность: За счет оптимизации производства и установки элементов на месте, финансовые издержки на быстровозводимые объекты часто остается меньше, по сравнению с традиционными строительными проектами. Это способствует сбережению денежных ресурсов и обеспечить более высокую рентабельность вложений.
    Подробнее на scholding.ru
    В заключение, объекты быстрого возвода – это лучшее решение для коммерческих задач. Они объединяют в себе быстрое строительство, эффективное использование ресурсов и устойчивость, что позволяет им оптимальным решением для предпринимателей, ориентированных на оперативный бизнес-старт и получать прибыль. Не упустите возможность сократить издержки и сэкономить время, прекрасно себя показавшие быстровозводимые сооружения для вашего следующего делового мероприятия!

  21. Забота о недвижимости – это забота о благополучии. Теплоизоляция стен – это не только стильный внешний вид, но и гарантия сохранения тепла в вашем уютном уголке. Мы, специалисты в своем деле, предлагаем вам превратить ваш дом в идеальный уголок для проживания.
    Наши дизайнерские решения – это не просто тепловая обработка, это творческий процесс с каждым элементом. Мы осуществляем идеальному балансу между внешним видом и практической ценностью, чтобы ваш дом преобразился не только теплым и стильным, но и великолепным.
    И самое главное – доступная стоимость! Мы полагаем, что высококачественные услуги не должны быть неподъемными по цене. Утепление дома стоимость квадратного метра начинается всего от 1250 рублей за квадратный метр.
    Современные технологии и высококачественные строительные материалы позволяют нам создавать утепление, обеспечивающее долговечность и надежность. Прощайте холодным стенам и дополнительным тратам на отопление – наше утепление станет вашим надежным барьером от холода.
    Подробнее на http://ppu-prof.ru
    Не откладывайте на потом заботу о благополучии в вашем доме. Обращайтесь к квалифицированным специалистам, и ваше жилище превратится настоящим творческим шедевром, которое принесет вам не только тепло. Вместе мы создадим дом, в котором вам будет по-настоящему комфортно!

  22. Уважаемые Друзья!
    Предъявляем вам новейшее понятие в мире декора внутреннего пространства – шторы плиссе. Если вы движетесь к безупречности в всякой подробности вашего домашнего, то эти сукна окажутся отличным вариантом для вас.
    Что делает шторы плиссе таковыми особыми? Они совмещают в себе лоск, функциональность и полезность. Благодаря эксклюзивной конструкции, технологичным материалам, шторы плиссе идеально гармонизируются с для всякого интерьера, будь то светлица, дом, кухня или секретарское пространство.
    Закажите штора плиссе на окна – совершите уют и красивость в вашем доме!
    Чем прельщают шторы плиссе для вас? Во-первых, их поразительный макет, который добавляет к обаяние и изысканность вашему месту. Вы можете подобрать из различных текстур, оттенков и подходов, чтобы акцентировать оригинальность вашего дома.
    Кроме того, шторы плиссе предлагают обширный арсенал практических вариантов. Они могут управлять степень света в помещении, гарантировать от солнечного света, поддерживать интимность и создавать комфортную атмосферу в вашем доме.
    Наш интернет-ресурс: http://www.tulpan-pmr.ru
    Мы поможем вам отыскать шторы плиссе, какие прекрасно гармонизируются с для вашего обстановки!

  23. Наша команда искусных мастеров завершена подать вам актуальные методы, которые не только гарантируют надежную защиту от холода, но и подарят вашему зданию изысканный вид.
    Мы занимаемся с современными материалами, сертифицируя прочный время службы и выдающиеся результаты. Изолирование наружных стен – это не только экономия на огреве, но и внимание о окружающей среде. Сберегательные технологии, каковые мы претворяем в жизнь, способствуют не только твоему, но и сохранению природы.
    Самое ключевое: Утепление фасада дома снаружи цена москва у нас составляет всего от 1250 рублей за квадратный метр! Это доступное решение, которое превратит ваш домик в действительный тепловой район с минимальными затратами.
    Наши примеры – это не единственно теплоизоляция, это разработка помещения, в где все элемент отражает ваш персональный стиль. Мы примем все ваши желания, чтобы сделать ваш дом еще больше приятным и привлекательным.
    Подробнее на https://ppu-prof.ru
    Не откладывайте заботу о своем обители на потом! Обращайтесь к исполнителям, и мы сделаем ваш дворец не только теплым, но и более элегантным. Заинтересовались? Подробнее о наших предложениях вы можете узнать на интернет-портале. Добро пожаловать в обитель благополучия и уровня.

  24. Мы специалисты SEO-консультантов, занимающихся продвижением вашего сайта в поисковых системах.
    Мы гордимся своими успехами и предлагаем вам воспользоваться нашим опытом и знаниями.
    Что мы можем вам предложить:
    сео раскрутка цены
    • Подробный анализ вашего сайта и создание персонализированной стратегии продвижения.
    • Усовершенствование контента и технических особенностей вашего сайта для достижения максимальной производительности.
    • Ежедневный анализ данных и мониторинг вашего онлайн-присутствия для постоянного улучшения его эффективности.
    Подробнее https://seo-prodvizhenie-ulyanovsk1.ru/
    У наших клиентов уже есть результаты: повышение посещаемости, улучшение позиций в поисковых запросах и, конечно же, рост бизнеса. У нас вы можете получить бесплатную консультацию, чтобы обсудить ваши потребности и помочь вам разработать стратегию продвижения, соответствующую вашим целям и бюджету.
    Не упустите возможность улучшить свой бизнес в онлайн-мире. Свяжитесь с нами прямо сейчас.

Leave a Reply

Your email address will not be published. Required fields are marked *