Using EM12C to see bind variables
Posted by John Hallas on July 24, 2013
I have had these images for a few weeks but I was reminded to make a post after seeing Doug Burns present on using the monitoring tool in 12c at a UKOUG SIG meeting last week and he mentioned how you can see bind variables quite easily. Of course you could always work your way through a 10046 trace but I think you might find these options easier.
Firstly how to get them from the command line
select sql_id, sid from v$sql_monitor where sql_exec_id = 16779111;
select to_char(BINDS_XML) from v$sql_monitor where sid = 1122 and sql_id = ‘6jcg0bbfm9z6p’
222207/11/2013 00:00:0007/11/2013 00:00:0007/11/2013 00:00:0007/11/2013 00:00:0007/11/2013
Then we go the visual route and you decide which is the most usable method.