Re: how can I get bind values for another session? There are conditions..
Date: Fri, 11 Apr 2008 03:10:13 -0700 (PDT)
On Apr 11, 11:09 am, salkaw..._at_yahoo.com wrote:
> 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 DBAReceived on Fri Apr 11 2008 - 05:10:13 CDT