oracle系統(tǒng)表詳解資料

oracle系統(tǒng)表詳解

dba_開頭

dba_t$ers數(shù)據(jù)庫(kù)用戶信息

dba_segments表段信息

dba_cbject$數(shù)據(jù)庫(kù)對(duì)恐信息

dba_cxtents數(shù)據(jù)區(qū)信息

dba_tablespaces數(shù)據(jù)庫(kù)表空低信息

dba_cata_files數(shù)據(jù)文件設(shè)置信息

dba_temp_files臨時(shí)數(shù)據(jù)文件信息

dba_rollback_segs同滾段信息

dhA_K_qnnta<;用戶無(wú)空間配做信息

dba_f-ee_space數(shù)據(jù)庫(kù)空閑空間信息

dbajrofiles數(shù)據(jù)庫(kù)用戶資源限制信息

dba_sys_privs用戶的系統(tǒng)權(quán)限信息

dba_tab_privs用戶具有的對(duì)象權(quán)限信息

dba_col_privs用戶具有的列對(duì)象權(quán)限信息

dba_role_privs用戶具有的免色信息

dba_audit_trail審計(jì)跟蹤記錄信息

dba_stmt_audit_opts審計(jì)設(shè)置信息

dba_audit_object對(duì)象審計(jì)結(jié)果信息

dba_audit_session會(huì)話審計(jì)結(jié)果信息

dbajndexes用戶模式的索引信息

user_fF$t

user.objects用戶對(duì)象信息

user_$ource數(shù)據(jù)庫(kù)用戶的所有資源對(duì)象信息

user-segments用戶的表段信息

userjables用戶的表對(duì)象信息

u$er_tab_columns用戶的表列信息

user_constraints用戶的對(duì)象線束信息

user_$ys_priv$當(dāng)前用戶的系統(tǒng)權(quán)限信息

user_tab_privs當(dāng)前用戶的對(duì)象權(quán)限信息

user_col_priv$當(dāng)前用戶的表列權(quán)限信息

user_role_privs當(dāng)前用戶的并色權(quán)限信息

userjndexes用戶的索引住息

userjnd_columns用戶的索引對(duì)應(yīng)的表列信息

user_cons_columns用戶的約束對(duì)應(yīng)的表列信息

u$er_du$ters用戶的所有皴信息

user_du_columns用戶的簇所包含的內(nèi)容信息

user_cluster_hash_expressions散列簇的信息

v$權(quán)

vSdatabase數(shù)據(jù)庫(kù)信息

v$datafile數(shù)據(jù)文件信息

vScontrolfile操縱文件信息

v$logfile亞做日志信息

vSinstance數(shù)據(jù)庫(kù)室例信息

v$luy口志組信息

v$loghi$t日志歷史信息

v$sga數(shù)據(jù)庫(kù)SGA信息

v$parameter初始化參數(shù)信息

v$pro:ess數(shù)據(jù)庫(kù)服務(wù)罌進(jìn)程信息

v$bgprocess數(shù)據(jù)庫(kù)后臺(tái)進(jìn)程信息

v$controlfile_record_section操縱文件記載的各部分信息

v$thread線程信息

v$datafile_header數(shù)據(jù)文件頭所記載的信息

v$archived_log歸檔日志信息

v$archive_dest歸檔日志的設(shè)置信息

v$logmnr_contents歸檔H志分析的DMlDDL結(jié)果信息

v$logmnr_dictionory日志分析的字典文件信息

v$logmnr_logs日志分析的日志列表信息

v$tabespace表空間信息

vSterripfile臨時(shí)文件信息

v$file$tat數(shù)據(jù)文件的1/。統(tǒng)計(jì)信息

v$uncostatUndo數(shù)據(jù)信息

vSrollname在線回滾段信息

v$session會(huì)話信息

vStransaction事務(wù)信息

v$rollstat回滾段統(tǒng)計(jì)信息

v$pw1ile_users特權(quán)用戶信息

v$sqlarea當(dāng)前式iflJ過的sql語(yǔ)句訪問過的資源及有關(guān)的信息

v$cql與v?Eaea甚水相同的有關(guān)信息

