RE: EM 12c tablular plan on SQL Details scrollable?
Date: Wed, 11 Jul 2012 10:00:20 -0700 (PDT)
Message-ID: <f4189903-0013-445b-8899-749dbb837b55_at_default>
Dab nab it, take a week's holiday and your name gets bandied about everywhere! :)
AFAIK, there is no patch for this yet (there was an earlier bug like this that was fixed in BP1). Lyall's information is the most current I know of, so if this is causing you specific problems, probably the best thing to do at this stage is to log an SR and ask them to associate the bug number mentioned with it. If it's really problematic, then ask the support rep to escalate the bug.
Pete
Pete Sharman
Principal Product Manager
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449
"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!" Bruce Pihlamae, long term Oracle DBA
-----Original Message-----
From: Kellyn Pot'vin [mailto:kellyn.potvin_at_ymail.com]
Sent: Wednesday, 4 July 2012 5:05 AM
To: lyallbarbour_at_sanfranmail.com; oracle-l_at_freelists.org
Subject: Re: EM 12c tablular plan on SQL Details scrollable?
I am positive that Pete Sharman would say this has a patch. It came up in a discussion, may have even been here. I'd check with MOS, like I said, I believe there is a patch, but I did note that both my new BP1 EM12c environments do have the issue still.
Good luck!
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com> To: oracle-l_at_freelists.org
Sent: Tuesday, July 3, 2012 10:32 AM
Subject: Re: EM 12c tablular plan on SQL Details scrollable?
Not sure how to "reply" to an archived thread on the freelists site, but i did find an answer to Rich Jesse's question from last month. From metalink, there's a bug, but hasn't been fixed/tested yet. Nothing has happened since end of April looks like
*Bug 13968050: EXPLAIN PLAN (TABULAR) IN OEM 12C: NO SCROLL BAR*
*Bug Attributes*
*Type*B - Defect *Fixed in Product Version*-
*Severity*2 - Severe Loss of Service *Product Version*12.1.0.1.0
*Status*16 - Bug Screening/Triage *Platform*226
*Created*16-Apr-2012 *Platform Version*RED HAT ENTERPRISE LINUX 5
*Updated*23-Apr-2012 *Base Bug*-
*Database Version*11.2.0.3
*Affects Platforms*Generic
*Product Source*Oracle
Hey all,
In EM 12c, I'm trying to look at an explain plan of a particularly "fun" SQL by selecting the SQL from the Top Activity screen to go to the SQL Details, then choosing the "Plan" tab on the bottom pane, then switching over to the Tabular plan. However, I'm only able to see about 20 lines of any plan -- any more than that and I can see the next 1/2-line or so, but I can't figure out how to scroll the display.
I tried using Firefox 11 and IE 8, even though the Plan display is a Flash app, and as expected, both browsers work the same.
Anyone able to get this to work?
TIA!
Rich
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 11 2012 - 12:00:20 CDT