Oracle 视图 V$CLONEDFILE 官方解释,作用,如何使用详细说明
本站中文解释
V$CLONEDFILE是Oracle数据库查看备份进度和状态的视图。它显示用于耗时较长且会破坏性能的备份操作的文件信息,包括文件名、大小、路径以及复制进度等。通过它监控备份操作,可以及时知道备份任务的进度,并且发现有问题及时修复。
使用V$CLONEDFILE视图,可以通过以下SQL语句查询备份进度:
SELECT file_name 需要备份的文件名,
bytes_remaining 还剩余的字节,
bytes_copied 已经复制的字节
FROM v$clonedfile;
官方英文解释
V$CLONEDFILE
provides CloneDB file information.
Column | Datatype | Description |
---|---|---|
|
|
Snapshot/master file name. This file is the master file from the master database. The snapshot file is also sometimes referred to as the srcfile. |
|
|
CloneDB file name. This file is the cloned file (of master file) which resides in the current (cloned database). The cloned file is sometimes referred to as the destfile. |
|
|
Number of blocks reads to the snapshot file (master file) |
|
|
Number of read requests to the snapshot file (master file) |
|
|
File number of the cloned file |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Amount of space allocated in blocks in the file system. This is less than or equal to the actual file size. |
Note:
When this view is queried in an Oracle Database environment, rows are returned for every opened file, even those without a parent file backing them (in those cases the column is empty/NULL).
In an Oracle ASM environement, rows are returned for files that an Oracle ASM instance has mounted in disk groups only if those files are children (a clonefile) of a parent snapshot file.