Wednesday , April 24 2024

Make Flashback Database Monitor

In today’s article, we will be cover about how to Make Flashback Database Monitor in Oracle.

We get the necessary information about flashback from 3 views.

INST_ID(NUMBER): Provides instance information.

OLDEST_FLASHBACK_SCN(NUMBER): It gives the oldest SCN that the database can receive with flashback.

OLDEST_FLASHBACK_TIME(DATE): It gives the oldest time the database can receive with flashback.

RETENTION_TARGET(NUMBER): Returns the value of DB_FLASHBACK_RETENTION_TARGET.

FLASHBACK_SIZE(NUMBER): Gives the instantaneous value of the flashback data.

ESTIMATED_FLASHBACK_SIZE(NUMBER): Provides information on how many estimated Flashback Logs in FRA are needed to meet DB_FLASHBACK_RETENTION_TARGET.

INST_ID(NUMBER):

BEGIN_TIME(DATE): Gives the begin time of the Flashback Log.

END_TIME(DATE): Returns the end time of the Flashback Log.

FLASHBACK_DATA(NUMBER): Gives the size of Flashback Data in the time period.

DB_DATA(NUMBER): Gives the size of the read and written data block in the time period.

REDO_DATA(NUMBER): Returns the size of Redo Data in the time period.

ESTIMATED_FLASHBACK_SIZE(NUMBER):

The sum of the BYTES here gives the size of the flashback logs in FRA.

Finally, information about the FRA field:

NAME(VARCHAR2(513)): Provides the name of the FRA field.

SPACE_LIMIT(NUMBER): Returns the value specified in DB_RECOVERY_FILE_DEST_SIZE.

SPACE_USED(NUMBER): Returns the space used in the FRA area.

SPACE_RECLAIMABLE(NUMBER): Returns the area that is reclaim (delete obselete, redundant, low-priority files).

NUMBER_OF_FILES(NUMBER): Returns the number of files.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories