freepeople性欧美熟妇, 色戒完整版无删减158分钟hd, 无码精品国产vα在线观看DVD, 丰满少妇伦精品无码专区在线观看,艾栗栗与纹身男宾馆3p50分钟,国产AV片在线观看,黑人与美女高潮,18岁女RAPPERDISSSUBS,国产手机在机看影片

正文內(nèi)容

oracle系統(tǒng)表詳解(更新版)

2025-09-06 16:59上一頁面

下一頁面
  

【正文】 USERHOSTVARCHAR2(128)System change number (SCN) of the querySQL_BINDNVARCHAR2(2000)Application execution context identifierSESSION_CPUNUMBER DATABASE Authentication was done by password F FailureObject privileges granted or revoked by a GRANT or REVOKE statementSYS_PRIVILEGEVARCHAR2(40)Identifier of the user39。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)Size of the extent (in bytes)BLOCKSNUMBERUser39。Size of the useful portion of the file (in Oracle blocks)dba_rollback_segsColumnDatatypeNULLDescriptionSEGMENT_NAMEVARCHAR2(30)NOT NULLName of the rollback segmentOWNERVARCHAR2(6)File status: SYSTEMAutoextensible indicatorMAXBYTESNUMBER GUARANTEE Tablespace is an undo tablespace with RETENTION specified as GUARANTEEA RETENTION value of GUARANTEE indicates that unexpired undo in all undo segments in the undo tablespace should be retained even if it means that forward going operations that need to generate undo in those segments fail.Type of extent allocation in effect for the tablespace: UNDODefault maximum number of extentsPCT_INCREASENUMBERExtent number in the segmentFILE_IDNUMBERWhether the object is temporary (the current session can see only data that it placed in this object itself)GENERATEDVARCHAR2(1)Name of the subobject (for example, partition)OBJECT_IDNUMBERNOT NULLDictionary object number of the objectDATA_OBJECT_IDNUMBERSize in bytes of the next extent to be allocated to the segmentMIN_EXTENTSNUMBERType of segment: INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE, LOBSEGMENT and LOBINDEXTABLESPACE_NAMEVARCHAR2(30) LOCKEDLOCK_DATEDATE LOCKEDEncrypted password(加密)ACCOUNT_STATUSVARCHAR2(32)NOT NULLAccount status: EXPIRED(GRACE) amp。Initial resource consumer group for the userEXTERNAL_NAMEVARCHAR2(4000)ID of the block containing the segment headerBYTESNUMBERPercent by which to increase the size of the next extent to be allocatedFREELISTSNUMBEROwner of the segment associated with the extentSEGMENT_NAMEVARCHAR2(81)Size of the extent in bytesBLOCKSNUMBERTablespace status: Default logging attribute: USERPLUGGED_INVARCHAR2(3)Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)dba_data_files ColumnDatatypeNULLDescriptionFILE_NAMEVARCHAR2(513)Number of tablespace blocks used as autoextension increment. Block size is contained in the BLOCK_SIZE column of the DBA_TABLESPACES view.USER_BYTESNUMBER RECOVERdba_temp_filesColumnDatatypeNULLDescriptionFILE_NAMEVARCHAR2(513)Indicates whether the file is autoextensible (YES) or not (NO)MAXBYTESNUMBERSecondary extent size in bytesMIN_EXTENTSNUMBERNOT NULLMinimum number of extentsMAX_EXTENTSNUMBERNOT NULLMaximum number of extentPCT_INCREASENUMBERs quota in Oracle blocks, or 1 if no limitDROPPEDVARCHAR2(3)Indicates whether the resource profile is a KERNEL or a PASSWORD parameterLIMITVARCHAR2(40)Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO)DEFAULT_ROLEVARCHAR2(3)Creator of the object affected by the actionOBJ_NAMEVARCHAR2(128)Name of the grantee specified in a GRANT or REVOKE statementAUDIT_OPTIONVARCHAR2(40)Logical reads for the sessionLOGOFF_PREADNUMBER the name of the proxy user follows the method typeSESSIONIDNUMBERNOT NULLNumeric ID for each Oracle sessionENTRYIDNUMBERNOT NULLNumeric ID for each audit trail entry in the sessionSTATEMENTIDNUMBERNOT NULLNumeric ID for each statement runRETURNCODENUMBERNOT NULLOracle error code generated by the action. Some useful values: Proxy session serial number, if an enterprise user has logged in through the proxy mechanismGLOBAL_UIDVARCHAR2(32)User name if by user auditing. ANY CLIENT if access by a proxy on behalf of a client is being audited. NULL for systemwide auditingPROXY_NAMEVARCHAR2(30)s terminalTIMESTAMPDATEText ment on the audit trailSESSIONIDNUMBERNOT NULLNumeric ID for each Oracle sessionENTRYIDNUMBERNOT NULLNumeric ID for each audit trail entry in the sessionSTATEMENTIDNUMBERNOT NULLNumeric ID for each statement runRETURNCODENUMBERNOT NULLOracle error code generated by the action. Some useful values: Global user identifier for the user, if the user has logged in as an enterprise userINSTANCE_NUMBERNUMBERName (not ID number) of the user whose actions were auditedUSERHOSTVARCHAR2(128)Physical reads for the sessionLOGOFF_LWRITENUMBERProxy session serial number, if an enterprise user has logged in through the proxy mechanismGLOBAL_UIDVARCHAR2(32) FUNCTIONBASED BITMAPMaximum number of transactionsINITIAL_EXTENTNUMBERNumber of process freelists allocated to this segmentFREELIST_GROUPSNUMBERAverage 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*NUMBERNumber of threads per instance for scanning the indexINSTANCESVARCHAR2(40)
點擊復制文檔內(nèi)容
教學教案相關推薦
文庫吧 www.dybbs8.com
備案圖鄂ICP備17016276號-1