數(shù)據(jù)庫(kù)系統(tǒng)狀態(tài)信息

all_開頭

all_u$sr?數(shù)據(jù)庫(kù)所有用戶的信息

all.objects數(shù)據(jù)庫(kù)所有昧對(duì)猿的信息

all_def_audit_opts所行默認(rèn)的加計(jì)設(shè)置信息

all.tables所有的表對(duì)軟信息

alljndexes所〕的數(shù)據(jù)庫(kù)對(duì)象索引的信息

session.開頭

session_roles會(huì)話的角色信息

session_privs會(huì)話的權(quán)限信息

index_開頭

index_stats索引的設(shè)置與存儲(chǔ)信息

偽表

dual系統(tǒng)偽列表信息

dba_users

ColumnDatatypeNULLDescription

USERNAMEVARCHAR2(30)NOTNULLNameoftheuser

USE3_ID_______________________NUMBERNOTNULL___________IDnumberoftheuser

PASSWORDVARCI1AR2(30)匚ncryptedpassword(力口密)

ACCOUNT_STATUSVARCHAR2(32)NOTNULLAccountstatus:

?OPEN

?EXPIRED(到期)

?EXPIRED(GRACE)

?LOCKED(TIMED)

?LOCKED

?EXPIRED&

LOCKED(TIMED)

?EXPIRED(GRACE)&

LOCKED(TIMED)

?EXPIRED&LOCKED

?EXPIRED(GRACE)&

LOCKED

LOCK_DATEDATEDatetheaccomtwaslockedif

accountstatuswasLOCKED

EXPIRY_DATEDATEDateofexpirationofthe

account

DEFAULTTABLESPACEVARCHAR2(30)NOTNULLDefaulttablespacefordata

TEM?ORARY_TABLESPACEVARCHAR2(30)NOTNULLNameofthedefaulttablespace

fortemporarytablesorthe

nameofatablespacegroup

CREATEDDATENOTNULLUsercreationdate

PKO/1LEVARCHAR2(30)NOTNULLUserresourceprofilename

INITIAL_RSRC_CONSUMER_GROUPVARCI1AR2(30)Initialresourceconsumer

groupfortheuser

EXTERNAL_NAMEVARCHAR2(4000)Userexternalname

dba_segments

ColumnDatatypeNULLDescription

OWNERVARCHAR2(30)Usernameofthesegment

owner

SEGMENT_NAMEVARCHAR2(81)Name,ifany,ofthesegment

PARTITION_NAMEVARCHAR2(30)ObjectPartitionName(Setto

NULLfornon-partitioned

objects)

SEGMENT_TYPEVARCHAR2(18)

Typeofsegment:INDEX

PARTITION,TABLE

PARTITION,TABLE,

CLUSTER,INDEX,

ROLLBACK,DEFERRED

ROLLBACK,TEMPORARY,

CACHE,LOBSEGMENTand

T.ORTNDRX

TADLESPACE_NAMEVARCI1AR2(30)Nameofthetablespace

containingthesegment

HEADER_FILENUMBERIDofthefilecontainingthe

segmentheader

HEADER_BLOCKNUMBERIDoftheblockcontainingthe

segmentheader

BYT3SNUMBERSize,inbytes,ofthesegment

BLOCKSNUMBERSize,inOracleblocks,ofthe

segment

EXTENTSNUMBERNumberofextentsallocatedto

thesegment

INITIAL_EXTENTNUMBERSizeinbytesrequestedforthe

initialpxtpntofthpwjmpntat

createtime.(Cracleroundsthe

extentsizetomultiplesof5

blocksiftherequestedsizeis

greaterthan5blocks.)

NEXT_EXTENTNUMBERSizeinbytesofthenextextent

tobeallocatedtothesegment

MIN_EXTENTSNUMBERMinimumnumberofextents

allowedinthesegment

MAX_EXTENTSNUMBERMaximumnumberofextents

allowedinthesegment

PCT_INCREASENUMBERPercentbywhichtoincrease

thesizeofthenextextenttobe

allocated

FRE3LISTSNUMBERNumberofprocessfreelists

allocatedtothissegment

