oracle系统表详解(中文)

1、Oracle 常用系统表dba_ 开头头dba_useers数据库用户信息息dba_seggmentss表段信息dba_objjects数据库对象信息息dba_exttents数据区信息dba_tabblespaaces 数据库表空间信信息dba_datta_filles 数据文件设置信信息dba_temmp_filles 临时数据文件信信息dba_rolllbackk_segss 回滚段信息dba_ts_quotaas 用户表空间配额额信息dba_freee_spaace 数据库空闲空间间信息dba_proofiless 数据库用户资源源限制信息dba_syss_privvs 用户的系统权限

2、限信息dba_tabb_privvs用户具有的对象象权限信息dba_coll_privvs用户具有的列对对象权限信息息dba_rolle_priivs用户具有的角色色信息dba_auddit_trrail审计跟踪记录信信息dba_stmmt_auddit_oppts审计设置信息dba_auddit_obbject对象审计结果信信息dba_auddit_seessionn会话审计结果信信息dba_inddexes用户模式的索引引信息user_开头头user_obbjectss用户对象信息user_soource数据库用户的所所有资源对象象信息user_seegmentts用户的表段信息息user

3、_taables用户的表对象信信息user_taab_collumns用户的表列信息息user_coonstraaints用户的对象约束束信息user_syys_priivs当前用户的系统统权限信息user_taab_priivs当前用户的对象象权限信息user_cool_priivs当前用户的表列列权限信息user_roole_prrivs当前用户的角色色权限信息user_inndexess用户的索引信息息user_innd_collumns用户的索引对应应的表列信息息user_coons_coolumnss用户的约束对应应的表列信息息user_cllusterrs用户的所有簇信信息user

4、_cllu_collumns用户的簇所包含含的内容信息息user_cllusterr_hashh_exprressioons散列簇的信息v$ 开头v$databbase数据库信息v$dataffile数据文件信息v$contrrolfille控制文件信息v$logfiile重做日志信息v$instaance数据库实例信息息v$log日志组信息v$loghiist日志历史信息v$sga数据库SGA信信息v$parammeter初始化参数信息息v$proceess数据库服务器进进程信息v$bgproocess数据库后台进程程信息v$contrrolfille_reccord_ssectioon控制

5、文件记载的的各部分信息息v$threaad线程信息v$dataffile_hheaderr数据文件头所记记载的信息v$archiived_llog归档日志信息v$archiive_deest归档日志的设置置信息v$logmnnr_conntentss归档日志分析的的DML DDDL结果信信息v$logmnnr_dicctionaary日志分析的字典典文件信息v$logmnnr_loggs日志分析的日志志列表信息v$tableespacee表空间信息v$tempffile临时文件信息v$filesstat数据文件的I/O统计信息息v$undosstatUndo数据信信息v$rollnname在线

6、回滚段信息息v$sessiion会话信息v$transsactioon事务信息v$rollsstat回滚段统计信息息v$pwfille_useers特权用户信息v$sqlarrea当前查询过的ssql语句访访问过的资源源及相关的信信息v$sql与v$sqlaarea基本本相同的相关关信息v$syssttat数据库系统状态态信息all_开头all_useers数据库所有用户户的信息all_objjects数据库所有的对对象的信息all_deff_audiit_optts所有默认的审计计设置信息all_tabbles所有的表对象信信息all_inddexes所有的数据库对对象索引的信信息sessi

7、oon_开头sessionn_rolees会话的角色信息息sessionn_privvs会话的权限信息息index_开开头index_sstats索引的设置和存存储信息伪表dual系统伪列表信息息dba_useersColumnDatatyppeNULLDescripptionUSERNAMMEVARCHARR2(30)NOT NULLLName off the userUSER_IDDNUMBERNOT NULLLID numbber off the userPASSWORRDVARCHARR2(30)Encryptted paassworrd（加密）ACCOUNTT_STATTUSVARC

8、HARR2(32)NOT NULLLAccountt stattus: OPENEXPIREDD（到期）EXPIREDD(GRACCE)LOCKED(TIMEDD)LOCKEDEXPIREDD & LOOCKED(TIMEDD)EXPIREDD(GRACCE) & LOCKEED(TIMMED)EXPIREDD & LOOCKEDEXPIREDD(GRACCE) & LOCKEEDLOCK_DAATEDATEDate thhe acccount was llockedd if aaccounnt staatus wwas LOOCKEDEXPIRY_DATEDATEDate off expii

