Does anyone have any good admin queries (SQL) that can be run to report
on current server stats. Simiar results to "onstat -u"
I can query the syssessions view on sysmaster and have trolled the
newsgroups and web for useful queries. A lot of the reporting scripts
where Unix shell scripts but I need to run the queries over JDBC using
an awesome JAVA sql client I have found. These reports may be included
in an JAVA web application if I can prove them to be useful.
I am specifically not mentioning any of the SQl statements I already