FREELIST_GROUPSNUMBERNumberoffreelistgroups

allocatedtothissegment

RELATIVE_FNONUMBERRelativefilenumberofthe

segmentheader

BUFFER_POOLVARCHAR2(7)Defaultbufferpoolforthe

object

dba_objects

ColumnDatatypeNULLDescription

OWNERVARCHAR2(30)NOTNULLOwneroftheobject

0BJ3CT_NAMEVARCHAR2(30)NOTNULLNameoftheobject

SUBOBJECT_NAMEVARCHAR2(30)Nameofthesubobject(for

example,partition)

OBJSCT_IDNUMBERNOTNULLDictionaryobjectnumberofthe

object

DATA_OBJECT_IDNUMBERDictionaryobjectnumberofthe

segmentthatcontainsthe

object

Note:OBJECT_IDand

DATA_OBJECr_IDdisplay

datadictionarymetadata.Do

notconfusethesenumbers

withtheunique16-byteobject

identifier{objectID)thatthe

OracleDatabaseassignstorow

objectsinobjecttablesinthe

system.

OBJECT_TYPEVARCHAR2(19)Typeoftheobject(suchas

TABLE,INDEX)

CREATEDDATENOTNULLTimestampforthecreationof

theobject

LAST_DDL_TIMEDATENOTNULLTimestampforthelast

modificationoftheobject

resultingfromaDDLstatement

(includinggrantsandrevokes)

TIMESTAMPVARCHAR2(20)Timestampforthespecification

oftheobject(characterdata)

STATUSVARCHAR2(7)

Statusoftheooject(VALID,

INVALID,orN/A)

TEMPORARYVARCHAR2(1)Whethertheobjectis

temporary(thecurrentsession

canseeonlydatathatitplaced

inthisobjectitself)

GENERATEDVARCHAR2(1)Indicateswhetnerthenameof

thisobjectwassystem

generated(Y)ornot(N)

SECONDARYVARCHAR2(1)Whetherthisisasecondary

objectcreatedbythe

ODCIIndexCreatemethod

oftheOracleDataCartridge(Y

1N)

dba_extents

ColumnDatatypeNULLDescription

OWNERVARCHAR2(30)Ownerofthesegment

associatedwiththeextent

SEGMENT_NAMEVARCHAR2(81)Nameofthesegment

associatedwiththeextent

PARTITION_NAMEVARCHAR2(30)ObjectPartitionName(Setto

NULLfornon-partitioned

objects)

SEGMENT_TYPEVARCHAR2(18)

Typeofthesegment:INDEX

PARTITION,TABLE

PARTITION

TABLESPACE_NAMEVARCHAR2(30)Nameofthetablespace

containingtheextent

EXTENT]DNUMBERExtentnumberinthesegment

FILZ_IDNUMBERFileidentifiernumberofthefile

containingtheextent

BLOCK_IDNUMBERStartingblocknumberofthe

extent

BYTESNUMBERSi7Pofthppxtpntinhytpq

BLOCKSNUMBERSizeoftheextentinOracle

blocks

RELATIVE_FNONUMBERRelativefilenumberofthefirst

extentblock

dba_tablespaces

ColumnDatatypeNULLDescription

TABLESPACENAMEVARCHAR2(30)NOTNULLNameofthetablespace

BLOCK_SIZENUMBERNOTNULLTablespaceblocksize

INITIALEXTENTNUMBERDefaultinitialextentsize

NEXT_EXTENTNUMBERDefaultincrerrentalextentsize

MIN_EXTENTSNUMBERNOTNULLDefaultminimumnumberof

extents

MAX_EXTENTSNUMBERDefaultmaxirrumnumberof

extents

PCT_INCREASENUMBERDefaultpercentincreasefor

extentsize

MIN_EXTLENNUMBERMinimumextentsizeforthis

tablespace

STATUSVAPCHAR2(9)Tablespacestatus:

?ONLINE

?OFFLINE

?READONLY

CONTENTSVAFCHAR2(9)Tablespacecontents:

?UNDO

?PERMANENT

?TEMPORARY

LOGGINGVARCHAR2(9)D