9、ratioon of the aaccounntDEFAULTT_TABLLESPACCEVARCHARR2(30)NOT NULLLDefaultt tabllespacce forr dataaTEMPORAARY_TAABLESPPACEVARCHARR2(30)NOT NULLLName off the defauult taablesppace ffor teemporaary taables or thhe namme of a tabblespaace grroupCREATEDDDATENOT NULLLUser crreatioon dattePROFILEEVARCHARR

10、2(30)NOT NULLLUser reesourcce proofile nameINITIALL_RSRCC_CONSSUMER_GROUPPVARCHARR2(30)Initiall resoource consuumer ggroup for tthe usserEXTERNAAL_NAMMEVARCHARR2(40000)User exxternaal nammedba_seggmentssColumnDatatyppeNULLDescripptionOWNERVARCHARR2(30)Usernamme of the ssegmennt ownnerSEGMENTT_NAMEEV

11、ARCHARR2(81)Name, iif anyy, of the ssegmenntPARTITIION_NAAMEVARCHARR2(30)Object Partiition Name (Set to NUULL foor nonn-parttitionned obbjectss)SEGMENTT_TYPEEVARCHARR2(18)Type off segmment: INDEXX PARTTITIONN, TABBLE PAARTITIION, TTABLE, CLUSSTER, INDEXX, ROLLLBACKK, DEFFERREDD ROLLLBACK, TEMPPORARY

12、Y, CACCHE, LLOBSEGGMENT and LLOBINDDEXTABLESPPACE_NNAMEVARCHARR2(30)Name off the tableespacee conttaininng thee segmmentHEADER_FILENUMBERID of tthe fiile coontainning tthe seegmentt headderHEADER_BLOCKKNUMBERID of tthe bllock ccontaiining the ssegmennt heaaderBYTESNUMBERSize, iin byttes, oof thee se

13、gmmentBLOCKSNUMBERSize, iin Oraacle bblockss, of the ssegmenntEXTENTSSNUMBERNumber of exxtentss alloocatedd to tthe seegmenttINITIALL_EXTEENTNUMBERSize inn bytees reqquesteed forr the initiial exxtent of thhe seggment at crreate time. (Oraacle rroundss the extennt sizze to multiiples of 5 blockks if

14、 the rrequessted ssize iis greeater than 5 bloocks.)NEXT_EXXTENTNUMBERSize inn bytees of the nnext eextentt to bbe alllocateed to the ssegmenntMIN_EXTTENTSNUMBERMinimumm numbber off exteents aalloweed in the ssegmenntMAX_EXTTENTSNUMBERMaximumm numbber off exteents aalloweed in the ssegmenntPCT_INCCR

15、EASEENUMBERPercentt by wwhich to inncreasse thee sizee of tthe neext exxtent to bee alloocateddFREELISSTSNUMBERNumber of prrocesss freeelistss alloocatedd to tthis ssegmenntFREELISST_GROOUPSNUMBERNumber of frreelisst grooups aallocaated tto thiis seggmentRELATIVVE_FNOONUMBERRelativve fille nummber o

16、of thee segmment hheaderrBUFFER_POOLVARCHARR2(7)Defaultt bufffer poool foor thee objeectdba_objjectsColumnDatatyppeNULLDescripptionOWNERVARCHARR2(30)NOT NULLLOwner oof thee objeectOBJECT_NAMEVARCHARR2(30)NOT NULLLName off the objecctSUBOBJEECT_NAAMEVARCHARR2(30)Name off the subobbject (for exampple,

17、 ppartittion)OBJECT_IDNUMBERNOT NULLLDictionnary oobjectt numbber off the objecctDATA_OBBJECT_IDNUMBERDictionnary oobjectt numbber off the segmeent thhat coontainns thee objeectNote: OOBJECTT_ID aand DAATA_OBBJECT_ID diisplayy dataa dicttionarry mettadataa. Do not cconfusse theese nuumberss withh th

18、e uniquue 16-byte objecct ideentifiier (oobjectt ID) that the OOraclee Dataabase assiggns too row objeccts inn objeect taables in thhe sysstem.OBJECT_TYPEVARCHARR2(19)Type off the objecct (suuch ass TABLLE, INDEEX)CREATEDDDATENOT NULLLTimestaamp foor thee creaation of thhe objjectLAST_DDDL_TIMMEDATE

19、NOT NULLLTimestaamp foor thee lastt modiificattion oof thee objeect reesultiing frrom a DDL sstatemment (incluuding grantts andd revookes)TIMESTAAMPVARCHARR2(20)Timestaamp foor thee speccificaation of thhe objject (charaacter data)STATUSVARCHARR2(7)Status of thhe objject (VALIDD, INVAALID, or N/A)TE

