V$TABLESPACE view shows Name & number of all tablespaces from control file - Oracle Tablespaces

Q.  Which view shows the Name and number of all tablespaces from the control file in Viewing Tablespace Information?
- Published on 04 Aug 15

a. DBA_TABLESPACE_GROUPS
b. V$TABLESPACE
c. V$DATAFILE
d. DBA_EXTENDS,USER_EXTENDS

ANSWER: V$TABLESPACE
 

    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$TABLESPACE - Name and number of all tablespaces from the control file.

    - DBA_TABLESPACE_GROUPS - Displays the tablespace groups and the tablespaces that belong to them.

    - V$DATAFILE - Information about all datafiles, including tablespace number of owning tablespace.

    - DBA_EXTENTS, USER_EXTENTS - Information about data extents within all (or user accessible) tablespaces.

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.)