Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 14
Newest
 Curious
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 66 votes cast
Mar
22
comment Oracle build_plan_xml visualizer
Thanks for your tip! I've updated the site to use the flash viewer behind the "ACTIVE" option (Check out this link to see it in action: sqlfiddle.com/#!4/ee7da/596). Had to do some serious mucking around with Oracle's HTML and JS to get it to work, but finally managed to do so. Thanks!
Mar
21
awarded  Benefactor
Mar
21
accepted Oracle build_plan_xml visualizer
Mar
20
revised Oracle build_plan_xml visualizer
added 294 characters in body
Mar
15
awarded  Promoter
Mar
13
comment Oracle build_plan_xml visualizer
@a_horse_with_no_name thanks I'll definitely look at that.
Mar
12
asked Oracle build_plan_xml visualizer
Mar
12
comment Interpreting SQL Server's Showplan XML
Justin - I cannot sing your praises high enough! Your code was super easy to integrate (a match made in heaven!), and just amazing results (as you can see). It's pretty rare that there is something out there that really is the perfect solution to a problem, but this was. Thanks so much!
Mar
12
accepted Interpreting SQL Server's Showplan XML
Mar
11
revised Interpreting SQL Server's Showplan XML
added 574 characters in body
Mar
9
comment Interpreting SQL Server's Showplan XML
@JNK - I've thought about that, but according to the MS docs (msdn.microsoft.com/en-us/library/ms180765.aspx) that option is deprecated. I figured I should go with the most preferred option. I suspected (and now see confirmed) that the XML option would afford more flexibility via manipulation, as well.
Mar
9
comment Interpreting SQL Server's Showplan XML
Wow @MartinSmith that's exactly what I'm after. Thanks a lot! If you want to put that down as an answer, I'll happily upvote and accept.
Mar
9
awarded  Commentator
Mar
9
comment Interpreting SQL Server's Showplan XML
@MartinSmith - by "seen one" do you mean seen a visual representation of the showplan xml? If so, see my update.
Mar
9
revised Interpreting SQL Server's Showplan XML
New option
Mar
9
asked Interpreting SQL Server's Showplan XML
Feb
8
awarded  Student
Feb
8
comment Trouble killing sessions then immediately dropping users in Oracle 11g XE
Thanks again Justin! DISCONNECT ... IMMEDIATE appears to work great! See my updated question text with the final script.
Feb
8
accepted Trouble killing sessions then immediately dropping users in Oracle 11g XE
Feb
8
revised Trouble killing sessions then immediately dropping users in Oracle 11g XE
added 948 characters in body