Database - RAC/Scalability (MOSC)

MOSC Banner

Bind Variable from DBA_HIST% views

edited Jun 11, 2015 10:06AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Is there a way I can find the values of :b1, :b2 and :b3 from DBA_HIST_% VIEWS ?

SQL>  select count(*) from DBA_HIST_SQL_BIND_METADATA where sql_id='4txrv0qyh414j';

  COUNT(*)
----------
         3

SQL> select * from  DBA_HIST_SQL_BIND_METADATA where sql_id='4txrv0qyh414j';

      DBID SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH
---------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ----------
1801217779 4txrv0qyh414j :B3                                     1                       1 VARCHAR2(32)              873                               32
1801217779 4txrv0qyh414j :B2                                     2                       1 VARCHAR2(32)              873                               32
1801217779 4txrv0qyh414j :B1                                     3                       2 NUMBER                                                      22

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center