Oracle 视图 V$TEMP_CACHE_TRANSFER 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$TEMP_CACHE_TRANSFER提供有关系统中在内存间的缓存传输的信息。此试图用于监控缓存的传输和session间的缓存传输。
它的完全列名如下：
* SES_ID：发起传输的会话ID
* TOTAL_BYTES_TRANSFERRED：从一个缓存块传输的总字节数
* BLOCKS_READ：被传输的块或对象的总数
* BLOCKS_SENT：传输的缓存块总数
* TIME_SPENT：传输操作所花费的毫秒数
要使用此视图，您必须将授权语句提供给用户。为此，请使用以下命令：
GRANT SELECT ON SYS.V_$TEMP_CACHE_TRANSFER TO ;
一旦具有所需的权限，您就可以执行以下查询来观察缓存传输：
SELECT SES_ID, TOTAL_BYTES_TRANSFERRED, BLOCK_READ, BLOCK_SENT, TIME_SPENT
FROM V$TEMP_CACHE_TRANSFER;
官方英文解释
V$TEMP_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 temp 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 with NULL-to-Exclusive conversions; always |
|
|
|
Number of blocks with Shared-to-Exclusive conversions; always |
|
|
|
Number of blocks with NULL-to-Shared conversions; always |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
“V$INSTANCE_CACHE_TRANSFER”
-
“V$SEGMENT_STATISTICS”
