DATAFILE_BLOCKS The number of data blocks in the datafile
BLOCKS The number of data blocks written to the backup
BLOCK_SIZE The size of the data blocks in bytes
So BLOCKS * BLOCK_SIZE will give the number of bytes written for this
particular datafile and hence the size of the backup piece may be calculated.
SQL> select bs_key, sum(blocks*block_size)
from rc_backup_datafile
group by bs_key;
If you do not use catalog (controlfile):
SQL>select bs_key, sum(blocks*block_size)
from v$backup_datafile
group by bs_key;
The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour. Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Confi...
Comentários
Postar um comentário