【正文】 erOS_PROCESSVARCHAR2(16)Client host machine nameTERMINALVARCHAR2(255)Logical writes for the sessionLOGOFF_DLOCKVARCHAR2(40)Global user identifier for the user, if the user has logged in as an enterprise userINSTANCE_NUMBERNUMBER DOMAINTABLE_OWNERVARCHAR2(30)NOT NULLOwner of the indexed objectTABLE_NAMEVARCHAR2(30)NOT NULLName of the indexed objectTABLE_TYPECHAR(5)Size of the initial extentNEXT_EXTENTNUMBERNumber of freelist groups allocated to this segmentPCT_FREENUMBERIndicates the amount of order of the rows in the table based on the values of the index. Number of instances across which the indexes to be scannedPARTITIONEDVARCHAR2(3)Indicates whether statistics were entered directly by the user (YES) or not (NO)DURATIONVARCHAR2(15)
。Date on which this index was most recently analyzedDEGREEVARCHAR2(40)Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.AVG_DATA_BLOCKS_PER_KEY*NUMBERColumn ID of the last column to be included in indexorganized table primary key (nonoverflow) index. This column maps to the COLUMN_ID column of the *_TAB_COLUMNS data dictionary views.FREELISTSNUMBERInitial number of transactionsMAX_TRANSNUMBER FUNCTIONBASED NORMALTimestamp of the creation of the audit trail entry (timestamp of user login for entries created by AUDIT SESSION) in UTC (Coordinated Universal Time) time zonePROXY_SESSIONIDNUMBERLogical reads for the sessionLOGOFF_PREADNUMBEROperating system login username of the user whose actions were auditedUSERNAMEVARCHAR2(30)Proxy session serial number, if an enterprise user has logged in through the proxy mechanismGLOBAL_UIDVARCHAR2(32)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: for none, S for success, F for failure, and B for both).COMMENT_TEXTVARCHAR2(4000)Identifier of the user39。SQL text of the querydba_stmt_audit_optsColumnDatatypeNULLDescriptionUSER_NAMEVARCHAR2(30)Timestamp of the creation of the audit trail entry (timestamp of user login for entries created by AUDIT SESSION) in UTC (Coordinated Universal Time) time zonePROXY_SESSIONIDNUMBER PROXY Client was authenticated by another user。Date and time of user log offLOGOFF_LREADNUMBERIndicates whether the role or system privilege was granted with the ADMIN optionGRANTEEVARCHAR2(30)Date 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)Name of the user or role receiving the grantGRANTED_ROLEVARCHAR2(30)NOT NULLGranted role nameADMIN_OPTIONVARCHAR2(3)Relative file number of the file containing the extentdba_profilesColumnDatatypeNULLDescriptionPROFILEVARCHAR2(30)NOT NULLProfile nameRESOURCE_NAMEVARCHAR2(32)NOT NULLResource nameRESOURCE_TYPEVARCHAR2(8)User39。Initial extent size in bytesNEXT_EXTENTNUMBERTablespacerelative file numberAUTOEXTENSIBLEVARCHAR2(3) ONLINEMaximum file size in blocksINCREMENT_BYNUMBER NOT APPLY Tablespace is not an undo tablespaceBIGFILEVARCHAR2(3) UNIFORM TEMPORARYLOGGINGVARCHAR2(9)Minimum extent size for this tablespaceSTATUSVARCHAR2(9)Starting block number of the extentBYTESNUMBERWhether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N)dba_extentsColumnDatatypeNULLDescriptionOWNERVARCHAR2(30)Maximum number of extents allowed in the segmentPCT_INCREASENUMBERID of the file containing the segment headerHEADER_BLOCKNUMBERDate of expiration of the accountDEFAULT_TABLESPACEVARCHAR2(30)NOT NULLDefault tablespace for dataTEMPORARY_TABLESPACEVARCHAR2(30)NOT NULLName of the default tablespace for temporary tables or the name of a tablespace groupCREATEDDATENOT NULLUser creation datePROFILEVARCHAR2(30)NOT NULLUser resource profile nameINITIAL_RSRC_CONSUMER_GROUPVARCHAR2(30) LOCKED(TIMED)Oracle 常用系統(tǒng)表dba_ 開頭dba_users數(shù)據(jù)庫用戶信息dba_segments表段信息dba_objects數(shù)據(jù)庫對象信息dba_extents數(shù)據(jù)區(qū)信息dba_tablespaces 數(shù)據(jù)庫表空間信息dba_data_files 數(shù)據(jù)文件設(shè)置信息dba_temp_files 臨時數(shù)據(jù)文件信息dba_rollback_segs 回滾段信息dba_ts_quotas 用戶表空間配額信息dba_free_space 數(shù)據(jù)庫空閑空間信息dba_profiles 數(shù)據(jù)庫用戶資源限制信息dba_sys_privs 用戶的系統(tǒng)權(quán)限信息dba_tab_privs用戶具有的對象權(quán)限信息dba_col_privs用戶具有的列對象權(quán)限信息dba_role_privs用戶具有的角色信息dba_audit_trail審計跟蹤記錄信息dba_stmt_audit_opts審計設(shè)置信息dba_audit_object對象審計結(jié)果信息dba_audit_session會話審計結(jié)果信息dba_indexes用戶模式的索引信息user_開頭user_objects用戶對象信息user_source數(shù)據(jù)庫用戶的所有資源對象信息user_segments用戶的表段信息user_tables用戶的表對象信息user_tab_columns用戶的表列信息user_constraints用戶的對象約束信息user_sys_privs當前用戶的系統(tǒng)權(quán)限信息user_tab_privs當前用戶的對象權(quán)限信息user_col_privs當前用戶的表列權(quán)限信息user_role_privs當前用戶的角色權(quán)限信息user_indexes用戶的索引信息user_ind_columns用戶的索引對應(yīng)的表列信息user_cons_columns用戶的約束對應(yīng)的表列信息user_clusters用戶的所有簇信息user_clu_columns用戶的簇所包含的內(nèi)容信息user_cluster_hash_expressions散列簇的信息v$ 開頭v$database數(shù)據(jù)庫信息v$datafile數(shù)據(jù)文件信息v$controlfile控制文件信息v$logfile重做日志信息v$instance數(shù)據(jù)庫實例信息v$log日志組信息v$loghist日志歷史信息v$sga數(shù)據(jù)庫SGA信息v$parameter初始化參數(shù)信息v$process數(shù)據(jù)庫服務(wù)器進程信息v$bgprocess數(shù)據(jù)庫后臺進程信息v$controlfile_record_section控制文件記載的各部分信息v$thread線程信息v$datafile_header數(shù)據(jù)文件頭所記載的信息v$archived_log歸檔日志信息v$archive_dest歸檔日志的設(shè)置信息v$logmnr_contents歸檔日志分析的DML DDL結(jié)果信息v$l