WTB: Oracle Visual SQL Debugger
Date: Sat, 18 Apr 2009 21:55:26 -0500
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-lReceived on Sat Apr 18 2009 - 21:55:26 CDT