Which data dictionary view could you query to display the number of blocks used by a table in each datafile ?
DBA_EXTENTS OWNER VARCHAR2(30) SEGMENT_NAME VARCHAR2(81) PARTITION_NAME VARCHAR2(30) SEGMENT_TYPE VARCHAR2(17) TABLESPACE_NAME VARCHAR2(30) EXTENT_ID NOT NULL NUMBER FILE_ID NOT NULL NUMBER BLOCK_ID NOT NULL NUMBER BYTES NUMBER BLOCKS NOT NULL NUMBER RELATIVE_FNO NOT NULL NUMBER • An User account has been locked by the system.
Related Questions
- Which data dictionary category would a user with the SELECT ANY TABLE privilege query to find the owner of the PRODUCT1 table?
- Which data dictionary view could you query to display the number of blocks used by a table in each datafile ?
- Which data dictionary view could a user query to display the number of bytes charged to their username?
