Oracle 视图 V$FILE_CACHE_TRANSFER 官方解释，作用，如何使用详细说明
本站中文解释
视图
V$FILE_CACHE_TRANSFER 视图是 Oracle 数据库中显示文件缓存传输的一条系统视图。此视图显示文件缓存由磁盘操作和可选 I/O 磁盘转储使用情况。
此视图有三列:
1. FILE#：指明缓存传输文件的编号。
2. CACHE_WRITES：表示缓存操作从存储上读取文件数。
3. CACHE_READS：表示缓存操作将文件写入存储的次数。
该视图有两个主要用途:
1. 它可以帮助开发者确定 I/O 压力：通过查看文件缓存传输，可以确定服务器或应用程序中对 I/O 的压力，从而允许开发者深入研究I/O 操作所涉及的问题。
2. 它可以让开发者优化存储系统：查看文件缓存传输量可以帮助开发者决定服务器或应用程序中是否需要调整存储系统以减轻 I/O 压力。
要使用V$FILE_CACHE_TRANSFER 视图，可以执行以下查询：
SELECT file#, cache_writes, cache_reads FROM v$file_cache_transfer;
官方英文解释
V$FILE_CACHE_TRANSFER is deprecated. The information that was provided in this view is now provided in the V$INSTANCE_CACHE_TRANSFER and V$SEGMENT_STATISTICS views.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Number of the data file |
|
|
|
Number of blocks with Exclusive-to-NULL conversions; always |
|
|
|
Number of Exclusive-to-NULL forced writes; always |
|
|
|
Number of Exclusive-to-NULL blocks converted to CR; always |
|
|
|
Number of blocks with Exclusive-to-Shared conversions; always |
|
|
|
Number of Exclusive-to-Shared forced writes; always |
|
|
|
Number of blocks with Shared-to-NULL conversions; always |
|
|
|
Number of Shared-to-NULL blocks converted to CR; always |
|
|
|
Number of reuse blocks cross-instance calls; always |
|
|
|
Number of blocks written due to reuse blocks cross-instance calls; always |
|
|
|
Number of blocks marked as flushed due to reuse blocks cross-instance calls; always |
|
|
|
Number of blocks with NULL-to-Exclusive conversions; always |
|
|
|
Number of blocks with Shared-to-Exclusive conversions; always |
|
|
|
Number of blocks with NULL-to-Shared conversions; always |
|
|
|
Number of CR blocks received; always |
|
|
|
Number of current blocks received; always |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
“V$INSTANCE_CACHE_TRANSFER”
-
“V$SEGMENT_STATISTICS”
