{"id":1469,"date":"2009-02-06T12:00:00","date_gmt":"2009-02-06T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1469"},"modified":"2009-02-06T12:00:00","modified_gmt":"2009-02-06T12:00:00","slug":"grid-control-accessibility","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2009\/02\/06\/grid-control-accessibility\/","title":{"rendered":"Grid Control Accessibility"},"content":{"rendered":"

I work at a site that has Diagnostic and Tuning Pack licenses (yippee!) so, before we started deploying Grid Control, I tried to encourage the installation of Database Control in the mean-time so that people could get used to the Performance Pages that I find incredibly useful. <\/p>\n

I was fascinated to see how my blind colleague Richard would get along with the pretty pictures because the big benefit to me is the at-a-glance view of things which helps me determine whether a database looks like it has a serious performance problem. (Yes, I’m aware of the heresy implicit in that statement when compared to building a response time profile for an individual session a la Method R or YAPP, but sue me – I’m still identifying performance problems successfully without that approach. Not all categories of problem, for sure, but it’s useful for most things.) Then I can drill down through the data to the sessions or SQL statements of interest. However, the start of the process has become a very visual one for me.<\/p>\n

Anyway, without wishing to speak for Richard (hint – there’s a comment box below), the initial results were surprisingly good. We had previously used Quest’s Foglight for monitoring which, because it is based on images, is completely useless to anyone blind. They can’t see a thing. The same is true for the Oracle Universal Installer and it’s time Oracle addressed that. I suspect it drives Richard slightly nuts that he can breeze through most DBA tasks with equal or greater competency than others and then has to ask people to help clicking a few buttons.\u00a0 <\/p>\n

I was worried that the Top Activity screen would be similarly useless but, because it’s based on all the usual HTML stuff, it can be navigated and read using Richard’s standard but still impressive approach of a blur of keyboard shortcuts and intense listening to his speech software. In fact the tables are turned, because I often can’t see where the hell he is on the screen when we’re going through something for the first time, so he has to tell me. I’m metaphorically blind at those moments. I’ll stick to the metaphorical version if you don’t mind, though. It’s a deeply unsettling experience for the few moments I experience it although it can be quite funny, too. I have to ask him to maximise the browser window frequently because I can’t see everything! In fact, we need to go through the whole business of getting the monitor switched on and off each time, too. At first I couldn’t work out why Richard *had* a monitor, seeing that it’s never switched on, but it becomes fairly essential if we *both* want to look at a problem!<\/p>\n

So Richard can jump around that Top Activity chart and hear the time period that’s higlighted, the wait classes and the proportion of activity in each of the classes. I was amazed he could do that and it’s a damn site better than Foglight from Richard’s perspective, but it all still seemed difficult to me. I suppose Richard has a life-time of overcoming these challenges.<\/p>\n

However, I was still pleased when I noticed an Accessibility section<\/a> of the Grid Control documentation, which contains two configuration items. The first is about switching off optimisations which might confuse speech software, but I wanted to focus on the second one here – “Providing Textual Descriptions of Enterprise Manager Charts”. There are full instructions in that documentation link, so I won’t repeat them here, but I will show you the example image from the documentation for those who can see it.<\/p>\n

\"\"<\/p>\n

In fact, let me copy another welcome feature that Oracle have implemented in the documentation and paste their text description of this image for those who can’t see it.<\/p>\n

“The illustration OEM_text_link.gif shows a screen capture of a typical Enterprise Manager chart. A callout in the lower right corner of the illustration identifies the icon you can click to display a textual representation of the data in the chart. This icon appears next to all charts when textual descriptions are enabled using the procedure documented in this section of the guide.”<\/p>\n

By navigating to that little link and selecting it, it pops up a new page with a text table containing the numbers behind the chart. Much easier to read. However, one criticism I would make is that the Top Activity chart is displayed from the oldest information to the most recent. There’s a certain logic to that – display the numbers as they appear on the chart from left to right, but that means that what’s happened most recently is at the bottom of the table and I’m not sure that’s a convenient way to read things. That’s my personal view, but I’m sure others will disagree.<\/p>\n

So, well done Oracle for thinking about this and including it.<\/p>\n

I’d been thinking about this blog post for quite a while, but what finally prompted me to get off my back-side and write it was when one of my other colleagues, Dave, did something during the week that I hadn’t thought of while we were both looking at a server performance problem. I was wondering about the sample interval of a specific chart, at which point he clicked the text table link. <\/p>\n

[Sound of penny dropping from 10,000 feet and clanging off the top of my head.]<\/p>\n

Of course, what an idiot I’d been. Maybe it’s a very useful feature for all of us because, pretty though the pictures are, maybe I’d like to check the underlying numbers sometimes! In fact, because this is possible in Database Control, I’m going to configure it for future use when I’m teaching.<\/p>\n

Good stuff all round and long may Oracle continue thinking about accessibility issues.<\/p>\n

Now, about that installer ….<\/p>\n","protected":false},"excerpt":{"rendered":"

I work at a site that has Diagnostic and Tuning Pack licenses (yippee!) so, before we started deploying Grid Control, I tried to encourage the installation of Database Control in the mean-time so that people could get used to the Performance Pages that I find incredibly useful. I was fascinated to see how my blind… Continue reading Grid Control Accessibility<\/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-1469","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1407,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/30\/oug-scotland-dba-sig\/","url_meta":{"origin":1469,"position":0},"title":"OUG Scotland DBA SIG","date":"April 30, 2008","format":false,"excerpt":"An enjoyable day, but it flew by. Having not had much sleep last night through worrying about the first time I was giving this particular presentation, I'm glad I was able to present in the second slot of the day because I knew I'd be flagging later on. The most\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1392,"url":"http:\/\/orcldoug.com\/blog\/2008\/03\/18\/paste\/","url_meta":{"origin":1469,"position":1},"title":"Paste","date":"March 18, 2008","format":false,"excerpt":"[As part of the occasional series on small but useful Unix commands ...]I've always loved Unix and vi and despair at those who prefer to faff around on Windows trying to edit files with an operating system and editors that, yes, are much more friendly but are hopelessly limited. The\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1191,"url":"http:\/\/orcldoug.com\/blog\/2007\/01\/27\/dba-documentation-catalogue\/","url_meta":{"origin":1469,"position":2},"title":"DBA Documentation – Catalogue","date":"January 27, 2007","format":false,"excerpt":"Prompted by Linda's comment on a previous blog, I thought it might be worth writing a couple of postings on DBA documentation.The first thing you need is a Database Catalogue of some kind.Benefits1) Even an experienced DBA arriving on site won't know what servers exist, how to login to them,\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1284,"url":"http:\/\/orcldoug.com\/blog\/2007\/06\/10\/non-reusable-space\/","url_meta":{"origin":1469,"position":3},"title":"Non-reusable Space?","date":"June 10, 2007","format":false,"excerpt":"A problem cropped up at work this week and, whilst it wasn't particularly tricky and didn't take long to solve, it struck me that the story of tracking it down might be useful and you might hit the problem yourself one day.A recently-deployed Data Warehouse database at work has a\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1406,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/27\/upcoming-events\/","url_meta":{"origin":1469,"position":4},"title":"Upcoming Events","date":"April 27, 2008","format":false,"excerpt":"I'll be presenting at a few events in the next couple of months.30th April - OUG Scotland DBA SIG Meeting.This one is the easiest for me to travel to, being just on the out-skirts of Edinburgh, and is always a well-organised event with a decent agenda, thanks to the local\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1117,"url":"http:\/\/orcldoug.com\/blog\/2006\/10\/31\/recovery-design-part-3-what-is-it-with-rac\/","url_meta":{"origin":1469,"position":5},"title":"Recovery Design part 3 – What is it with RAC?","date":"October 31, 2006","format":false,"excerpt":"For the next few parts of this mini-series, I'm going to start looking at the initial high level design for the system and how well it meets the requirements. First of all I'm going to talk about the most critical database from the business perspective. I'll call it the User\u2026","rel":"","context":"With 16 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1469","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=1469"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1469\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1469"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}