V$TEMP_ EXTENT _POOL displays the state of temporary space cached and used for the instance. Note that loading of the temporary space cache is lazy and that instances can be dormant. Number of extents that have been cached. Number of extents that are actually being used.
10 rows · V$TEMP_ EXTENT _POOL. This view displays the state of temporary space cached and.
10 rows · V$TEMP_ EXTENT _POOL. V$TEMP_ EXTENT _POOL displays the state of temporary.
V$TEMP_ EXTENT _POOL. V$TEMP_ EXTENT _POOL displays the state of temporary space cached and used for the instance. Note that loading of the temporary space cache is lazy and that instances can be dormant. The ID of the container to which the data pertains. Possible values include:, V$TEMP_ EXTENT _POOL displays the state of temporary space cached and used for the instance. Note that loading of the temporary space cache is lazy and that instances can be dormant. Column, This makes a soft reservation on that space by a user or a session. The bytes reserved like this is called cached bytes. You can monitor this cached bytes from V$TEMP_ EXTENT _POOL. Cached bytes and used bytes will be equal at the beginning of a session but latter there may be huge difference in between.
Answer: in RAC, the gv$temp_extent_pool view gives information about the bytes and blocks that are cached from the temp tablespace into the RAC global cache: select. blocks_cached, blocks_used, bytes_cached, bytes_used, extents_cached, extents_used, file_id,
