Database Administration (MOSC)

MOSC Banner

Can flashback query the v$views?

edited Mar 12, 2009 10:28AM in Database Administration (MOSC) 2 commentsAnswered
Since v$ views query memory structures (I think) and flashback ("AS OF <timestamp>") reads from logs, will flashback queries on v$views retrieve old data correctly?  This is in Oracle 9.2 but I would pose the question generically for 10 and 11 as well.  In this case, I am interested in v$session, v$sysstat and v$open_cursor.  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