DBA_SEGMENTS

SQL> DESC DBA_SEGMENTS

 Name                                     Null?    Type
 ------------------------------------------------- ----------------------------
 OWNER                                             VARCHAR2(30)
 SEGMENT_NAME                                       VARCHAR2(81)
 PARTITION_NAME                                    VARCHAR2(30)
 SEGMENT_TYPE                                      VARCHAR2(18)
 SEGMENT_SUBTYPE                                   VARCHAR2(10)
 TABLESPACE_NAME                                    VARCHAR2(30)
 HEADER_FILE                                        NUMBER
 HEADER_BLOCK                                       NUMBER
 BYTES                                             NUMBER
 BLOCKS                                             NUMBER
 EXTENTS                                           NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                                        NUMBER
 MAX_EXTENTS                                        NUMBER
 MAX_SIZE                                          NUMBER
 RETENTION                                         VARCHAR2(7)
 MINRETENTION                                       NUMBER
 PCT_INCREASE                                       NUMBER
 FREELISTS                                         NUMBER
 FREELIST_GROUPS                                    NUMBER
 RELATIVE_FNO                                       NUMBER
 BUFFER_POOL                                        VARCHAR2(7)

No comments:

Post a Comment