I haven't looked at the link you posted but, generally speaking, yes you
can implement these commands programmatically.
Obviously (?):
1 - you would want to be able to configure this on-the-fly; there's a
performance hit for generating/sending all that text to the client, so only
use it when trying to track down a performance issue
2 - the client has to be (re)configured/(re)written to handle the results
of these commands
badbrownie@gmail.com wrote:
> By the way is it possible to use 'show plan' programmatically? I
> understand how it can be used from the console but I need to use it
> from within java (and parse its results programmatically too of course)
>