20、MPORAARYVARCHARR2(1)Whetherr the objecct is tempoorary (the curreent seessionn can see oonly ddata tthat iit plaaced iin thiis objject iitselff)GENERATTEDVARCHARR2(1)Indicattes whhetherr the name of thhis obbject was ssystemm geneeratedd (Y) or not (N)SECONDAARYVARCHARR2(1)Whetherr thiss is aa secoo

21、ndaryy objeect crreatedd by tthe ODDCIInddexCreeate mmethodd of tthe Orracle Data Cartrridge (Y | N)dba_exttentsColumnDatatyppeNULLDescripptionOWNERVARCHARR2(30)Owner oof thee segmment aassociiated with the eextenttSEGMENTT_NAMEEVARCHARR2(81)Name off the segmeent asssociaated wwith tthe exxtentPARTI

22、TIION_NAAMEVARCHARR2(30)Object Partiition Name (Set to NUULL foor nonn-parttitionned obbjectss)SEGMENTT_TYPEEVARCHARR2(18)Type off the segmeent: IINDEX PARTIITION, TABLLE PARRTITIOONTABLESPPACE_NNAMEVARCHARR2(30)Name off the tableespacee conttaininng thee exteentEXTENT_IDNUMBERExtent numbeer in the

23、ssegmenntFILE_IDDNUMBERFile iddentiffier nnumberr of tthe fiile coontainning tthe exxtentBLOCK_IIDNUMBERStartinng bloock nuumber of thhe exttentBYTESNUMBERSize off the extennt in bytessBLOCKSNUMBERSize off the extennt in Oraclle bloocksRELATIVVE_FNOONUMBERRelativve fille nummber oof thee firsst extt

24、ent bblockdba_tabblespaacesColumnDatatyppeNULLDescripptionTABLESPPACE_NNAMEVARCHARR2(30)NOT NULLLName off the tableespaceeBLOCK_SSIZENUMBERNOT NULLLTablesppace bblock sizeINITIALL_EXTEENTNUMBERDefaultt inittial eextentt sizeeNEXT_EXXTENTNUMBERDefaultt incrrementtal exxtent sizeMIN_EXTTENTSNUMBERNOT

25、NULLLDefaultt miniimum nnumberr of eextenttsMAX_EXTTENTSNUMBERDefaultt maxiimum nnumberr of eextenttsPCT_INCCREASEENUMBERDefaultt perccent iincreaase foor exttent ssizeMIN_EXTTLENNUMBERMinimumm exteent siize foor thiis tabblespaaceSTATUSVARCHARR2(9)Tablesppace sstatuss: ONLINEOFFLINEEREAD ONNLYCONTE

26、NTTSVARCHARR2(9)Tablesppace ccontennts: UNDOPERMANEENTTEMPORAARYLOGGINGGVARCHARR2(9)Defaultt loggging aattribbute: LOGGINGGNOLOGGIINGFORCE_LLOGGINNGVARCHARR2(3)Indicattes whhetherr the tableespacee is uunder forcee loggging mmode (YES) oor nott (NO)EXTENT_MANAGGEMENTTVARCHARR2(10)Indicattes whhether

27、r the extennts inn the tableespacee are dictiionaryy manaaged (DICTIIONARYY) or locallly maanagedd (LOCCAL)ALLOCATTION_TTYPEVARCHARR2(9)Type off exteent alllocattion iin efffect ffor thhe tabblespaace: SYSTEMUNIFORMMUSERPLUGGEDD_INVARCHARR2(3)Indicattes whhetherr the tableespacee is ppluggeed in (YE

28、S) oor nott (NO)SEGMENTT_SPACCE_MANNAGEMEENTVARCHARR2(6)Indicattes whhetherr the free and uused ssegmennt spaace inn the tableespacee is mmanageed usiing frree liists (MANUAAL) orr bitmmaps (AUTO)DEF_TABB_COMPPRESSIIONVARCHARR2(8)Indicattes whhetherr defaault ttable comprressioon is enablled (EENABL

29、EED) orr not (DISAABLED) Note: EEnabliing deefaultt tablle commpresssion iindicaates tthat aall taables in thhe tabblespaace wiill bee creaated wwith ttable comprressioon enaabled unlesss othherwisse speecifieed.RETENTIIONVARCHARR2(11)Undo taablesppace rretenttion: GUARANTTEE - Tableespacee is aan u

