Database Backup and Recovery (MOSC)

MOSC Banner

flashback buf free by RVWR

edited Nov 17, 2016 12:25AM in Database Backup and Recovery (MOSC) 3 commentsAnswered

Hi,

The AWR is showing 207528 waits on flashback buf free by RVWR

resulting in Total Wait Time (sec)= 174.6K and Wait Avg(ms) = 841 amounting to  % DB time

=36.6

Database information :

select * from gv$version;

--11.2.0.4.0 - 64bit

select * from v$FLASH_RECOVERY_AREA_USAGE;

--FLASHBACK LOG 55.49(%space used) 0 1498(no of files)

select min(first_time), max(first_time) from gV$FLASHBACK_DATABASE_LOGFILE;

--   MIN(FIRST_TIME) MAX(FIRST_TIME)

-- 10/26/2016 3:25:11 PM 11/12/2016 9:06:28 AM

select count(1) from gV$FLASHBACK_DATABASE_LOGFILE;

--4494 (no of files) 7983857664(bytes)/file = 32.63TB

select name, value from gv$parameter where name like '%recovery%';

-- db_recovery_file_dest_size 21474836480000 (20TB)

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