Feb 6: Grid Control Accessibility
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.
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.
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!
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.
However, I was still pleased when I noticed an Accessibility section 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.
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.
"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."
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.
So, well done Oracle for thinking about this and including it.
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.
[Sound of penny dropping from 10,000 feet and clanging off the top of my head.]
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.
Good stuff all round and long may Oracle continue thinking about accessibility issues.
Now, about that installer ....
Good posting. This saves me from writing about the same.
The Oracle Universal Installer (OUI) is perfectly accessible, but you have to run your screen reader where your OUI runs. This means if you run your OUI on a Unix box you need to run a screen reder on the same Unix box. This is where the problem begins because most Unixes do not have a screen reader. The workaround is to use the OUI in silent mode driven by a response file. Thus it is not Oracle causing the issue. Let Richard run the OUI on his Windows machine and be surprised.(If he has the JavaAccessBridge installed)
Yes, using a Unix screenreader would be a problem since I'm pretty sure I wouldn't allowed to install this type of software on our servers. As for the response file, I've certainly done some work with these in the past but was never able to get a clean install with them - sounds as though I need to spend more time familiarising myself with their use, though.
Similarly, with the JavaAccessBridge, I never had any success either; this may well have been due to the version of speech software I was using the last time I tried, though. Can you let me know which speech package you're using on Windows and its version so that I can try the same combination to see if I have any more joy? I'm currently using JAWS v10.
I am using JAWS version 10 and I have the Java Access Bridge version 2 installed.
Well, that sounds like a project for next week then. Sounds cool and I hope it works out, having blamed Oracle for making an inaccessible installer. We'll be sure to report back.
Of course, Richard never told be anything about this JavaAccessBridge thingy, but he's like that
As for response files, I remember the nightmares we went through trying to get those things to work, but we are both a little old ...
Yep, that's me Harald - stealing other people's material! LOL
I'd been meaning to write about this since last summer, honestly!
Well, where do I start? Firstly, I suppose to endorse Doug's praise for Oracle to have made the effort to build accessibility into this product - sadly, it is all too rare from any vendors and most welcome.
Also, one of the tenets of accessibility for many years has been "universal design", ie the design of a product should be such that no sector of the marketplace or society be excluded from its use. The scenario quoted here is an excellent example of how this principle of universal design can be beneficial to a greater audience than originally intended! The key word here is "design", ie for maximum benefit, the needs of all must be considered at product/software inception and no bolted on as an afterthought.
As a software junky, I must confess to feeling "excited" at the prospect of using a tool with which I don't have to fight to get any meaningful information out of it! I know Grid Control will have its flaws - in fact, I know it has, eg the inability to reverse engineer the script for more than one user at a time - but, without wishing to come across as too "new age" (calm yourself, Doug), it's wonderfully liberating to be able to do even the most simple things such as creating black-outs; trivial to most, I know, but not when you've been unable to perform this very menial task until now!
Oh yes, as for that switched-off screen...it's for privacy - there are some benefits of not being able to see the screen!
Now back to that export...