30、nddo tabblespaace wiith REETENTIION sppecifiied ass GUARRANTEEEA RETENNTION valuee of GGUARANNTEE iindicaates tthat uunexpiired uundo iin alll undoo segmments in thhe unddo tabblespaace shhould be reetaineed eveen if it meeans tthat fforwarrd goiing opperatiions tthat nneed tto genneratee undoo in t

31、those segmeents ffail.NOGUARAANTEE - Tabblespaace iss an uundo ttablesspace with RETENNTION speciified as NOOGUARAANTEENOT APPPLY - Tableespacee is nnot ann undoo tabllespacceBIGFILEEVARCHARR2(3)Indicattes whhetherr the tableespacee is aa bigffile tableespacee (YES) oor a ssmallffile tableespacee (N

32、O)dba_datta_filles ColumnDatatyppeNULLDescripptionFILE_NAAMEVARCHARR2(5133)Name off the databbase ffileFILE_IDDNUMBERNOT NULLLFile iddentiffier nnumberr of tthe daatabasse filleTABLESPPACE_NNAMEVARCHARR2(30)NOT NULLLName off the tableespacee to wwhich the ffile bbelonggsBYTESNUMBERSize off the file

33、in byytesBLOCKSNUMBERNOT NULLLSize off the file in Orracle blockksSTATUSVARCHARR2(9)File sttatus: AVAIILABLEE or INNVALIDD (INVAALID mmeans that the ffile nnumberr is nnot inn use, for exampple, aa filee in aa tabllespacce thaat wass droppped)RELATIVVE_FNOONUMBERRelativve fille nummberAUTOEXTTENSIBB

34、LEVARCHARR2(3)Autoexttensibble inndicattorMAXBYTEESNUMBERMaximumm filee sizee in bbytesMAXBLOCCKSNUMBERMaximumm filee sizee in bblockssINCREMEENT_BYYNUMBERNumber of taablesppace bblockss usedd as aautoexxtensiion inncremeent. BBlock size is coontainned inn the BLOCKK_SIZEE coluumn off the DBA_TTABLE

35、SSPACESS vieww.USER_BYYTESNUMBERThe sizze of the ffile aavailaable ffor usser daata. TThe acctual size of thhe fille minnus thhe USEER_BYTTES vaalue iis useed to storee filee relaated mmetadaata.USER_BLLOCKSNUMBERNumber of bllocks whichh can be ussed byy the dataONLINE_STATUUSVARCHARR2(7)Online stat

36、uus of the ffile: SYSOFFSYSTEMOFFLINEEONLINERECOVERRdba_temmp_fillesColumnDatatyppeNULLDescripptionFILE_NAAMEVARCHARR2(5133)Name off the databbase ttemp ffileFILE_IDDNUMBERFile iddentiffier nnumberr of tthe daatabasse temmp filleTABLESPPACE_NNAMEVARCHARR2(30)NOT NULLLName off the tableespacee to wwh

37、ich the ffile bbelonggsBYTESNUMBERSize off the file (in bbytes)BLOCKSNUMBERSize off the file (in OOraclee bloccks)STATUSCHAR(9)File sttatus: AVAILABBLERELATIVVE_FNOONUMBERTablesppace-rrelatiive fiile nuumberAUTOEXTTENSIBBLEVARCHARR2(3)Indicattes whhetherr the file is auutoexttensibble (YES) oor nott

38、 (NO)MAXBYTEESNUMBERmaximumm sizee of tthe fiile (iin byttes)MAXBLOCCKSNUMBERMaximumm sizee of tthe fiile (iin Oraacle bblockss)INCREMEENT_BYYNUMBERDefaultt incrrementt for autoeextenssionUSER_BYYTESNUMBERSize off the usefuul porrtion of thhe fille (inn bytees)USER_BLLOCKSNUMBERSize off the usefuul

39、porrtion of thhe fille (inn Oraccle bllocks)dba_rolllbackk_segssColumnDatatyppeNULLDescripptionSEGMENTT_NAMEEVARCHARR2(30)NOT NULLLName off the rollbback ssegmenntOWNERVARCHARR2(6)Owner oof thee rolllback segmeentTABLESPPACE_NNAMEVARCHARR2(30)NOT NULLLName off the tableespacee conttaininng thee roll

