Language:EN
Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
these metrics include the current space used all f

These metrics include the current space used all flashback logs

Monitoring Flashback Database (continued)

BEGIN_TIM END_TIME FLASHBACK_DATA DB_DATA REDO_DATA EST_FB_SZE--------- --------- -------------- ---------- ---------- ----------12-FEB-04 12-FEB-04 16384 0 24576 0 12-FEB-04 12-FEB-04 6594560 7471104 1533440 815923200 12-FEB-04 12-FEB-04 17235968 12361728 5150720 839467008 12-FEB-04 12-FEB-04 311648256 37249024 10272768 855195648

NAME: Flash recovery area name, indicating location string

SPACE_LIMIT: Disk limit specified in the DB_RECOVERY_FILE_DEST_SIZE

NUMBER_OF_FILES: Number of files

SQL> SELECT name, space_limit AS quota,
2 space_used AS used,
3 space_reclaimable AS reclaimable, 4 number_of_files AS files
5 FROM v$recovery_file_dest ;

NAME QUOTA USED RECLAIMABLE FILES
-----------
/u01/flash_recovery_area 5368709120 2509807104 203386880 226

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Frank Brown

PageId: ELI0B97B26