oracle系統(tǒng)表詳解(中文)

1、Oracle 常用系統(tǒng)表dba_ 開頭頭dba_useers數(shù)據(jù)庫用戶信息息dba_seggmentss表段信息dba_objjects數(shù)據(jù)庫對象信息息dba_exttents數(shù)據(jù)區(qū)信息dba_tabblespaaces 數(shù)據(jù)庫表空間信信息dba_datta_filles 數(shù)據(jù)文件設(shè)置信信息dba_temmp_filles 臨時(shí)數(shù)據(jù)文件信信息dba_rolllbackk_segss 回滾段信息dba_ts_quotaas 用戶表空間配額額信息dba_freee_spaace 數(shù)據(jù)庫空閑空間間信息dba_proofiless 數(shù)據(jù)庫用戶資源源限制信息dba_syss_privvs 用戶的系統(tǒng)權(quán)限

2、限信息dba_tabb_privvs用戶具有的對象象權(quán)限信息dba_coll_privvs用戶具有的列對對象權(quán)限信息息dba_rolle_priivs用戶具有的角色色信息dba_auddit_trrail審計(jì)跟蹤記錄信信息dba_stmmt_auddit_oppts審計(jì)設(shè)置信息dba_auddit_obbject對象審計(jì)結(jié)果信信息dba_auddit_seessionn會話審計(jì)結(jié)果信信息dba_inddexes用戶模式的索引引信息user_開頭頭user_obbjectss用戶對象信息user_soource數(shù)據(jù)庫用戶的所所有資源對象象信息user_seegmentts用戶的表段信息息user

3、_taables用戶的表對象信信息user_taab_collumns用戶的表列信息息user_coonstraaints用戶的對象約束束信息user_syys_priivs當(dāng)前用戶的系統(tǒng)統(tǒng)權(quán)限信息user_taab_priivs當(dāng)前用戶的對象象權(quán)限信息user_cool_priivs當(dāng)前用戶的表列列權(quán)限信息user_roole_prrivs當(dāng)前用戶的角色色權(quán)限信息user_inndexess用戶的索引信息息user_innd_collumns用戶的索引對應(yīng)應(yīng)的表列信息息user_coons_coolumnss用戶的約束對應(yīng)應(yīng)的表列信息息user_cllusterrs用戶的所有簇信信息user

4、_cllu_collumns用戶的簇所包含含的內(nèi)容信息息user_cllusterr_hashh_exprressioons散列簇的信息v$ 開頭v$databbase數(shù)據(jù)庫信息v$dataffile數(shù)據(jù)文件信息v$contrrolfille控制文件信息v$logfiile重做日志信息v$instaance數(shù)據(jù)庫實(shí)例信息息v$log日志組信息v$loghiist日志歷史信息v$sga數(shù)據(jù)庫SGA信信息v$parammeter初始化參數(shù)信息息v$proceess數(shù)據(jù)庫服務(wù)器進(jìn)進(jìn)程信息v$bgproocess數(shù)據(jù)庫后臺進(jìn)程程信息v$contrrolfille_reccord_ssectioon控制

5、文件記載的的各部分信息息v$threaad線程信息v$dataffile_hheaderr數(shù)據(jù)文件頭所記記載的信息v$archiived_llog歸檔日志信息v$archiive_deest歸檔日志的設(shè)置置信息v$logmnnr_conntentss歸檔日志分析的的DML DDDL結(jié)果信信息v$logmnnr_dicctionaary日志分析的字典典文件信息v$logmnnr_loggs日志分析的日志志列表信息v$tableespacee表空間信息v$tempffile臨時(shí)文件信息v$filesstat數(shù)據(jù)文件的I/O統(tǒng)計(jì)信息息v$undosstatUndo數(shù)據(jù)信信息v$rollnname在線

6、回滾段信息息v$sessiion會話信息v$transsactioon事務(wù)信息v$rollsstat回滾段統(tǒng)計(jì)信息息v$pwfille_useers特權(quán)用戶信息v$sqlarrea當(dāng)前查詢過的ssql語句訪訪問過的資源源及相關(guān)的信信息v$sql與v$sqlaarea基本本相同的相關(guān)關(guān)信息v$syssttat數(shù)據(jù)庫系統(tǒng)狀態(tài)態(tài)信息all_開頭all_useers數(shù)據(jù)庫所有用戶戶的信息all_objjects數(shù)據(jù)庫所有的對對象的信息all_deff_audiit_optts所有默認(rèn)的審計(jì)計(jì)設(shè)置信息all_tabbles所有的表對象信信息all_inddexes所有的數(shù)據(jù)庫對對象索引的信信息sessi

7、oon_開頭sessionn_rolees會話的角色信息息sessionn_privvs會話的權(quán)限信息息index_開開頭index_sstats索引的設(shè)置和存存儲信息偽表dual系統(tǒng)偽列表信息息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