WTB: Oracle Visual SQL Debugger

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Sat, 18 Apr 2009 21:55:26 -0500
Message-ID: <7b8774110904181955l27c83eaq3371c61e43adb973_at_mail.gmail.com>



Good day, list,

When I was taking a C++ class in college, for a short time we had access to a really powerful X debugger (running on HPUX) that not only allowed one to step through code but depicted the state of any watched objects (variables, pointers, classes, etc) as a linked box with all relevant details (addresses, values, members, etc). I really miss that tool.

Is there anything related for stepping through SQL? *Not *PL/SQL, mind you. I am looking for a tool that can show me, graphically, how access predicates get rowids out of an index, which are then passed up to a table access with a filter predicate, then passed into a nested loop operation as a driving rowsource which dictates the rows wanted from the 2nd child operation. I want to see data; which rows were gotten and why, one row at a time. I am sure we have all see powerpoint slides that show us this detail one painful click at a time, but what about a run-time tool? Direct memory attach programs come to mind, but they usually do not cater to the same audience for some strange reason (*grin*). The audiences I have in mind are in classroom settings, teaching Jr. DBAs and developers; I doubt any experienced DBA would admit to wanting something like this. But I do. =)

PS - I did look around on google, but the hits were not promising. I was not able to find much information about Visual SQL 4.2 (seems old), nor the MS Visual Studio series - nothing in my quick driveby on the information superhighway really satisfied me.

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 18 2009 - 21:55:26 CDT

Original text of this message