{"id":895,"date":"2005-12-07T12:00:00","date_gmt":"2005-12-07T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=895"},"modified":"2005-12-07T12:00:00","modified_gmt":"2005-12-07T12:00:00","slug":"oracle-enterprise-manager-10gr2","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/12\/07\/oracle-enterprise-manager-10gr2\/","title":{"rendered":"Oracle Enterprise Manager 10gR2"},"content":{"rendered":"

First of all, let me be clear that I’m not a fan of GUI tools. That’s not based on a misguided macho opinion that somehow you need to be able to struggle with a command line interface to prove that you’re a good DBA but because :-<\/p>\n

    \n
  1. I’m a contractor who works at a large number of different client sites – usually a couple per year. Unless everyone uses the same GUI tools, it’s just more to learn at each new site that probably won’t be usable when I go to the next site. The single biggest advantage of SQL*Plus for me is that I know it will *always* be there, regardless of Oracle version or operating system. (Interestingly, even RMAN is not used universally, so it can be a struggle to keep those skills up to date) <\/li>\n
  2. I’m probably a bit of a control freak when it comes to my work and I like to be able to see everything that I’ve done and control every step.<\/li>\n
  3. When you’re a production DBA, much of the time you need to work through change control procedures that require detailed implementation plans. It’s simply easier to produce a series of SQL commands than explain which particular buttons you’re going to press and in what order. It’s also easier to log actions into a single log file, develop repeatable scripts and so on. <\/li>\n
  4. Up until now, I’ve found that the majority of GUI DBA tools have achingly slow, buggy or just clumsy interfaces. They don’t improve when used over a dial-up connection when you’re on-call! <\/li>\n
  5. By implication, GUI tools reduce what I can do. There is always some minor option or detail that the GUI doesn’t support. It may be a bit more difficult to do things with a CLI, but it will support everything I need to do. <\/li>\n
  6. Actually, there are probably quite a few other reasons that I can’t think of right now. In summary, I’m not married to command line utilities, but I need to be convinced that a GUI tool can be better.<\/li>\n<\/ol>\n

    Now, having got that out of the way, I have to say that I’m extremely impressed by OEM in 10gR2. I remember when OEM started moving to the web-style interface because I was involved in developing a course for App Server 9i, which used it. However I always found that interface painfully slow and buggy.<\/p>\n

    I emphasise that I haven’t used it in anger yet and (I think this could be important) I’m working as a single user on a 4-CPU \/ 3.5Gb RAM server, but the performance analysis functionality is particularly impressive (partly of course because the underlying information has been improved). There have been a few times already when I’ve dipped into the GUI because it showed me more<\/span> detail more quickly. I’m shocked by how impressed I am. All the guys at work think I’m losing my touch because I’ve been raving about it 😉<\/p>\n

    However, it still has that learning curve problem for me but as it’s an Oracle supplied tool (if expensive), it’s more likely to appear at the various companies I work for so the initial work is more likely to pay off.<\/p>\n

    I’d been vaguely aware of Chris Foot discussing this tool in a series of blog entries<\/a>, but had never bothered to read them too much because I hate GUI tools 😉 However, I’ve started to work through them and you might want to take a fresh look at OEM yourself.<\/p>\n

    I am, of course, interested in any negative comments because my anti-GUI bias is lurking in the background, waiting to be satisified!<\/p>\n","protected":false},"excerpt":{"rendered":"

    First of all, let me be clear that I’m not a fan of GUI tools. That’s not based on a misguided macho opinion that somehow you need to be able to struggle with a command line interface to prove that you’re a good DBA but because :- I’m a contractor who works at a large… Continue reading Oracle Enterprise Manager 10gR2<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1509,"url":"http:\/\/orcldoug.com\/blog\/2009\/07\/22\/a-top-book\/","url_meta":{"origin":895,"position":0},"title":"A TOP Book","date":"July 22, 2009","format":false,"excerpt":"Well, I have always been and probably always will be poor at coming up with snappy, punning titles for blog posts, so it's the best I can do.I bought Troubleshooting Oracle Performance by Christian Antognini a while ago (when it was first published, I think) but, as seems to be\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1430,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/17\/my-openworld-schedule\/","url_meta":{"origin":895,"position":1},"title":"My Openworld Schedule","date":"August 17, 2008","format":false,"excerpt":"Knowing myself, I doubt it will end up quite like this, but I thought I'd throw together an approximation. (I must say, the schedule builder this year is a significant improvement on previous years. It doesn't have a jet-lag adjustor, but you can't have everything.)Sunday, Sep 21 10:00-11:30 Building an\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1263,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/01\/oracle-and-community-involvement\/","url_meta":{"origin":895,"position":2},"title":"Oracle and Community Involvement","date":"May 1, 2007","format":false,"excerpt":"Dammit, I'm going to have to start writing about Oracle again! Even worse, it's not technical but (cough) opinion and analysis \ud83d\ude41I saw Justin Kestelyn's blog last week and my immediate reaction was slightly sympathetic, but I decided to sit back for a few days and watch the fun develop,\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1314,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/09\/one-day-soon-ill-install-something\/","url_meta":{"origin":895,"position":3},"title":"One Day Soon, I’ll Install Something","date":"September 9, 2007","format":false,"excerpt":"What a horrible week it's been from a technical perspective.I decided mid-way through the previous week that I was going to bite the bullet, give up on DTrace for a while and install Linux on the server so I could run the PX tests on 11g. Then Jeff Moss sent\u2026","rel":"","context":"With 20 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":903,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/12\/book-review-cost-based-oracle-fundamentals\/","url_meta":{"origin":895,"position":4},"title":"Book Review: Cost-Based Oracle – Fundamentals","date":"November 12, 2005","format":false,"excerpt":"Here's a review of Jonathan Lewis' new book that I've just posted on amazon.co.uk Here is your review the way it will appear: An Exceptional BookReviewer: Doug Burns from EDINBURGH, Lothians United KingdomIt's my favourite Oracle book of the many I've read (apologies to Tom Kyte) and I'm not expecting\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":900,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/22\/amazon\/","url_meta":{"origin":895,"position":5},"title":"Amazon","date":"November 22, 2005","format":false,"excerpt":"I found out today why my review of the new Jonathan Lewis book hadn't appeared on Amazon. Apparently it violated their review guidelines and they didn't want to publish it. I've resubmitted a shorter review, removing everything I thought might be a problem, so I have my own ideas, but\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}