>Is there any way I can use "set showplan", "statistics_io" and
>"statistics time" to monitor queries and stored procedures that are
>run from within a GUI "canned" application (Platinum Financials). I
>am not sure what queries and stored procedures are used during the
>execution of different jobs from within the application. I have some
>experience working with Oracle's trace files and TKPROF. With Oracle
>I am able to have the user log into the canned app which produces a
>trace file matching their SID which will trace all the sql thrown at
>the database. With "set showplan" it seems that I would have to some
>how pull out all the SQL an run it manually !!!
application sends to the server.
I specifically DO NOT give anyone permission to use my email adress
for any commercial or non commercial mailings. I will bill everyone
who sends me this kind of mail for wasting my time. Under Dutch law,
people who don't let me know they disagree with such a bill are obliged
to pay it.
Attention: remove extra anti-spam info at end of reply adress