Oracle DBA – A lifelong learning experience

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;

SQL_ID SID

————- ———-

6jcg0bbfm9z6p 1122

select to_char(BINDS_XML) from v$sql_monitor where sid = 1122 and sql_id = ‘6jcg0bbfm9z6p’

TO_CHAR(BINDS_XML)

——————————————————————————–

222207/11/2013 00:00:0007/11/2013 00:00:0007/11/2013 00:00:0007/11/2013 00:00:0007/11/2013

00:00:00

Then we go the visual route and you decide which is the most usable method.

sq1

sq2

sq3

sq4

About these ads

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:

WordPress.com Logo

You are commenting using your WordPress.com 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

 
Follow

Get every new post delivered to your Inbox.

Join 196 other followers

%d bloggers like this: