CODEWITHSUNDEEP
sqloracle-databasedatabase-performanceawr
trinity
trinity

Reputation: 10484

Extract multiple binds at once

I just found I can use extract_binds to get binds-info from raw bind data (like the one in v$sql, dba_hist_sqlstat etc)

select
    listagg(value_string, ',') within group (order by position)
from
    table(dbms_sqltune.extract_binds(raw_bind_data))

When I have to get info on many many raw bind-data, can I avoid running this in a loop? Can I pass more than one raw bind to this function? Should I use union-all or is there a better way? (Better in terms of time taken, efficiency, etc.)

Upvotes: 0

Views: 590

Answers (0)

Related Questions