【正文】 il entry (date and time of user login for entries created by AUDIT SESSION) in the local database session time zoneACTION_NAMEVARCHAR2(28)Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAILLOGOFF_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 sessionSESSIONIDNUMBERNOT NULLNumeric ID for each Oracle sessionRETURNCODENUMBERNOT NULLOracle error code generated by the action. Some useful values: 0 Action succeeded 2004 Security violationCLIENT_IDVARCHAR2(64)Client identifier in each Oracle sessionSESSION_CPUNUMBERAmount of CPU time used by each Oracle sessionEXTENDED_TIMESTAMPTIMESTAMP(6) WITH TIME ZONETimestamp 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_SESSIONIDNUMBERProxy session serial number, if an enterprise user has logged in through the proxy mechanismGLOBAL_UIDVARCHAR2(32)Global user identifier for the user, if the user has logged in as an enterprise userINSTANCE_NUMBERNUMBERInstance number as specified by the INSTANCE_NUMBER initialization parameterOS_PROCESSVARCHAR2(16)Operating System process identifier of the Oracle processdba_indexesColumnDatatypeNULLDescriptionOWNERVARCHAR2(30)NOT NULLOwner of the indexINDEX_NAMEVARCHAR2(30)NOT NULLName of the indexINDEX_TYPEVARCHAR2(27)Type of the index: NORMAL BITMAP FUNCTIONBASED NORMAL FUNCTIONBASED BITMAP DOMAINTABLE_OWNERVARCHAR2(30)NOT NULLOwner of the indexed objectTABLE_NAMEVARCHAR2(30)NOT NULLName of the indexed objectTABLE_TYPECHAR(5)Type of the indexed object (for example, TABLE, CLUSTER)UNIQUENESSVARCHAR2(9)Indicates whether the index is UNIQUE or NONUNIQUECOMPRESSIONVARCHAR2(8)Indicates whether index pression is enabled (ENABLED) or not (DISABLED)PREFIX_LENGTHNUMBERNumber of columns in the prefix of the pression keyTABLESPACE_NAMEVARCHAR2(30)Name of the tablespace containing the indexINI_TRANSNUMBERInitial number of transactionsMAX_TRANSNUMBERMaximum number of transactionsINITIAL_EXTENTNUMBERSize of the initial extentNEXT_EXTENTNUMBERSize of secondary extentsMIN_EXTENTSNUMBERMinimum number of extents allowed in the segmentMAX_EXTENTSNUMBERMaximum number of extents allowed in the segmentPCT_INCREASENUMBERPercentage increase in extent sizePCT_THRESHOLDNUMBERThreshold percentage of block space allowed per index entryINCLUDE_COLUMNNUMBERColumn 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.FREELISTSNUMBERNumber of process freelists allocated to this segmentFREELIST_GROUPSNUMBERNumber of freelist groups allocated to this segmentPCT_FREENUMBERMinimum percentage of free space in a blockLOGGINGVARCHAR2(3)Logging informationBLEVEL*NUMBERB*Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.LEAF_BLOCKS*NUMBERNumber of leaf blocks in the indexDISTINCT_KEYS*NUMBERNumber 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*NUMBERAverage 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*NUMBERAverage number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns.CLUSTERING_FACTOR*NUMBERIndicates the amount of order of the rows in the table based on the values of the index. 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. If the value is near the number of rows, then the table is very randomly ordered. In this case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.For bitmap indexes, this column is not applicable and is not used.STATUSVARCHAR2(8)Indicates whether a nonpartitioned index is VALID or UNUSABLENUM_ROWSNUMBERNumber of rows in the indexSAMPLE_SIZENUMBERSize of the sample used to analyze the indexLAST_ANALYZEDDATEDate on which this index was most recently analyzedDEGREEVARCHAR2(40)Number of threads per instance for scanning the indexINSTANCESVARCHAR2(40)Number of instances across which the indexes to be scannedPARTITIONEDVARCHAR2(3)Indicates whether the index is partitioned (YES) or not (NO)TEMPORARYVARCHAR2(1)Indicates whether the index is on a temporary tableGENERATEDVARCHAR2(1)Indicates whether the name of the index is system generated (Y) or not (N)SECONDARYVARCHAR2(1)Indicates whether the index is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)BUFFER_POOLVARCHAR2(7)Name of the default buffer pool to be used for the index blocksUSER_STATSVARCHAR2(3)Indicates whether statistics were entered directly by the user (YES) or not (NO)DURATIONVARCHAR2(15)