database management

Today we are going to look at managing an Oracle database. We are going to start with a 12c database that we created in the Oracle Public Cloud. We selected database as a service (as opposed to virtual image), monthly billing, 12c, and enterprise edition high performance edition. We accepted the defaults for the table size so that we can figure out how to extend the table size and selected no backups rather than starting RMAN for daily incrementals or cloud object storage for weekly full backups.

We basically have four options for managing a database. If we have a small number of databases we might look at using the sqlplus sysdba command line access and grind through administration. We also have a database monitor that is installed by default with the database cloud service. We can dive into this database through the monitor and look at log running queries, tablespace sizes, and generic utilization. We can also connect with sql developer and look at the new DBA interfaces that were added in the latest release in early 2016. The fourth and final way of administering is to look at commercial management tools like Oracle Enterprise Manager (OEM) or other tools that aggregate multiple systems and servers and give you exposure beyond just the database. These commercial tools allow you to look at they layer that you are most interested in. You can get a PeopleSoft Management Pack for OEM that allows you to look at purchase order flow, or payroll requests. You can get diagnostics and tuning packs for the application server and database that allows you to look at what part of the PeopleSoft implementation is taking the longest. Is it the network connection? It is a poorly tuned Java Virtual Machine that is memory thrashing? It is a sql statement that is waiting on a lock? Is it a storage spindle that is getting hammered from another application? Is it a run away process on your database server that is consuming all of the resources? All of these questions can be answered with a monitoring tool if you not only know how to use it but what is available for free and what you need to purchase to get the richer and more valuable information.

To get to the database monitor we go to the cloud services console (which changed over the weekend so it looks a little different), click on database, click on Service Console, and click on the database name.

If we click on the dbaas_monitor menu item in the hamburger menu system to the right of the service name it might fail to connect the first time. It will take the ip address of the database and try to open https://ip address/dbaas_monitor. We first need to open up port 443 to be able to communicate to this service.

To get to the network connection we need to go to the Compute Service Monitor, click on the Network tab, and change the proper port number for our server prs12cHP. If we hover over the labels on the left we see what ports we are looking for. We are specifically interested in the https protocol. If we click on the hamburger menu next to this line item we can Update the security list which pops up a new window.

To enable this protocol we enable the service and click the Update button. Once we do this we can retry the dbaas_monitor web page. We should expect a security exception the first time and need to add an exception. We login as dbaas_monitor and the password that we entered in the bottom left of the screen for the system passwords when we created the database.

At this point we can look at cpu utilization, table space usage, if the database is running, and all other monitoring capabilities. Below are the screen shots for the listener and the table sizes and storage by pluggable database.

We can look a little deeper at things like alerts, wait times, and real time sql monitoring. These are all available through command line but providing a service like this allows junior database administrators to look at stuff quickly and easily.

The biggest drawback to this system is that you get a short snapshot and not a long term historic archive of this data. If we use Enterprise Manager, which we will look at in a later blog, from a central site we collect the data in a local repository we can look back at months old data rather than live or data from the past few hours.

In summary, if we use platform as a service, we get tooling and reporting tools integrated into services rather than having to spin these up or look at everything from the command line as is done with infrastructure as a service. We get other features but we are diving into database monitoring this week. We briefly touched on database monitoring through what was historically called dbmonitor and is moving towards dbaas_monitor or a central enterprise manager pane of glass for database services in our data center and in the cloud. One of the key differentials from Oracle Database as a Service and Amazon RDS is database monitoring. We will look at database monitoring for Amazon RDS later this week and notice there are significant differences.

