Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Sunday, April 18, 2010

Backup Size

Query the V$RMAN_BACKUP_JOB_DETAILS view for the size of the backups in an
RMAN session.
If you run BACKUP DATABASE, then
V$RMAN_BACKUP_JOB_DETAILS.OUTPUT_BYTES shows the total size of backup
sets written by the backup job for the database that you are backing up. To view
backup set sizes for all registered databases, query
RC_RMAN_BACKUP_JOB_DETAILS.
The following query shows the backup job speed ordered by session key, which is
the primary key for the RMAN session. The columns in_sec and out_sec
display the data input and output per second.
COL in_size FORMAT a10
COL out_size FORMAT a10
SELECT SESSION_KEY,
INPUT_TYPE,
COMPRESSION_RATIO,
INPUT_BYTES_DISPLAY in_size,
OUTPUT_BYTES_DISPLAY out_size
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;
The following sample output shows the speed of the backup jobs:
SESSION_KEY INPUT_TYPE COMPRESSION_RATIO IN_SIZE OUT_SIZE
----------- ------------- ----------------- ---------- ----------
10 DATAFILE FULL 1 602 50M 602.58M
17 DB FULL 1.137 634.80M 558.13M

No comments: