Re: help: How do you set event 10046 in this situation

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 23 Dec 2004 21:14:14 -0800
Message-ID: <41cba49e$1_2@127.0.0.1>

joe bayer wrote:

> One of our applications, runs much slower than before, I want to set 10046
> event on it. The problem is, I can not change the source code, which means
> I can not use "alter session set event...", and the application seems to log
> in and log off as several users during the whole process, the worse thing
> is, the application is using connection poo(it is a java application), so it
> is difficult for me to determine the sid and serial# of the application
> connection, could any one tell me how to set 10046 event in this case?
>
> Thanks for your help.

Use DBMS_SUPPORT.

Go to http://www.psoug.org
click on Morgan's Library
click on DBMS_SUPPORT
look up the installation information and the START_TRACE_IN_SESSION procedure.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

Received on Thu Dec 23 2004 - 23:14:14 CST