Our middle tier opens several dedicated
connections. SQL statements are issued through these dedicated connections. If
Im running a stress test and I want to trace... what is the best method to use?
Just use a logon trigger and trace every session? then dig through it to look at
the top sql(which would be indicated by statspack).
any other suggestions would be helpful. I really
have no control over the middle tier or front end.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ryan
INET: ryan_oracle_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 22 2003 - 20:14:24 CST
