DB OPTimize

Tag Archive: 11.2

Bind variables in Oracle 11.2

A bit of an history before I begin…
Oracle 10.2 had exposed bind variables values passed to a SQL statement via a new view named┬áV$SQL_BIND_CAPTURE.┬áNevertheless, to limit the overhead, Oracle captured the bind at most every 15 minutes for a given cursor. (more…)