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

  • 0 posts edited
  • 0 helpful flags
  • 66 votes cast
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
Feb
8
comment Trouble killing sessions then immediately dropping users in Oracle 11g XE
Actually, having PMON wake more frequently sounds great to me. Remember, this is not a traditional environment for Oracle. My setup involves quickly building up and tearing down lots of "playground" databases. That is the whole use of this environment, so things that are normally a bad idea in real environments may not necessarily be so in mine. How would I adjust the PMON? BTW, I'm comparing all of this to the same types of tasks in MySQL, MSSQL, and PGSQL, and none of them have such an issue with killing sessions quickly.
Feb
8
comment Trouble killing sessions then immediately dropping users in Oracle 11g XE
BTW Justin - you're right, this is a strange problem to need to solve. You helped me answer another "strange" Oracle question on SO yesterday, so you may be wondering just what I'm up to. Well, I've built a site - sqlfiddle.com - that allows anyone to define their own databases and write their own queries, and then share that with others. One of the options for the backend is Oracle. You might even find this site useful for answering StackOverflow questions.