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

On Apr 11, 11:09 am, salkaw..._at_yahoo.com 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