Re: EM 12c tablular plan on SQL Details scrollable?
Date: Wed, 11 Jul 2012 10:24:08 -0700 (PDT)
Come on, Pete- It's good for you- builds character! Seems like a common bug that many want fixed...Maybe you just need to work faster on that patch for it... :D (Suddenly Kellyn is very happy he is back in Australia and not visiting the states... :D)
Senior Technical Consultant
From: Peter Sharman <pete.sharman_at_oracle.com> To: kellyn.potvin_at_ymail.com; lyallbarbour_at_sanfranmail.com; oracle-l_at_freelists.org Sent: Wednesday, July 11, 2012 11:00 AM
Subject: RE: EM 12c tablular plan on SQL Details scrollable?
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.
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
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.
Senior Technical Consultant
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*
*Type*B - Defect *Fixed in Product Version*-
*Severity*2 - Severe Loss of Service *Product Version*126.96.36.199.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*-
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?
-- http://www.freelists.org/webpage/oracle-l -- 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:24:08 CDT