SQL Performance (MOSC)

MOSC Banner

V$SQL_SHARED_CURSOR retention

edited Apr 9, 2015 10:05AM in SQL Performance (MOSC) 6 commentsAnswered

I'd like to know what is the retention in V$SQL_SHARED_CURSOR ? And what is the retention for another performance V$  How and where is that retention set in database? I ask this question because I need to know the reason about high count versions in a statemente reported in AWR report between old snap_ids

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