V$FLASHBACK_DATABASE_LOG [펌]

[출처] http://winslab.cnu.ac.kr/Oracle%20API/server.101/b10755/dynviews_1088.htm

V$FLASHBACK_DATABASE_LOG

V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.

Column	Datatype	Description
OLDEST_FLASHBACK_SCN	NUMBER	Lowest system change number (SCN) in the flashback data
OLDEST_FLASHBACK_TIME	DATE	Time of the lowest SCN in the flashback data
RETENTION_TARGET	NUMBER	Target retention time (in minutes)
FLASHBACK_SIZE	NUMBER	Current size (in bytes) of the flashback data
ESTIMATED_FLASHBACK_SIZE	NUMBER	Estimated size of flashback data needed for the current target retention