Re: how can I get bind values for another session? There are conditions..

From: sybrandb <>
Date: Fri, 11 Apr 2008 03:10:13 -0700 (PDT)
Message-ID: <>

On Apr 11, 11:09 am, wrote:
> Hello,
> I have a question about oracle10g. How can I get the bind variables?
> Here is a description of the situation:
> 1. A java process starts a stored procedure via jdbc.
> 2. The procedure has a number of bind variables as input.
> 3. The java process does NOT commit but just sleeps.
> 4. I can't change the statistics_level (it must be typical).
> 5. I cannot predict when this happens and I cannot trace all sessions
> from that user due to performance requirements.
> Can I use oradebug somehow?
> Thanks for your help!

Do you really need to post this on every forum you can spell? Why don't you just:

select * from dict where table_name like '%BIND%' and read the docs?

Sybrand Bakker
Senior Oracle DBA
Received on Fri Apr 11 2008 - 05:10:13 CDT

Original text of this message