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.

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

  21. I have read your article carefully and I agree with you very much. This has provided a great help for my thesis writing, and I will seriously improve it. However, I don’t know much about a certain place. Can you help me?

  22. Aviator Spribe казино играть на турнире
    I with you completely agree.
    Добро пожаловать в захватывающий мир авиаторов! Aviator – это увлекательная игра, которая позволит вам окунуться в атмосферу боевых действий на небе. Необычные графика и захватывающий сюжет сделают ваше путешествие по воздуху неповторимым.

    Зарабатывайте деньги с автоматом Aviator Spribe играть и наслаждайтесь игровым процессом!
    Aviator игра позволит вам почувствовать себя настоящим пилотом. Вам предстоит совершить невероятные маневры, выполнять сложные задания и сражаться с противниками. Улучшайте свой самолет, чтобы быть готовым к любым ситуациям и становиться настоящим мастером.
    Основные особенности Aviator краш игры:
    1. Реалистичная графика и физика – благодаря передовой графике и реалистичной физике вы почувствуете себя настоящим пилотом.
    2. Разнообразные режимы игры и миссии – в Aviator краш игре вы сможете выбрать различные режимы игры, такие как гонки, симулятор полетов и захватывающие воздушные бои. Кроме того, каждая миссия будет предлагать свои собственные вызовы и задачи.
    3. Улучшение и модернизация самолетов – в игре доступны различные модели самолетов, которые можно покупать и улучшать. Вы сможете устанавливать новое оборудование, улучшать двигательность и мощность своего самолета, а также выбирать различные варианты окраски и декорации.
    Aviator краш игра – это возможность испытать себя в роли авиатора и преодолеть все сложности и опасности воздушного пространства. Почувствуйте настоящую свободу и адреналин в Aviator краш игре онлайн!
    Играйте в «Авиатор» в онлайн-казино Pin-Up
    Aviator краш игра онлайн предлагает увлекательную и захватывающую игровую атмосферу, где вы становитесь настоящим авиатором и сражаетесь с самыми опасными искусственными интеллектами.
    В этой игре вы должны показать свое мастерство и смекалку, чтобы преодолеть сложности многочисленных локаций и уровней. Вам предстоит собирать бонусы, уклоняться от препятствий и сражаться с врагами, используя свои навыки пилотирования и стрельбы.
    Каждый уровень игры Aviator краш имеет свою уникальную атмосферу и задачи. Будьте готовы к неожиданностям, так как вас ждут захватывающие повороты сюжета и сложные испытания. Найдите все пути к победе и станьте настоящим героем авиатором!
    Авиатор игра является прекрасным способом провести время и испытать настоящий адреналиновый разряд. Готовы ли вы стать лучшим авиатором? Не упустите свой шанс и начните играть в Aviator краш прямо сейчас!
    Aviator – играй, сражайся, побеждай!
    Aviator Pin Up (Авиатор Пин Ап ) – игра на деньги онлайн Казахстан
    Aviator игра предлагает увлекательное и захватывающее разнообразие врагов и уровней, которые не оставят равнодушными даже самых требовательных геймеров.
    Враги в Aviator краш игре онлайн представлены в самых разных формах и размерах. Здесь вы встретите группы из маленьких и быстрых врагов, а также огромных боссов с мощным вооружением. Разнообразие врагов позволяет игрокам использовать разные тактики и стратегии для победы.
    Кроме того, Aviator игра предлагает разнообразие уровней сложности. Выберите легкий уровень, чтобы насладиться игровым процессом, или вызовите себе настоящий вызов, выбрав экспертный уровень. Независимо от выбранного уровня сложности, вы получите максимум удовольствия от игры и окунетесь в захватывающий мир авиаторов.
    Играйте в Aviator и наслаждайтесь разнообразием врагов и уровней, которые позволят вам почувствовать себя настоящим авиатором.

  23. Hey there! Do you know if they make any plugins to help with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!
    My page site#:
    https://ya.0bb.ru/viewtopic.php?id=9868#p28126
    http://dianov.bget.ru/forum/thread53952.html#1216734
    https://woman.build2.ru/viewtopic.php?id=12266#p39903
    http://sciencenewhop.maxbb.ru/viewtopic.php?f=44&t=511
    http://rabotianadomy.frmbb.ru/viewtopic.php?id=2092#p2522

  24. Hello there I am so grateful I found your web site, I really found you by accident, while I was looking on Bing for something else, Regardless I am here now and would just like to say thank you for a marvelous post and a all round entertaining blog (I also love the theme/design), I don’t have time to go through it all at the moment but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the superb work.
    http://go0gle.coom
    http://dneprorudnoe.bbok.ru/viewtopic.php?id=3898#p27547
    http://ukr.mybb.ru/viewtopic.php?id=376#p1010
    http://inter.5bb.ru/viewtopic.php?id=9042#p9094
    http://sfc.mybb.ru/viewtopic.php?id=908#p24091
    http://crimeadetka.forum.cool/viewtopic.php?id=1486#p87414

  25. An intriguing discussion is worth comment. There’s no doubt that that you should write more about this topic, it might not be a taboo matter but usually folks don’t speak about these issues. To the next! Many thanks!!

  26. Excellent weblog here! Also your website loads up fast! What host are you the use of? Can I get your affiliate link in your host? I want my web site loaded up as quickly as yours lol

  27. It’s perfect time to make some plans for the future and it is time to be happy. I’ve learn this post and if I could I want to suggest you few attention-grabbing things or suggestions. Perhaps you can write subsequent articles relating to this article. I wish to read even more issues approximately it!

  28. Wonderful goods from you, man. I’ve take note your stuff prior to and you’re just too excellent. I really like what you have got here, certainly like what you are stating and the way in which wherein you assert it. You’re making it enjoyable and you continue to care for to keep it wise. I cant wait to learn much more from you. This is really a wonderful site.

  29. Have you ever considered about including a little bit more than just your articles? I mean, what you say is fundamental and all. Nevertheless imagine if you added some great visuals or video clips to give your posts more, “pop”! Your content is excellent but with images and video clips, this blog could undeniably be one of the very best in its field. Good blog!

  30. Aviator Spribe играть по стратегии
    Добро пожаловать в захватывающий мир авиаторов! Aviator – это увлекательная игра, которая позволит вам окунуться в атмосферу боевых действий на небе. Необычные графика и захватывающий сюжет сделают ваше путешествие по воздуху неповторимым.
    Aviator Spribe играть на деньги казино

  31. Авиатор Спрайб играть на деньги
    Добро пожаловать в захватывающий мир авиаторов! Aviator – это увлекательная игра, которая позволит вам окунуться в атмосферу боевых действий на небе. Необычные графика и захватывающий сюжет сделают ваше путешествие по воздуху неповторимым.
    Aviator Spribe как играть

  32. Thanks for your marvelous posting! I quite enjoyed reading it, you could be a great author.I will be sure to bookmark your blog and will eventually come back later on. I want to encourage yourself to continue your great posts, have a nice holiday weekend!

  33. Hello there! I know this is kinda off topic but I was wondering which blog platform are you using for this website? I’m getting tired of WordPress because I’ve had issues with hackers and I’m looking at options for another platform. I would be fantastic if you could point me in the direction of a good platform.

  34. Hello there! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done a marvellous job!

  35. hi!,I really like your writing very so much! proportion we communicate more approximately your post on AOL? I require an expert in this area to resolve my problem. May be that’s you! Looking ahead to look you.

  36. Hmm it appears like your site ate my first comment (it was super long) so I guess I’ll just sum it up what I submitted and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog blogger but I’m still new to the whole thing. Do you have any tips for first-time blog writers? I’d definitely appreciate it.

  37. Hmm it looks like your blog ate my first comment (it was super long) so I guess I’ll just sum it up what I submitted and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog blogger but I’m still new to everything. Do you have any points for beginner blog writers? I’d really appreciate it.

  38. Having read this I believed it was rather enlightening. I appreciate you finding the time and energy to put this content together. I once again find myself spending way too much time both reading and posting comments. But so what, it was still worthwhile!

  39. Hi! I just wanted to ask if you ever have any problems with hackers? My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no back up. Do you have any solutions to prevent hackers?

  40. Авиатор Спрайб играть на деньги
    Добро пожаловать в захватывающий мир авиаторов! Aviator – это увлекательная игра, которая позволит вам окунуться в атмосферу боевых действий на небе. Необычные графика и захватывающий сюжет сделают ваше путешествие по воздуху неповторимым.
    Aviator Spribe играть бесплатно казино

  41. Definitely believe that which you stated. Your favorite justification seemed to be on the net the simplest thing to be aware of. I say to you, I definitely get irked while people think about worries that they plainly do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks

  42. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your site when you could be giving us something informative to read?

  43. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something enlightening to read?

  44. Great post. I was checking constantly this blog and I am impressed! Extremely helpful info particularly the last part 🙂 I care for such information a lot. I was seeking this certain info for a long time. Thank you and best of luck.

  45. I like the valuable info you provide in your articles. I’ll bookmark your blog and check again here regularly. I’m quite sure I will learn many new stuff right here! Best of luck for the next!

  46. Hmm is anyone else having problems with the pictures on this blog loading? I’m trying to figure out if its a problem on my end or if it’s the blog. Any feedback would be greatly appreciated.

  47. Sweet blog! I found it while searching on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thank you

Leave a Reply to Andrewflego Cancel reply

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