Re: Digging in to trace files

hpuxrac wrote:
> Ed you are probably aware that even though the server is running MTS
> you can create a dedicated connection when you need to correct?
>

Yes, and that is something I still need to address. I know I can set up separate 'dedicated mode' and 'shared mode' entries in tnsnames, and that's what I've been doing for my own testing. However, the app uses JDBC Thin Client, and their connection specification data is held in some sort of resource file controlled by the administrator of the middleware. I haven't yet gone down that road to see if there is some way of specifying to the app to use different types of connections for different types of work. What is known is that the app that drove us to shared server by requiring a high number of concurrent sessions ALSO has some lengthy batch processing. (There are several apps impacting this db -- it is only used directly by the middleware to hold 'persistence data' for several web-based apps.)

> Most batch jobs should probably be running dedicated anyway and the
> ability to create and then trace a dedicated session to help in the
> debugging is very handy.
>
> *** But I haven't tried Egors utility ( which is EXCELLENT !) on an MTS
> system ... this might help somewhat but there are issues with getting
> all the files depending on number of servers.

Thanks. I'll take a look at it. Received on Tue Aug 16 2005 - 07:38:52 CDT