Oracle DBA – A lifelong learning experience

  • Meta

  • Categories

  • Blog Stats

    • 1,634,354 hits
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 376 other followers

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;


————- ———-

6jcg0bbfm9z6p 1122

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.






One Response to “Using EM12C to see bind variables”

  1. Bryan said

    Hello ,

    Just a FYI. You can also review the bind variables by clicking on the “i” icon next to the SQL ID versus instead of clicking the View Report button.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: