【正文】 EDVARCHAR2(40)Identifier of the user39。Instance number as specified by the INSTANCE_NUMBER initialization parameterOS_PROCESSVARCHAR2(16)Size of secondary extentsMIN_EXTENTSNUMBER If the value is near the number of blocks, then the table is very well ordered. In this case, the index entries in a single leaf block tend to point to rows in the same data blocks.Name of the default buffer pool to be used for the index blocksUSER_STATSVARCHAR2(3)Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table ()AVG_LEAF_BLOCKS_PER_KEY*NUMBERName of the tablespace containing the indexINI_TRANSNUMBERAmount of CPU time used by each Oracle sessionEXTENDED_TIMESTAMPTIMESTAMP(6) WITH TIME ZONESQL text of the querydba_audit_sessionColumnDatatypeNULLDescriptionOS_USERNAMEVARCHAR2(255)New name of an object after a RENAME or the name of the underlying objectSES_ACTIONSVARCHAR2(19)Bind variable data of the querySQL_TEXTNVARCHAR2(2000) NETWORK Authentication was done by Oracle Net Services or the Advanced Security optionSystem privileges granted or revoked by a GRANT or REVOKE statementADMIN_OPTIONVARCHAR2(1)Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)dba_role_privsColumnDatatypeNULLDescriptionGRANTEEVARCHAR2(30)s quota in bytes, or 1 if no limitBLOCKSNUMBERNOT NULLNumber of Oracle blocks charged to the userMAX_BLOCKSNUMBER AVAILABLERELATIVE_FNONUMBERMaximum file size in bytesMAXBLOCKSNUMBER SYSTEMDefault percent increase for extent sizeMIN_EXTLENNUMBERIndicates whether the name of this object was system generated (Y) or not (N)SECONDARYVARCHAR2(1)Minimum number of extents allowed in the segmentMAX_EXTENTSNUMBERDate the account was locked if account status was LOCKEDEXPIRY_DATEDATEOracle 常用系統(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當(dāng)前用戶的系統(tǒng)權(quán)限信息user_tab_privs當(dāng)前用戶的對象權(quán)限信息user_col_privs當(dāng)前用戶的表列權(quán)限信息user_role_privs當(dāng)前用戶的角色權(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$logmnr_dictionary日志分析的字典文件信息v$logmnr_logs日志分析的日志列表信息v$tablespace表空間信息v$tempfile臨時文件信息v$filestat數(shù)據(jù)文件的I/O統(tǒng)計信息v$undostatUndo數(shù)據(jù)信息v$rollname在線回滾段信息v$session會話信息v$transaction事務(wù)信息v$rollstat回滾段統(tǒng)計信息v$pwfile_users特權(quán)用戶信息v$sqlarea當(dāng)前查詢過的sql語句訪問過的資源及相關(guān)的信息v$sql與v$sqlarea基本相同的相關(guān)信息v$sysstat數(shù)據(jù)庫系統(tǒng)狀態(tài)信息all_開頭all_users數(shù)據(jù)庫所有用戶的信息all_objects數(shù)據(jù)庫所有的對象的信息all_def_audit_opts所有默認(rèn)的審計設(shè)置信息all_tables所有的表對象信息all_indexes所有的數(shù)據(jù)庫對象索引的信息 session_開頭session_roles會話的角色信息session_privs會話的權(quán)限信息index_開頭index_stats索引的設(shè)置和存儲信息偽表dual系統(tǒng)偽列表信息dba_usersColumnDatatypeNULLDescriptionUSERNAMEVARCHAR2(30)NOT NULLName of the userUSER_IDNUMBERNOT NULLID number of the userPASSWORDVARCHAR2(30)Date 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)Maximum number of extents allowed in the segmentPCT_INCREASENUMBERWhether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N)dba_extentsColumnDatatypeNULLDescriptionOWNERVARCHAR2(30)Minimum extent size for this tablespaceSTATUSVARCHAR2(9) UNIFORMMaximum file size in blocksINCREMENT_BYNUMBERTablespacerelative file numberAUTOEXTENSIBLEVARCHAR2(3)User39。Name of the user or role receiving the grantGRANTED_ROLEVARCHAR2(30)NOT NULLGranted role nameADMIN_OPTIONVARCHAR2(3)Indicates whether the role or system privilege was granted with the ADMIN optionGRANTEEVARCHAR2(30) PROXY Client was authenticated by another user。SQL text of the querydba_stmt_audit_optsColumnDatatypeNULLDescriptionUSER_NAMEVARCHAR2(30)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)Operating system login username of the user whose actions were auditedUSERNAMEVARCHAR2(30)Timestamp