40、lback segmeentSEGMENTT_IDNUMBERNOT NULLLID numbber off the rollbback ssegmenntFILE_IDDNUMBERNOT NULLLFile iddentiffier nnumberr of tthe fiile coontainning tthe seegmentt headdBLOCK_IIDNUMBERNOT NULLLID numbber off the blockk conttaininng thee segmment hheaderrINITIALL_EXTEENTNUMBERInitiall exteent s

41、iize inn byteesNEXT_EXXTENTNUMBERSecondaary exxtent size in byytesMIN_EXTTENTSNUMBERNOT NULLLMinimumm numbber off exteentsMAX_EXTTENTSNUMBERNOT NULLLMaximumm numbber off exteentPCT_INCCREASEENUMBERPercentt incrrease for eextentt sizeeSTATUSVARCHARR2(16)Rollbacck seggment statuusINSTANCCE_NUMMVARCHAR

42、R2(40)Rollbacck seggment owninng Reaal Appplicattion CClusteers innstancce nummberRELATIVVE_FNOONUMBERNOT NULLLRelativve fille nummber oof thee segmment hheaderrdba_ts_quotaas ColumnDatatyppeNULLDescripptionTABLESPPACE_NNAMEVARCHARR2(30)NOT NULLLTablesppace nnameUSERNAMMEVARCHARR2(30)NOT NULLLUser w

43、iith reesourcce rigghts oon thee tabllespacceBYTESNUMBERNumber of byytes cchargeed to the uuserMAX_BYTTESNUMBERUsers quotaa in bbytes, or -1 if no liimitBLOCKSNUMBERNOT NULLLNumber of Orracle blockks chaarged to thhe useerMAX_BLOOCKSNUMBERUsers quotaa in OOraclee bloccks, oor -1 if no liimitDROPPEDD

44、VARCHARR2(3)Whetherr the tableespacee has been dropppeddba_freee_spaaceColumnDatatyppeNULLDescripptionTABLESPPACE_NNAMEVARCHARR2(30)Name off the tableespacee conttaininng thee exteentFILE_IDDNUMBERFile iddentiffier nnumberr of tthe fiile coontainning tthe exxtentBLOCK_IIDNUMBERStartinng bloock nuumb

45、er of thhe exttentBYTESNUMBERSize off the extennt (inn bytees)BLOCKSNUMBERSize off the extennt (inn Oraccle bllocks)RELATIVVE_FNOONUMBERRelativve fille nummber oof thee filee conttaininng thee exteentdba_proofilessColumnDatatyppeNULLDescripptionPROFILEEVARCHARR2(30)NOT NULLLProfilee nameeRESOURCCE_N

46、AMMEVARCHARR2(32)NOT NULLLResourcce nammeRESOURCCE_TYPPEVARCHARR2(8)Indicattes whhetherr the resouurce pprofille is a KERRNEL oor a PPASSWOORD paarametterLIMITVARCHARR2(40)Limit pplacedd on tthis rresourrce foor thiis proofiledba_syss_privvs ColumnDatatyppeNULLDescripptionGRANTEEEVARCHARR2(30)NOT NU

47、LLLGranteee namee, useer, orr rolee receeivingg the granttUSERNAMMEVARCHARR2(30)Name off the curreent usserPRIVILEEGEVARCHARR2(40)NOT NULLLSystem priviilegeADMIN_OOPTIONNVARCHARR2(3)Grant wwas wiith thhe ADMMIN opptiondba_tabb_privvsColumnDatatyppeNULLDescripptionGRANTEEEVARCHARR2(30)NOT NULLLName o

48、ff the user to whhom acccess was ggranteedOWNERVARCHARR2(30)NOT NULLLOwner oof thee objeectTABLE_NNAMEVARCHARR2(30)NOT NULLLName off the objecctGRANTORRVARCHARR2(30)NOT NULLLName off the user who pperforrmed tthe grrantPRIVILEEGEVARCHARR2(40)NOT NULLLPrivileege onn the objecctGRANTABBLEVARCHARR2(3)I

49、ndicattes whhetherr the priviilege was ggranteed witth thee GRANNT OPTTION (YES) oor nott (NO)HIERARCCHYVARCHARR2(3)Indicattes whhetherr the priviilege was ggranteed witth thee HIERRARCHYY OPTIION (YES) oor nott (NO)dba_coll_privvsColumnDatatyppeNULLDescripptionGRANTEEEVARCHARR2(30)NOT NULLLName off

