YES, you can. During a FLASHBACK DATABASE operation you can query V$SESSION_LONGOPS from another session to see the progress of the flashback.

The FLASHBACK DATABASE operation has two distinct phases: the actual flashback and the media recovery that happens afterwards to bring the database to a consistent state.

While the actual flashback is running you’ll see the following message in V$SESSION_LONGOPS, on Oracle 11gR2:

Flashback Database: Flashback Data Applied : 238 out of 282 Megabytes DONE

During the media recovery, the following messages will be seen:

• Media Recovery: Redo Applied : 263 out of 0 Megabytes done
• Media Recovery: Average Apply Rate : 1164 out of 0 KB/sec done
• Media Recovery: Last Applied Redo : 626540 out of 0 SCN+Time done
• Media Recovery: Elapsed Time : 232 out of 0 Seconds done
• Media Recovery: Active Time : 116 out of 0 Seconds done
• Media Recovery: Active Apply Rate : 1859 out of 0 KB/sec done
• Media Recovery: MAXIMUM Apply Rate : 1859 out of 0 KB/sec done
• Media Recovery: Log Files : 15 out of 0 Files done
• Media Recovery: Apply Time per Log : 7 out of 0 Seconds done

Yes, you can. During a FLASHBACK DATABASE operation you can query V$SESSION_LONGOPS from another session to see the progress of the flashback.

The FLASHBACK DATABASE operation has two distinct phases: the actual flashback and the media recovery that happens afterwards to bring the database to a consistent state.

While the actual flashback is running you’ll see the following message in V$SESSION_LONGOPS, on Oracle 11gR2:

Flashback Database: Flashback Data Applied : 238 out of 282 Megabytes done

During the media recovery, the following messages will be seen: