Home » RDBMS Server » Server Administration » Viewing Bind Variable Values on the Database
Viewing Bind Variable Values on the Database [message #370648] Fri, 14 January 2000 14:42 Go to next message
mvicchy
Messages: 1
Registered: January 2000
Location: Denver
Junior Member
Is there a way to view bind variable values on the server? I can see the sql, but I'd really like to know what values are being bound to it. Help!
Re: Viewing Bind Variable Values on the Database [message #370708 is a reply to message #370648] Fri, 21 January 2000 08:50 Go to previous message
schnizer
Messages: 3
Registered: January 2000
Junior Member
The actual values of the bind variables can bee seen in the view sys.v_$SQL_BIND_DATA,
but unfortunately every session can see only the bind values of their own session.
I think this is because the bind values are stored in the private space of the session and not in system global area.
If you find a way to see the values of bind variables of other session's, please let me know.
so long
Previous Topic: REF CURSOR Related
Next Topic: Performance with general selecetion statments
Goto Forum:
  


Current Time: Tue Apr 16 16:19:00 CDT 2024