select sql_id, name, position,value_string from v$sql_bind_capture where sql_id='
Friday, April 03, 2009
How to find value used in bind variables
If sql statement used bind variables is still in shared pool, and you have Oracle 10g, you can find what values variables have in the following way:
select sql_id, name, position,value_string from v$sql_bind_capture where sql_id='';
select sql_id, name, position,value_string from v$sql_bind_capture where sql_id='
Subscribe to:
Post Comments (Atom)
1 comment:
Can anyone recommend the top performing RMM program for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central managed services software
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!
Post a Comment