V$RESTORE_POINT displays information about restore points.
| Column | Datatype | Description |
|---|---|---|
SCN |
NUMBER |
Database SCN when the restore point is created |
DATABASE_INCARNATION# |
NUMBER |
Database incarnation number when the restore point is created |
GUARANTEE_FLASHBACK_DATABASE |
VARCHAR2(3) |
Yes or No |
STORAGE_SIZE |
NUMBER |
Approximate number of bytes of disk space currently tied up supporting this restore point. This will only be non-zero for guaranteed restore points. |
TIME |
TIMESTAMP(9) |
Wall-clock time when the restore point is created |
NAME |
VARCHAR2(128) |
Name of the restore point |