50、 the user to whhom acccess was ggranteedOWNERVARCHARR2(30)NOT NULLLOwner oof thee objeectTABLE_NNAMEVARCHARR2(30)NOT NULLLName off the objecctCOLUMN_NAMEVARCHARR2(30)NOT NULLLName off the colummnGRANTORRVARCHARR2(30)NOT NULLLName off the user who pperforrmed tthe grrantPRIVILEEGEVARCHARR2(40)NOT NUL

51、LLPrivileege onn the colummnGRANTABBLEVARCHARR2(3)Indicattes whhetherr the priviilege was ggranteed witth thee GRANNT OPTTION (YES) oor nott (NO)dba_rolle_priivsColumnDatatyppeNULLDescripptionGRANTEEEVARCHARR2(30)Name off the user or roole reeceiviing thhe graantGRANTEDD_ROLEEVARCHARR2(30)NOT NULLLG

52、rantedd rolee nameeADMIN_OOPTIONNVARCHARR2(3)Indicattes whhetherr the grantt was with the AADMIN OPTIOON (YES) oor nott (NO)DEFAULTT_ROLEEVARCHARR2(3)Indicattes whhetherr the role is deesignaated aas a DDEFAULLT ROLLE forr the user (YES) oor nott (NO)dba_auddit_trrailColumnDatatyppeNULLDescripptionO

53、S_USERRNAMEVARCHARR2(2555)Operatiing syystem loginn userrname of thhe useer whoose acctionss weree audiitedUSERNAMMEVARCHARR2(30)Name (nnot IDD numbber) oof thee userr whosse acttions were audittedUSERHOSSTVARCHARR2(1288)Client host machiine naameTERMINAALVARCHARR2(2555)Identiffier oof thee userrs t

54、eerminaalTIMESTAAMPDATEDate annd timme of the ccreatiion off the auditt traiil enttry (ddate aand tiime off userr logiin forr entrries ccreateed by AUDITT SESSSION) in thhe loccal daatabasse sesssion time zoneOWNERVARCHARR2(30)Creatorr of tthe obbject affeccted bby thee actiionOBJ_NAMMEVARCHARR2(128

55、8)Name off the objecct afffectedd by tthe acctionACTIONNUMBERNOT NULLLNumericc actiion tyype coode. TThe coorresppondinng namme of the aactionn typee is iin thee ACTIION_NAAME coolumn.ACTION_NAMEVARCHARR2(28)Name off the actioon typpe corrrespoondingg to tthe nuumericc codee in tthe ACCTION colummnN

56、EW_OWNNERVARCHARR2(30)Owner oof thee objeect naamed iin thee NEW_NAME colummnNEW_NAMMEVARCHARR2(1288)New namme of the oobjectt afteer a RRENAMEE or tthe naame off the underrlyingg objeectOBJ_PRIIVILEGGEVARCHARR2(16)Object priviilegess grannted oor revvoked by a GRANTT or REEVOKE stateementSYS_PRIIVI

57、LEGGEVARCHARR2(40)System priviilegess grannted oor revvoked by a GRANTT or REEVOKE stateementADMIN_OOPTIONNVARCHARR2(1)Indicattes whhetherr the role or syystem priviilege was ggranteed witth thee ADMIIN opttionGRANTEEEVARCHARR2(30)Name off the granttee sppecifiied inn a GRRANT oor REVVOKE sstatemmen

58、tAUDIT_OOPTIONNVARCHARR2(40)Auditinng opttion sset wiith thhe AUDDIT sttatemeentSES_ACTTIONSVARCHARR2(19)Sessionn summmary (a strring oof 16 charaacterss, onee for each actioon typpe in the oorder ALTERR, AUDIIT, COMMMENT, DELETTE, GRANNT, INDEEX, INSEERT, LOCKK, RENAAME, SELEECT, UPDAATE, REFEERENC

59、EES, annd EXEECUTE. Posiitionss 14, 15, aand 166 are reserrved ffor fuuture use. The ccharaccters are: - - NonneS - SucccessF - FaiilureB - BotthLOGOFF_TIMEDATEDate annd timme of user log ooffLOGOFF_LREADDNUMBERLogicall readds forr the sessiionLOGOFF_PREADDNUMBERPhysicaal reaads foor thee sesssionLO

60、GOFF_LWRITTENUMBERLogicall writtes foor thee sesssionLOGOFF_DLOCKKVARCHARR2(40)Deadloccks deetecteed durring tthe seessionnCOMMENTT_TEXTTVARCHARR2(40000)Text coommentt on tthe auudit ttrail entryy, proovidinng morre infformattion aabout the sstatemment aauditeed Also inndicattes hoow thee userr was