Purpose
Provides a total of recovery log, data used by recovery per day for the previous eight days, and data used by load per day for the last eight days.
Syntax
RECOVERY LOG USAGE;Example
bcmadmin> recovery log usage; -------------------------------------- Recovery log and load data usage for last 8 days : 12/14, Recovery log Usage: 4 GB, Data load Usage: 856 GB 12/15, Recovery log Usage: 5 GB, Data load Usage: 163 GB 12/16, Recovery log Usage: 3 GB, Data load Usage: 342 GB 12/17, Recovery log Usage: 4 GB, Data load Usage: 945 GB 12/18, Recovery log Usage: 6 GB, Data load Usage: 645 GB 12/19, Recovery log Usage: 7 GB, Data load Usage: 145 GB 12/20, Recovery log Usage: 3 GB, Data load Usage: 243 GB 12/21, Recovery log Usage: 2 GB, Data load Usage: 234 GB -------------------------------------- Load size statistics for last 8 days : 12/14, Largest load by size: 14.305 MB, Largest load by row count: 100000 rows 12/15, Largest load by size: 25500 bytes, Largest load by row count: 500 rows 12/16, Largest load by size: 715.256 MB, Largest load by row count: 5000000 rows 12/17, Largest load by size: 255 bytes, Largest load by row count: 5 rows 12/18, Largest load by size: 7.153 MB, Largest load by row count: 50000 rows 12/19, Largest load by size: 2550 bytes, Largest load by row count: 50 rows 12/20, Largest load by size: 71.526 MB, Largest load by row count: 500000 rows 12/21, Largest load by size: 71 MB, Largest load by row count: 5000 rows Largest load seen since last sequencer start, by size: 0 bytes, by row count: 0 rows Largest load seen in last 8 days, by size: 715.256 MB, by row count: 5000000 rows
This table explains the output.
Output | Description |
---|---|
Recovery log and load data usage for last eight days | Shows:
|
Load size statistics for last eight days | Shows:
|