353 thoughts on “database management”

  1. I and also my friends ended up reading the great guides found on your web site then all of the sudden came up with a horrible suspicion I had not thanked the web blog owner for those techniques. All the young men were so stimulated to learn them and already have really been taking advantage of those things. I appreciate you for actually being simply thoughtful and then for considering varieties of quality issues millions of individuals are really eager to understand about. Our honest apologies for not saying thanks to earlier.

  2. I want to point out my appreciation for your kindness supporting those who absolutely need help on in this content. Your very own dedication to getting the solution up and down appears to be extremely helpful and have surely enabled men and women much like me to arrive at their pursuits. This interesting help and advice entails a lot to me and extremely more to my mates. Thank you; from everyone of us.

  3. I must express some thanks to this writer just for bailing me out of this type of crisis. After checking through the world wide web and coming across tips which were not beneficial, I thought my entire life was done. Being alive without the strategies to the problems you have resolved all through your entire short post is a serious case, and ones that might have adversely damaged my entire career if I had not encountered your website. Your good competence and kindness in maneuvering the whole lot was valuable. I am not sure what I would have done if I had not come upon such a stuff like this. I can also at this time relish my future. Thanks for your time very much for your professional and amazing help. I won’t be reluctant to recommend the sites to anybody who ought to have direction on this matter.

  4. I want to express some thanks to you for rescuing me from this crisis. Because of scouting through the the net and finding proposals which are not powerful, I figured my entire life was done. Living without the answers to the difficulties you’ve resolved all through your main article content is a critical case, as well as those which may have badly damaged my entire career if I hadn’t come across the website. Your actual training and kindness in handling all the details was useful. I am not sure what I would have done if I hadn’t come across such a point like this. I am able to at this point relish my future. Thanks for your time so much for the impressive and results-oriented guide. I won’t hesitate to suggest the website to any individual who needs and wants care on this issue.

  5. Thanks a lot for providing individuals with a very nice opportunity to discover important secrets from this website. It’s always very pleasing plus stuffed with fun for me and my office fellow workers to visit your website a minimum of three times every week to find out the fresh things you have got. Not to mention, I’m just actually satisfied considering the good tricks served by you. Selected 1 areas in this article are in truth the most beneficial we have had.

  6. Thank you so much for giving everyone an extraordinarily marvellous chance to read in detail from here. It is usually so amazing and as well , jam-packed with a lot of fun for me and my office colleagues to search your blog not less than three times weekly to read through the fresh stuff you will have. Of course, I’m so at all times fascinated with the perfect tactics you give. Certain 3 areas in this article are basically the most suitable I have had.

  7. временная регистрация

    Наша общество предлагает комплексные услуги по юридическому сопровождению в процессе оформления временной регистрации в Москве. В штате только профильные юристы, которые гарантируют успешное получение ВР в любом регионе для нужный вам срок.

    временная регистрация

  8. I’m writing to let you understand of the excellent experience my wife’s child enjoyed reading your site. She learned so many issues, including how it is like to possess an awesome teaching heart to get a number of people really easily know just exactly a number of tortuous matters. You really exceeded our desires. Thanks for churning out the powerful, dependable, edifying and even easy tips on your topic to Sandra.

  9. Thanks for each of your efforts on this blog. My niece takes pleasure in doing investigation and it’s really easy to understand why. Most of us hear all of the powerful medium you present vital things on this web blog and cause participation from people on that content while our child is undoubtedly studying a lot. Enjoy the rest of the year. You’re the one doing a great job.

  10. I want to show appreciation to the writer for bailing me out of such a dilemma. As a result of researching through the internet and seeing basics which were not helpful, I was thinking my life was over. Being alive minus the approaches to the difficulties you have solved by means of your main guideline is a crucial case, as well as those which might have in a negative way damaged my career if I hadn’t discovered your web page. That ability and kindness in dealing with every aspect was very useful. I am not sure what I would have done if I had not come upon such a solution like this. It’s possible to at this time relish my future. Thank you so much for the expert and sensible help. I won’t be reluctant to suggest the sites to anybody who would like direction about this subject.

  11. I enjoy you because of all your efforts on this web page. Kim take interest in doing internet research and it is easy to understand why. Most of us know all of the dynamic form you give vital tips via your web site and in addition improve participation from visitors about this subject matter while our simple princess has been understanding so much. Take pleasure in the rest of the year. You’re carrying out a splendid job.

  12. I must point out my appreciation for your generosity for men and women who actually need assistance with in this concern. Your real dedication to getting the message all over had been certainly informative and have continuously empowered men and women like me to attain their aims. Your own invaluable guidelines means so much a person like me and still more to my office workers. Thanks a lot; from each one of us.

  13. I in addition to my pals ended up digesting the excellent procedures from your web site then quickly came up with an awful suspicion I had not thanked the web blog owner for them. These ladies were definitely absolutely passionate to see them and have now sincerely been tapping into those things. Thanks for genuinely very thoughtful and also for opting for these kinds of cool ideas millions of individuals are really desperate to know about. My personal sincere apologies for not saying thanks to earlier.

  14. I simply wanted to type a brief word to thank you for all of the awesome advice you are writing on this site. My considerable internet search has at the end of the day been honored with sensible content to write about with my good friends. I ‘d assert that many of us website visitors actually are unquestionably fortunate to live in a fabulous community with many marvellous people with interesting solutions. I feel very much blessed to have encountered your web page and look forward to so many more exciting moments reading here. Thank you again for a lot of things.

  15. I am writing to let you be aware of of the fantastic discovery my child encountered reading yuor web blog. She learned a good number of issues, which include what it’s like to have an ideal giving character to get others without hassle gain knowledge of selected extremely tough things. You truly surpassed our own expected results. I appreciate you for providing such interesting, dependable, revealing and easy tips about this topic to Ethel.

  16. I must show appreciation to you for rescuing me from this matter. As a result of looking out throughout the the web and obtaining suggestions that were not powerful, I believed my life was well over. Living devoid of the approaches to the issues you have sorted out as a result of the article is a crucial case, and those which might have adversely damaged my career if I hadn’t encountered your blog. Your personal training and kindness in taking care of every part was tremendous. I am not sure what I would have done if I had not come across such a thing like this. It’s possible to now look ahead to my future. Thanks a lot very much for this impressive and sensible guide. I will not hesitate to suggest your web site to anybody who wants and needs recommendations on this matter.

  17. My wife and i felt quite peaceful that Emmanuel could deal with his survey through the entire precious recommendations he came across out of the blog. It is now and again perplexing to simply possibly be giving away points which often others have been making money from. And now we fully grasp we have got you to thank for this. All of the illustrations you’ve made, the easy blog navigation, the relationships your site help to foster – it is many astounding, and it is letting our son in addition to the family recognize that that subject is pleasurable, which is incredibly important. Thank you for the whole lot!

  18. I have to express my affection for your generosity supporting persons that require help on your field. Your very own dedication to passing the solution across turned out to be exceedingly advantageous and have usually enabled many people much like me to achieve their dreams. Your own insightful useful information denotes a lot to me and even more to my fellow workers. Best wishes; from each one of us.

  19. Thank you so much for providing individuals with an exceptionally brilliant possiblity to read articles and blog posts from this website. It’s always so brilliant plus jam-packed with amusement for me personally and my office co-workers to search your website the equivalent of three times in 7 days to read the newest guides you will have. And definitely, I’m just certainly fulfilled with all the staggering solutions you serve. Some two ideas in this article are clearly the best we’ve had.

  20. I would like to express some thanks to this writer for bailing me out of such a difficulty. Just after surfing around through the online world and obtaining tips which were not powerful, I figured my life was gone. Living devoid of the answers to the problems you have fixed by means of your article content is a critical case, as well as the kind that would have adversely affected my career if I had not discovered your web page. Your actual mastery and kindness in playing with every part was important. I don’t know what I would’ve done if I had not encountered such a solution like this. I can also at this time look ahead to my future. Thanks for your time very much for your specialized and results-oriented help. I won’t think twice to endorse your blog post to anyone who needs to have guidelines about this subject matter.

Leave a Reply

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