Home » SQL & PL/SQL » SQL & PL/SQL » find bind values-not by tracing
find bind values-not by tracing [message #220248] Mon, 19 February 2007 17:48 Go to next message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

Hi,
i'm looking for a way to extract the values of binds for sqls running using bind variables for version 9.2.
thanks.
Re: find bind values-not by tracing [message #220296 is a reply to message #220248] Tue, 20 February 2007 02:27 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you want to look within your own session, you can look at v$sql_bind_data, but other than that, you'll be using Trace.
That's what it's there for.
Re: find bind values-not by tracing [message #220381 is a reply to message #220296] Tue, 20 February 2007 08:21 Go to previous message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

hi,
thanks for that, but let's say you're running statspack and
find a bas one, you want to work it out and often it's not running with the same parameters...

isn't there any other alternative like the capture view in 10g ?
shlomi.
Previous Topic: SYS.UTL_FILE
Next Topic: pagination (rownum) with the twist of reporting total count
Goto Forum:
  


Current Time: Sun Dec 04 22:42:35 CST 2016

Total time taken to generate the page: 0.15432 seconds