Database Administration (MOSC)

MOSC Banner

V$SQL_BIND_CAPTURE displays information on bind variables

edited Jan 23, 2014 7:47PM in Database Administration (MOSC) 3 commentsAnswered
In Oracle documentaion, it stats that:

DBA_HIST_SQLBIND displays historical information on bind variables used by SQL cursors. This view contains snapshots of V$SQL_BIND_CAPTURE.

It seems to me that DBA_HIST_SQLBIND doesn't store all historical bind variables information since it only contains snapshot of V$SQL_BIND_CAPTURE.

1. I wonder how often the snapshot has been taken?

2. Is there other way to find all historical bind variables information?

Thanks in advance.

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