【效能優化】查詢繫結變數的sql語句

楊奇龍發表於2010-09-07

select value_string
  from table (select dbms_sqltune.extract_binds(aa.bind_data)
                from v$sql aa
               where aa.hash_value in
                     (select hash_value
                        from v$sql_plan a
                       where a.plan_hash_value = '767762637'));

                                                                                             ----yellow 提供;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-672900/,如需轉載,請註明出處,否則將追究法律責任。

相關文章