【文章內容簡介】 ning the segment headBLOCK_IDNUMBERNOT NULLID number of the block containing the segment headerINITIAL_EXTENTNUMBERInitial extent size in bytesNEXT_EXTENTNUMBERSecondary extent size in bytesMIN_EXTENTSNUMBERNOT NULLMinimum number of extentsMAX_EXTENTSNUMBERNOT NULLMaximum number of extentPCT_INCREASENUMBERPercent increase for extent sizeSTATUSVARCHAR2(16)Rollback segment statusINSTANCE_NUMVARCHAR2(40)Rollback segment owning Real Application Clusters instance numberRELATIVE_FNONUMBERNOT NULLRelative file number of the segment headerdba_ts_quotas ColumnDatatypeNULLDescriptionTABLESPACE_NAMEVARCHAR2(30)NOT NULLTablespace nameUSERNAMEVARCHAR2(30)NOT NULLUser with resource rights on the tablespaceBYTESNUMBERNumber of bytes charged to the userMAX_BYTESNUMBERUser39。s quota in bytes, or 1 if no limitBLOCKSNUMBERNOT NULLNumber of Oracle blocks charged to the userMAX_BLOCKSNUMBERUser39。s quota in Oracle blocks, or 1 if no limitDROPPEDVARCHAR2(3)Whether the tablespace has been droppeddba_free_spaceColumnDatatypeNULLDescriptionTABLESPACE_NAMEVARCHAR2(30)Name of the tablespace containing the extentFILE_IDNUMBERFile identifier number of the file containing the extentBLOCK_IDNUMBERStarting block number of the extentBYTESNUMBERSize of the extent (in bytes)BLOCKSNUMBERSize of the extent (in Oracle blocks)RELATIVE_FNONUMBERRelative file number of the file containing the extentdba_profilesColumnDatatypeNULLDescriptionPROFILEVARCHAR2(30)NOT NULLProfile nameRESOURCE_NAMEVARCHAR2(32)NOT NULLResource nameRESOURCE_TYPEVARCHAR2(8)Indicates whether the resource profile is a KERNEL or a PASSWORD parameterLIMITVARCHAR2(40)Limit placed on this resource for this profiledba_sys_privs ColumnDatatypeNULLDescriptionGRANTEEVARCHAR2(30)NOT NULLGrantee name, user, or role receiving the grantUSERNAMEVARCHAR2(30)Name of the current userPRIVILEGEVARCHAR2(40)NOT NULLSystem privilegeADMIN_OPTIONVARCHAR2(3)Grant was with the ADMIN optiondba_tab_privsColumnDatatypeNULLDescriptionGRANTEEVARCHAR2(30)NOT NULLName of the user to whom access was grantedOWNERVARCHAR2(30)NOT NULLOwner of the objectTABLE_NAMEVARCHAR2(30)NOT NULLName of the objectGRANTORVARCHAR2(30)NOT NULLName of the user who performed the grantPRIVILEGEVARCHAR2(40)NOT NULLPrivilege on the objectGRANTABLEVARCHAR2(3)Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)HIERARCHYVARCHAR2(3)Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)dba_col_privsColumnDatatypeNULLDescriptionGRANTEEVARCHAR2(30)NOT NULLName of the user to whom access was grantedOWNERVARCHAR2(30)NOT NULLOwner of the objectTABLE_NAMEVARCHAR2(30)NOT NULLName of the objectCOLUMN_NAMEVARCHAR2(30)NOT NULLName of the columnGRANTORVARCHAR2(30)NOT NULLName of the user who performed the grantPRIVILEGEVARCHAR2(40)NOT NULLPrivilege on the columnGRANTABLEVARCHAR2(3)Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)dba_role_privsColumnDatatypeNULLDescriptionGRANTEEVARCHAR2(30)Name of the user or role receiving the grantGRANTED_ROLEVARCHAR2(30)NOT NULLGranted role nameADMIN_OPTIONVARCHAR2(3)Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO)DEFAULT_ROLEVARCHAR2(3)Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO)dba_audit_trailColumnDatatypeNULLDescriptionOS_USERNAMEVARCHAR2(255)Operating system login username of the user whose actions were auditedUSERNAMEVARCHAR2(30)Name (not ID number) of the user whose actions were auditedUSERHOSTVARCHAR2(128)Client host machine nameTERMINALVARCHAR2(255)Identifier of the user39。s terminalTIMESTAMPDATEDate and time of the creation of the audit trail entry (date and time of user login for entries created by AUDIT SESSION) in the local database session time zoneOWNERVARCHAR2(30)Creator of the object affected by the actionOBJ_NAMEVARCHAR2(128)Name of the object affected by the actionACTIONNUMBERNOT NULLNumeric action type code. The corresponding name of the action type is in the ACTION_NAME column.ACTION_NAMEVARCHAR2(28)Name of the action type corresponding to the numeric code in the ACTION columnNEW_OWNERVARCHAR2(30)Owner of the object named in the NEW_NAME columnNEW_NAMEVARCHAR2(128)New name of the object after a RENAME or the name of the underlying objectOBJ_PRIVILEGEVARCHAR2(16)Object privileges granted or revoked by a GRANT or REVOKE statementSYS_PRIVILEGEVARCHAR2(40)System privileges granted or revoked by a GRANT or REVOKE statementADMIN_OPTIONVARCHAR2(1)Indicates whether the role or system privilege was granted with the ADMIN optionGRANTEEVARCHAR2(30)Name of the grantee specified in a GRANT or REVOKE statementAUDIT_OPTIONVARCHAR2(40)Auditing option set with the AUDIT statementSES_ACTIONSVARCHAR2(19)Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: None S Success F Failure B BothLOGOFF_TIMEDATEDate and time of user log offLOGOFF_LREADNUMBERLogical reads for the sessionLOGOFF_PREADNUMBERPhysical reads for the sessionLOGOFF_LWRITENUMBERLogical writes for the sessionLOGOFF_DLOCKVARCHAR2(40)Deadlocks detected during the sessi