V$TEMPEXTENTMAP - Information for all extents in all locally managed temporary tablespaces

Q.  In Viewing Tablespace Information, which view gives Information for all extents in all locally managed temporary tablespaces?
- Published on 04 Aug 15

a. V$TEMP_EXTENT_POOL
b. V$TEMP_EXTENT_MAP
c. V$TEMPSEG_USAGE
d. V$TEMP_SPACE_HEADER

ANSWER: V$TEMP_EXTENT_MAP
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - The following are a few data dictionary and dynamic performance views provide useful information about the tablespaces of a database.

    - V$TEMP_EXTENT_POOL - For locally managed temporary tablespaces: the state of temporary space cached and used for by each instance.

    - V$TEMP_EXTENT_MAP - Information for all extents in all locally managed temporary tablespaces.

    - V$TEMPSEG_USAGE - Describes temporary (sort) segment usage by user for temporary or permanent tablespaces.

    - V$TEMP_SPACE_HEADER - Shows space used/free for each tempfile.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)