Vues du dictionnaire pour le DBA

DBA_ANALYZE_OBJECTS

Objets analysés (calcul des statistiques) pour l'optimiseur statistique

Nom de la colonne	Description
OBJECT_NAME	Name of the object
OBJECT_TYPE	Type of the object

DBA_AUDIT_EXISTS

résultats des commandes d'audit : AUDIT NOT EXISTS et AUDIT EXISTS.

Nom de la colonne	Description
OS_USERNAME	Operating system login username of the user whose actions were audited
USERNAME	Name (not ID number) of the user whose actions were audited
USERHOST	Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	Identifier of the user's terminal
TIMESTAMP	Timestamp for the creation of the audit trail entry
OWNER	Intended creator of the non-existent object
OBJ_NAME	Name of the object affected by the action
ACTION_NAME	Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
NEW_OWNER	Owner of the object named in the NEW_NAME column
NEW_NAME	New name of an object after a RENAME or the name of the underlying object
OBJ_PRIVILEGE	Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE	System privileges granted or revoked by a GRANT or REVOKE statement
GRANTEE	Name of grantee specified in a GRANT or REVOKE statement
SESSIONID	Numeric ID for each Oracle session
ENTRYID	Numeric ID for each audit trail entry in the session
STATEMENTID	Numeric ID for each statement run
RETURNCODE	Oracle Server message code generated by the action. Some useful values:
	zero the action succeeded
	2004 security violation

DBA_AUDIT_OBJECT

résultat global de l'audit

Nom de la colonne	Description
OS_USERNAME	Operating system login username of the user whose actions were audited
USERNAME	Name (not ID number) of the user whose actions were audited
USERHOST	Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	Identifier of the user's terminal
TIMESTAMP	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	Creator of the object affected by the action
OBJ_NAME	Name of the object affected by the action
ACTION_NAME	Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
NEW_OWNER	Owner of the object named in the NEW_NAME column
NEW_NAME	New name of an object after a RENAME or the name of the underlying object
SES_ACTIONS	Session summary (a string of 11 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE. The characters are: - for none, S for success, F for failure, and B for both)
COMMENT_TEXT	Text comment on the audit trail, inserted by the application
SESSIONID	Numeric ID for each Oracle session
ENTRYID	Numeric ID for each audit trail entry in the session
STATEMENTID	Numeric ID for each statement run
RETURNCODE	Oracle Server message code generated by the action. Some useful values:
	zero the action succeeded
	2004 security violation
PRIV_USED	System privilege used to execute the action
OBJECT_LABEL	Optional Trusted Oracle7 Server label associated with the object being audited
SESSION_LABEL	Optional Trusted Oracle7 Server label associated with the session

DBA_AUDIT_SESSION

résultat d'audit sur les connexions / déconnexions

Nom de la colonne	Description
OS_USERNAME	Operating system login username of the user whose actions were audited
USERNAME	Name (not ID number) of the user whose actions were audited
USERHOST	Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	Identifier of the user's terminal
TIMESTAMP	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
ACTION_NAME	Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
LOGOFF_TIME	Timestamp for user logoff
LOGOFF_LREAD	Logical reads for the session
LOGOFF_PREAD	Physical reads for the session
LOGOFF_LWRITE	Logical writes for the session
LOGOFF_DLOCK	Deadlocks detected during the session
SESSIONID	Numeric ID for each Oracle session
RETURNCODE	Oracle Server message code generated by the action. Some useful values:
	zero the action succeeded
	2004 security violation
SESSION_LABEL	Optional Trusted Oracle7 Server label associated with the session

DBA_AUDIT_STATEMENT

résultat d'audit sur les ordres de type DBA

Nom de la colonne	Description
OS_USERNAME	Operating system login username of the user whose actions were audited
USERNAME	Name (not ID number) of the user whose actions were audited
USERHOST	Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	Identifier of the user's terminal
TIMESTAMP	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	Creator of the object affected by the action
OBJ_NAME	Name of object affected by the action
ACTION_NAME	Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
NEW_NAME	New name of an object after a RENAME or the name of the underlying object
OBJ_PRIVILEGE	Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE	System privileges granted or revoked by a GRANT or REVOKE statement
ADMIN_OPTION	Signifies the role or system privilege was granted with ADMIN option
GRANTEE	Name of grantee specified in a GRANT or REVOKE statement
AUDIT_OPTION	Auditing option set with the AUDIT statement
SES_ACTIONS	Session summary (a string of 11 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE. The characters are: - for none, S for success, F for failure, and B for both)
COMMENT_TEXT	Text comment on the audit trail, inserted by the application
SESSIONID	Numeric ID for each Oracle session
ENTRYID	Numeric ID for each audit trail entry in the session
STATEMENTID	Numeric ID for each statement run
RETURNCODE	Oracle Server message code generated by the action. Some useful values:
	zero the action succeeded
	2004 security violation
PRIV_USED	System privilege used to execute the action
SESSION_LABEL	Optional Trusted Oracle7 Server label associated with the session

DBA_AUDIT_TRAIL

vue globale des audits

Nom de la colonne	Description
OS_USERNAME	Operating system login username of the user whose actions were audited
USERNAME	Name (not ID number) of the user whose actions were audited
USERHOST	Numeric instance ID for the Oracle instance from which the user is accessing the database
TERMINAL	Identifier of the user's terminal
TIMESTAMP	Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
OWNER	Creator of the object affected by the action
OBJ_NAME	Name of the object affected by the action
ACTION	Numeric type code corresponding to the action
ACTION_NAME	Name of the action type corresponding to the numeric code in the ACTION column
NEW_OWNER	Owner of the object named in the NEW_NAME column
NEW_NAME	New name of an object after a RENAME or the name of the underlying object
OBJ_PRIVILEGE	Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE	System privileges granted or revoked by a GRANT or REVOKE statement
ADMIN_OPTION	Signifies the role or system privilege was granted with ADMIN option
GRANTEE	Name of grantee specified in a GRANT or REVOKE statement
AUDIT_OPTION	Auditing option set with the AUDIT statement
SES_ACTIONS	Session summary (a string of 11 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE. The characters are: - for none, S for success, F for failure, and B for both)
LOGOFF_TIME	Timestamp for user logoff
LOGOFF_LREAD	Logical reads for the session
LOGOFF_PREAD	Physical reads for the session
LOGOFF_LWRITE	Logical writes for the session
LOGOFF_DLOCK	Deadlocks detected during the session
COMMENT_TEXT	Text comment on the audit trail entry, providing more information about the statement audited
SESSIONID	Numeric ID for each Oracle session
ENTRYID	Numeric ID for each audit trail entry in the session
STATEMENTID	Numeric ID for each statement run
RETURNCODE	Oracle Server message code generated by the action. Some useful values:
	zero the action succeeded
	2004 security violation
PRIV_USED	System privilege used to execute the action
OBJECT_LABEL	Optional Trusted Oracle7 Server label associated with the object being audited
SESSION_LABEL	Optional Trusted Oracle7 Server label associated with the session

DBA_BLOCKERS

sessions présentant des verrous bloquants

Nom de la colonne	Description
SESSION_ID	Session holding a lock

DBA_CATALOG

liste les tables, vues, synonymes, et sequences de la base.

Nom de la colonne	Description
OWNER	Owner of the object
TABLE_NAME	Name of the object
TABLE_TYPE	Type of the object

DBA_CLUSTERS

Nom de la colonne	Description
OWNER	Owner of the cluster
CLUSTER_NAME	Name of the tablespace containing the cluster
TABLESPACE_NAME	Name of the tablespace containing the cluster
PCT_FREE	Minimum percentage of free space in a block
PCT_USED	Minimum percentage of used space in a block
KEY_SIZE	Estimated size of cluster key plus associated rows
INI_TRANS	Initial number of transactions
MAX_TRANS	Maximum number of transactions
INITIAL_EXTENT	Size of the initial extent in bytes
NEXT_EXTENT	Size of secondary extents in bytes
MIN_EXTENTS	Minimum number of extents allowed in the segment
MAX_EXTENTS	Maximum number of extents allowed in the segment
PCT_INCREASE	Percentage increase in extent size
FREELISTS	Number of process freelists allocated to this segment
FREELIST_GROUPS	Number of freelist groups allocated to this segment
AVG_BLOCKS_PER_KEY	Average number of blocks containing rows with a given cluster key
CLUSTER_TYPE	Type of cluster: b-tree index or hash
FUNCTION	If a hash cluster, the hash function
HASHKEYS	If a hash cluster, the number of hash keys (hash buckets)
DEGREE	The number of threads per instance for scanning the table
INSTANCES	The number of instances across which the table is to be scanned
CACHE	Whether the table is to be cached in the buffer cache

DBA_CLU_COLUMNS

les colonnes de clusters

Nom de la colonne	Description
OWNER	Owner of the cluster
CLUSTER_NAME	Cluster name
CLU_COLUMN_NAME	Key column in the cluster
TABLE_NAME	Clustered table name
TAB_COLUMN_NAME	Key column in the table

DBA_COL_COMMENTS

commentaires sur les colonnes des tables et des vues

Nom de la colonne	Description
OWNER	Name of the owner of the object
TABLE_NAME	Name of the object
COLUMN_NAME	Name of the column
COMMENTS	Comment on the object

DBA_COL_PRIVS

liste les droits sur les colonnes des tables

Nom de la colonne	Description
GRANTEE	Name of the user to whom access was granted
OWNER	Username of the owner of the object
TABLE_NAME	Name of the object
COLUMN_NAME	Name of the column
GRANTOR	Name of the user who performed the grant
PRIVILEGE	Column privilege
GRANTABLE	Privilege is grantable

DBA_CONSTRAINTS

infos sur les contraintes

Nom de la colonne	Description
OWNER	Owner of the table
CONSTRAINT_NAME	Name associated with constraint definition
CONSTRAINT_TYPE	Type of constraint definition
TABLE_NAME	Name associated with table with constraint definition
SEARCH_CONDITION	Text of search condition for table check
R_OWNER	Owner of table used in referential constraint
R_CONSTRAINT_NAME	Owner of table used in referential constraint
DELETE_RULE	The delete rule for a referential constraint
STATUS	Enforcement status of constraint: ENABLED or DISABLED

DBA_CONS_COLUMNS

colonnes accessibles dans les contraintes

Nom de la colonne	Description
CONSTRAINT_NAME	Name associated with the constraint definition
TABLE_NAME	Name associated with table with constraint definition
COLUMN_NAME	Name associated with column specified in the constraint definition
POSITION	Original position of column in definition

DBA_DATA_FILES

fichiers physiques de données

Nom de la colonne	Description
FILE_NAME	Name of the database file
FILE_ID	ID of the database file
TABLESPACE_NAME	Name of the tablespace to which the file belongs
BYTES	Size of the file in bytes
BLOCKS	Size of the file in Oracle blocks
STATUS	File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)

DBA_DB_LINKS

database links

Nom de la colonne	Description
OWNER	Owner of the database link
DB_LINK	Name of the database link
USERNAME	Name of user to log in as
HOST	SQL*Net string for connect
CREATED	Creation time of the database link

DBA_DDL_LOCKS

verrous sur les structures de données

Nom de la colonne	Description
SESSION_ID	Session identifier
OWNER	Owner of the lock
NAME	Name of the lock
TYPE	Lock type: Cursor, Table/Procedure, Body, Trigger, Index, Cluster
MODE_HELD	Lock mode: None, Null, Share, Exclusive
MODE_REQUESTED	Lock request type: None, Null, Share, Exclusive

DBA_DEPENDENCIES

dépendances entre objets

Nom de la colonne	Description
OWNER	Owner of the object
NAME	Name of the object
TYPE	Type of the object
REFERENCED_OWNER	Owner of referenced object (remote owner if remote object)
REFERENCED_NAME	Name of referenced object
REFERENCED_TYPE	Type of referenced object
REFERENCED_LINK_NAME	Name of dblink if this is a remote object

DBA_DML_LOCKS

verrous sur les données

Nom de la colonne	Description
SESSION_ID	Session holding or acquiring the lock
OWNER	Owner of the lock
NAME	Name of the lock
MODE_HELD	Lock mode
MODE_REQUESTED	Lock request type

DBA_FREE_SPACE_COALESCED

statistiques sur les blocs fusionnés dans les tablespaces.

Nom de la colonne	Type colonne	Null?	Description
TABLESPACE_NAME	VARCHAR2(30)	not null	Name of tablespace
TOTAL_EXTENTS	NUMBER		Total number of free extents in tablespace
EXTENTS_COALESCED	NUMBER		Total number of coalesced free extents in tablespace
PERCENT_EXTENTS_ COALESCED	NUMBER		Percentage of coalesced free extents in tablespace
TOTAL_BYTES	NUMBER		Total number of free bytes in tablespace
BYTES_COALESCED	NUMBER		Total number of coalesced free bytes in tablespace
TOTAL_BLOCKS	NUMBER		Total number of free Oracle blocks in tablespace
BLOCKS_COALESCED	NUMBER		Total number of coalesced free Oracle blocks in tablespace
PERCENT_BLOCKS_ COALESCED	NUMBER		Percentage of coalesced free Oracle blocks in tablespace

DBA_ERRORS

erreurs sur les objets stockés (packages, procédures, etc.)

Nom de la colonne	Description
OWNER	The owner of the object
NAME	Name of the object
TYPE	Type of object: VIEW, PROCEDURE, FUNCTION, PACKAGE, or PACKAGE BODY
SEQUENCE	Sequence number used for ordering purposes
LINE	Line number at which this error occurs
POSITION	Position in the line at which this error occurs
TEXT	Text of the error

DBA_EXP_FILES

infos sur les fichiers d'export

Nom de la colonne	Description
EXP_VERSION	Version number of the export session
EXP_TYPE	Type of export file: full, cumulative, or incremental
FILE_NAME	Name of the export file
USER_NAME	Name of user who executed export
TIMESTAMP	Timestamp of the export session

DBA_EXP_OBJECTS

liste des objets exportés de manière différentielle (incremental)

Nom de la colonne	Description
OWNER	Owner of exported object
OBJECT_NAME	Name of exported object
OBJECT_TYPE	Type of exported object
CUMULATIVE	Timestamp of last cumulative export
INCREMENTAL	Timestamp of last incremental export
EXPORT_VERSION	The ID of the export session

DBA_EXP_VERSION

version de la dernière session d'export

Nom de la colonne	Description
EXP_VERSION	Version number of the last export session

DBA_EXTENTS

liste des extents de tous les segments de la base

Nom de la colonne	Description
OWNER	Owner of the segment associated with the extent
SEGMENT_NAME	Name of the segment associated with the extent
SEGMENT_TYPE	Type of the segment
TABLESPACE_NAME	Name of the tablespace containing the extent
EXTENT_ID	Extent number in the segment
FILE_ID	Name of the file containing the extent
BLOCK_ID	Starting block number of the extent
BYTES	Size of the extent in bytes
BLOCKS	Size of the extent in Oracle blocks

DBA_FREE_SPACE

Tespaces libres (trous) dans les tablespaces.

Nom de la colonne	Description
TABLESPACE_NAME	Name of the tablespace containing the extent
FILE_ID	ID number of the file containing the extent
BLOCK_ID	Starting block number of the extent
BYTES	Size of the extent in bytes
BLOCKS	Size of the extent in Oracle blocks

DBA_INDEXES

Description des indexs

Nom de la colonne	Description
AVG_LEAF_BLOCKS_PER_ KEY	The average number of leaf blocks per key
AVG_DATA_BLOCKS_PER_ KEY	The average number of data blocks per key
CLUSTERING_FACTOR	A measurement of the amount of (dis)order of the table this index is for
STATUS	Whether index is in Direct Load State
OWNER	Username of the owner of the index
INDEX_NAME	Name of the index
TABLE_OWNER	Owner of the indexed object
TABLE_NAME	Name of the indexed object
TABLE_TYPE	Type of the indexed object
UNIQUENESS	Uniqueness status of the index: UNIQUE or NONUNIQUE
TABLESPACE_NAME	Name of the tablespace containing the index
INI_TRANS	Initial number of transactions
MAX_TRANS	Maximum number of transactions
INITIAL_EXTENT	Size of the initial extent
NEXT_EXTENT	Size of secondary extents
MIN_EXTENTS	Minimum number of extents allowed in the segment
PCT_INCREASE	Percentage increase in extent size
FREELISTS	Number of process freelists allocated to this segment
PCT_FREE	Minimum percentage of free space in a block
BLEVEL	B-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	The number of leaf blocks in the index
DISTINCT_KEYS	The number of distinct keys in the index

DBA_IND_COLUMNS

Description des colonnes d'index

Nom de la colonne	Description
INDEX_OWNER	Index owner
INDEX_NAME	Index name
TABLE_OWNER	Table or cluster owner
TABLE_NAME	Table or cluster name
COLUMN_NAME	Column name
COLUMN_POSITION	Position of column within index
COLUMN_LENGTH	Indexed length of the column

DBA_JOBS

Liste des jobs

Nom de la colonne	Description
JOB	Identifier of job. Neither import/export nor repeated executions change it.
LOG_USER	USER who was logged in when the job was submitted
PRIV_USER	USER whose default privileges apply to this job
SCHEMA_USER	Default schema used to parse the job For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.
LAST_DATE	Date that this job last successfully executed
LAST_SEC	Same as LAST_DATE. This is when the last successful execution started.
THIS_DATE	Date that this job started executing (usually null if not executing)
THIS_SEC	Same as THIS_DATE. This is when the last successful execution started.
NEXT_DATE	Date that this job will next be executed
NEXT_SEC	Same as NEXT_DATE. The job becomes due for execution at this time.
TOTAL_TIME	Total wallclock time spent by the system on this job, in seconds
BROKEN	If Y, no attempt is made to run this job.
INTERVAL	A date function, evaluated at the start of execution, becomes next NEXT_DATE
FAILURES	How many times has this job started and failed since its last success?
WHAT	Body of the anonymous PL/SQL block that this job executes
CURRENT_SESSION_LABEL	Trusted Oracle7 Server label of the current session as seen by the job. Applies to Trusted Oracle7 Server only.
CLEARANCE_HI	Highest level of clearance available to the job. Applies to Trusted Oracle7 Server only.
CLEARANCE_LO	Lowest level of clearance available to the job. Applies to Trusted Oracle7 Server only.
NLS_ENV	ALTER SESSION parameters describing the NLS environment of the job
MISC_ENV	Other session parameters that apply to this job

DBA_JOBS_RUNNING

infos sur les jobs en cours

Nom de la colonne	Description
SID	Identifier of process that is executing the job. .
JOB	Identifier of job. This job is currently executing.
FAILURES	How many times has this job started and failed since its last success?
LAST_DATE	Date that this job last successfully executed
LAST_SEC	Same as LAST_DATE. This is when the last successful execution started.
THIS_DATE	Date that this job started executing (usually null if not executing)
THIS_SEC	Same as THIS_DATE. This is when the last successful execution started.

DBA_LOCKS

verrous posés et en attentes sur les ressources de la base

Nom de la colonne	Description
SESSION_ID	Session holding or acquiring the lock
TYPE	Lock type
MODE HELD	Lock mode
MODE REQUESTED	Lock mode requested
LOCK_ID1	Type-specific lock identifier, part 1
LOCK_ID2	Type-specific lock identifier, part 2
DEGREE	The number of threads per instance for scanning the cluster
INSTANCES	The number of instances across which the cluster is to be scanned
CACHE	Whether the cluster is to be cached in the buffer cache

DBA_OBJECTS

infos tous les objets (tables, index, synonymes, vues, etc.) !!

Nom de la colonne	Description
OWNER	Username of the owner of the object
OBJECT_NAME	Name of the object
OBJECT_ID	Object number of the object
OBJECT_TYPE	Type of the object
CREATED	Timestamp for the creation of the object
LAST_DDL_TIME	Timestamp for the last DDL change (including GRANT and REVOKE) to the object
TIMESTAMP	Timestamp for the specification of the object
STATUS	Status of the object

DBA_OBJECT_SIZE

taille des objets stockés

Nom de la colonne	Description
OWNER	Owner of the object
NAME	Name of the object
TYPE	Type of the object: TABLE, VIEW, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, or PACKAGE BODY
SOURCE_SIZE	Size of the source in bytes
PARSED_SIZE	Size of the parsed form of the object in bytes
CODE_SIZE	Code size in bytes
ERROR_SIZE	Size of error messages in bytes

DBA_OBJ_AUDIT_OPTS

options d'audit sur les objets

Nom de la colonne	Description
OWNER	Owner of the object
OBJECT_NAME	Name of the object
OBJECT_TYPE	Type of the object
ALT	Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
AUD	Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
COM	Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
DEL	Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
GRA	Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
IND	Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
INS	Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
LOC	Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REN	Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
SEL	Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
UPD	Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REF	Auditing REFERENCE WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)
EXE	Auditing EXE WHENEVER SUCCESSFUL / UNSUCCESSFUL

DBA_PRIV_AUDIT_OPTS

audit en cours sur les privilèges

Nom de la colonne	Description
USER_NAME	User name if by user auditing, else null for system-wide auditing
PRIVILEGE	Name of the system privilege being audited
SUCCESS	Mode for WHENEVER SUCCESSFUL system auditing
FAILURE	Mode for WHENEVER NOT SUCCESSFUL system auditing

DBA_PROFILES

infos sur les profils utilisateurs

Nom de la colonne	Description
PROFILE	Profile name
RESOURCE_NAME	Resource name
LIMIT	Limit placed on this resource for this profile

DBA_ROLES

infos sur les rôles

Nom de la colonne	Description
ROLE	Role name
PASSWORD_REQUIRED	Indicates if the role requires a password to be enabled

DBA_ROLE_PRIVS

rôles cédés à des utilisateurs ou a des rôles

Nom de la colonne	Description
GRANTEE	Grantee name, user or role receiving the grant
GRANTED_ROLE	Granted role name
ADMIN_OPTION	Grant was with the ADMIN option: YES/NO
DEFAULT_ROLE	Role is designated as a DEFAULT ROLE for the user: YES/NO

DBA_ROLLBACK_SEGS

Descriptions desrollback segments.

Nom de la colonne	Description
SEGMENT_NAME	Name of the rollback segment
OWNER	Owner of the rollback segment
TABLESPACE_NAME	Name of the tablespace containing the rollback segment
SEGMENT_ID	ID number of the rollback segment
FILE_ID	ID number of the file containing the segment head
BLOCK_ID	ID number of the block containing the segment header
INITIAL_EXTENT	Initial extent size in bytes
NEXT_EXTENT	Secondary extent size in bytes
MIN_EXTENTS	Minimum number of extents
MAX_EXTENTS	Maximum number of extent
PCT_INCREASE	Percent increase for extent size
STATUS	Rollback segment status
INSTANCE_NUM	Rollback segment owning parallel server instance number

DBA_SEGMENTS

infos sur les espaces alloués pour les segments

Nom de la colonne	Description
OWNER	Username of the segment owner
SEGMENT_NAME	Name, if any, of the segment
SEGMENT_TYPE	Type of segment: TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, or CACHE
TABLESPACE_NAME	Name of the tablespace containing the segment
HEADER_FILE	ID of the file containing the segment header
HEADER_BLOCK	ID of the block containing the segment header
BYTES	Size in bytes, of the segment
BLOCKS	Size, in Oracle blocks, of the segment
EXTENTS	Number of extents allocated to the segment
INITIAL_EXTENT	Size in bytes of the initial extent of the segment
NEXT_EXTENT	Size in bytes of the next extent to be allocated to the segment
MIN_EXTENTS	Minimum number of extents allowed in the segment
MAX_EXTENTS	Maximum number of extents allowed in the segment
PCT_INCREASE	Percent by which to increase the size of the next extent to be allocated
FREELISTS	Number of process freelists allocated to this segment
FREELIST_GROUPS	Number of freelist groups allocated to this segment

DBA_SEQUENCES

Description des SEQUENCEs

Nom de la colonne	Description
SEQUENCE_OWNER	Name of the owner of the sequence
SEQUENCE_NAME	Sequence name
MIN_VALUE	Minimum value of the sequence
MAX_VALUE	Maximum value of the sequence
INCREMENT_BY	Value by which sequence is incremented
CYCLE_FLAG	Does sequence wrap around on reaching limit?
ORDER_FLAG	Are sequence numbers generated in order?
CACHE_SIZE	Number of sequence numbers to cache
LAST_NUMBER	Last sequence number written to disk

DBA_SNAPSHOTS

description des clichés

Nom de la colonne	Description
OWNER	Owner of the snapshot
NAME	The view used by users and applications for viewing the snapshot
TABLE_NAME	Table the snapshot is stored in; has an extra column for the master rowid
MASTER_VIEW	View of the master table, owned by the snapshot owner, used for refreshes
MASTER_OWNER	Owner of the master table
MASTER	Name of the master table of which this snapshot is a copy
MASTER_LINK	Database link name to the master site
CAN_USE_LOG	If NO, this snapshot is complex and will never use a log
UPDATABLE	If NO, the snapshot is read only
LAST_REFRESH	SYSDATE from the master site at the time of the last refresh
ERROR	The number of failed automatic refreshes since last successful refresh
TYPE	The type of refresh (complete, fast, force) for all automatic refreshes
NEXT	The date function used to compute next refresh dates
START_WITH	The date function used to compute next refresh dates
REFRESH_GROUP	All snapshots in a given refresh group get refreshed in the same transaction
UPDATE_TRIG	The name of the trigger that fills the UPDATE_LOG
UPDATE_LOG	The table that logs changes made to an updatable snapshots
QUERY	The original query of which this snapshot is an instantiation

DBA_SNAPSHOT_LOGS

description des traces des clichés

Nom de la colonne	Description
LOG_OWNER	Owner of the snapshot log
MASTER	Name of the master table of which the log logs changes
LOG_TABLE	Log table; holds rowids and timestamps of rows that changed in the master
LOG_TRIGGER	An after-row trigger on the master which inserts rows into the log
CURRENT_SNAPSHOTS	One date per snapshot; the date the snapshot of the master last refreshed

DBA_SOURCE

Code Source des objets stockés

Nom de la colonne	Description
OWNER	Owner of the object
NAME	Name of the object
TYPE	Type of the object: PROCEDURE, FUNCTION, PACKAGE, or PACKAGE BODY
LINE	Line number of this line of source
TEXT	Source text

DBA_STMT_AUDIT_OPTS

option d'audit

Nom de la colonne	Description
USER_NAME	User name if by user auditing, else null for system-wide auditing
AUDIT_OPTION	Name of the system auditing option
SUCCESS	Mode for WHENEVER SUCCESSFUL system auditing
FAILURE	Mode for WHENEVER NOT SUCCESSFUL system auditing

DBA_SYNONYMS

Nom de la colonne	Description
OWNER	Username of the owner of the synonym
SYNONYM_NAME	Name of the synonym
TABLE_OWNER	Owner of the object referenced by the synonym
TABLE_NAME	Name of the object referenced by the synonym
DB_LINK	Name of the database link referenced in a remote synonym

DBA_SYS_PRIVS

privilèges cédés aux users et aux roles.

Nom de la colonne	Description
GRANTEE	Grantee name, user, or role receiving the grant
PRIVILEGE	System privilege
ADMIN_OPTION	Grant was with the ADMIN option

DBA_TABLES

description des tables (avec statistiques)

Nom de la colonne	Description
EMPTY_BLOCKS	The number of empty (never used) data blocks in the table
AVG_SPACE	The average available free space in the table
CHAIN_CNT	The number of chained rows in the table
AVG_ROW_LEN	The average row length, including row overhead
DEGREE	The number of threads per instance for scanning the table
INSTANCES	The number of instances across which the table is to be scanned
CACHE	Whether the table is to be cached in the buffer cache
OWNER	Owner of the table
TABLE_NAME	Name of the table
TABLESPACE_NAME	Name of the tablespace containing the table
CLUSTER_NAME	Name of the cluster, if any, to which the table belongs
PCT_FREE	Minimum percentage of free space in a block
PCT_USED	Minimum percentage of used space in a block
INI_TRANS	Initial number of transactions
MAX_TRANS	Maximum number of transactions
INITIAL_EXTENT	Size of the initial extent in bytes
NEXT_EXTENT	Size of secondary extents in bytes
MIN_EXTENTS	Minimum number of extents allowed in the segment
MAX_EXTENTS	Maximum number of extents allowed in the segment
PCT_INCREASE	Percentage increase in extent size
FREELISTS	Number of process freelists allocated to this segment
FREELIST_GROUPS	Number of freelist groups allocated to this segment
BACKED_UP	Has table been backed up since last modification?
NUM_ROWS	The number of rows in the table
BLOCKS	The number of used data blocks in the table

DBA_TABLESPACES

description des partitions logiques

Nom de la colonne	Description
TABLESPACE_NAME	Tablespace name
INITIAL_EXTENT	Default initial extent size
NEXT_EXTENT	Default incremental extent size
MIN_EXTENTS	Default minimum number of extents
MAX_EXTENTS	Default maximum number of extents
PCT_INCREASE	Default percent increase for extent size
STATUS	Tablespace status: ONLINE, OFFLINE, or READ ONLY

DBA_TAB_COLUMNS

Description des colonnes des tables

Nom de la colonne	Description
OWNER	Owner of the table, view, or cluster
TABLE_NAME	Table, view, or cluster name
COLUMN_NAME	Column name
DATA_TYPE	Type colonne of the column
DATA_LENGTH	Length of the column in bytes
DATA_PRECISION	Decimal precision for NUMBER Type colonne; binary precision for FLOAT Type colonne; NULL for all other Type colonnes
DATA_SCALE	Digits to right of decimal point in a number
NULLABLE	Does column allow NULL values?
COLUMN_ID	Sequence number of the column as created
DEFAULT_LENGTH	Length of default value for the column
NUM_DISTINCT	The number of distinct values for the column
LOW_VALUE	The smallest value for the column, expressed in hexadecimal notation for the internal representation of the first 32 bytes of the value
HIGH_VALUE	The highest value for the column, expressed in hexadecimal notation for the internal representation of the first 32 bytes of the value
DENSITY	The density of the column (a measure of how distinct the values are). The density is calculated as the sum of occurrences²/elements_sampled² for each distinct value in the column.

DBA_TAB_COMMENTS

commentaires saisis sur les tables et les vues

Nom de la colonne	Description
OWNER	Owner of the object
TABLE_NAME	Name of the object
TABLE_TYPE	Type of the object
COMMENTS	Comment on the object

DBA_TAB_PRIVS

liste des droits au niveau objet

Nom de la colonne	Description
GRANTEE	User to whom access was granted
OWNER	Owner of the object
TABLE_NAME	Name of the object
GRANTOR	Name of the user who performed the grant
PRIVILEGE	Table Privilege
GRANTABLE	Privilege is grantable

DBA_TRIGGERS

Nom de la colonne	Description
OWNER	Owner of the trigger
TRIGGER_NAME	Name of the trigger
TRIGGER_TYPE	When the trigger fires: BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT
TRIGGERING_EVENT	Statement that will fire the trigger: INSERT, UPDATE and/or DELETE
TABLE_OWNER	Owner of the table with which this trigger is associated
REFERENCING_NAMES	Names used for referencing OLD and NEW values within the trigger
WHEN_CLAUSE	WHEN clause must evaluate to true in order for triggering body to execute
STATUS	If DISABLED, then trigger will not fire
Description	Trigger Description, useful for re-creating trigger creation statement
TRIGGER_BODY	Action taken by this trigger when it fires

DBA_TRIGGER_COLS

utilisation des colonnes au sein des triggers

Nom de la colonne	Description
TRIGGER_OWNER	Owner of the trigger
TRIGGER_NAME	Name of the trigger
TABLE_OWNER	Owner of the table
TABLE_NAME	Name of the table on which the trigger is defined
COLUMN_NAME	Name of the column used in trigger definition
COLUMN_LIST	Is column specified in UPDATE OF clause?
COLUMN_USAGE	Usage of column within trigger body

DBA_TS_QUOTAS

Quotas d'utilisation des tablespaces par les utilisatuers.

Nom de la colonne	Description
TABLESPACE_NAME	Tablespace name
USERNAME	User with resource rights on the tablespace
BYTES	Number of bytes charged to the user
MAX_BYTES	User's quota in bytes, or -1 if no limit.
BLOCKS	Number of Oracle blocks charged to the user
MAX_BLOCKS	User's quota in Oracle blocks, or -1 if no limit.

DBA_UPDATABLE_COLUMNS

colonnes modifiables à travers une vue par le DBA

Nom de la colonne	Type colonne	Null?	Description
OWNER	VARCHAR2(30)	not null	Table owner
TABLE_NAME	VARCHAR2(30)	not null	Table name
COLUMN_NAME	VARCHAR2(30)	not null	Column name
UPDATABLE	VARCHAR2(3)		Is the column updatable?

DBA_USERS

les utilisateurs déclarés de la base (y compris SYS et SYSTEM...)

Nom de la colonne	Description
USERNAME	Name of the user
USER_ID	ID number of the user
PASSWORD	Encrypted password
DEFAULT_TABLESPACE	Default tablespace for data
TEMPORARY_TABLESPACE	Default tablespace for temporary table
CREATED	User creation date
PROFILE	User resource profile name

DBA_VIEWS

description des vues

Nom de la colonne	Description
OWNER	Owner of the view
VIEW_NAME	Name of the view
TEXT_LENGTH	Length of the view text
TEXT	View text

DBA_2PC_NEIGHBORS

informations sur les transactions en attentes

Nom de la colonne	Description
LOCAL_TRAN_ID	Local identifier of a transaction
IN_OUT	IN for incoming connections, OUT for outgoing
DATABASE	IN: client database name; OUT: outgoing database link
DBUSER_OWNER	IN: name of local user; OUT: owner of database link
DBID	The database ID at the other end of the connection
SESS#	Session number at this database of the connection
BRANCH	Transaction branch ID at this database of the connection

DBA_2PC_PENDING

transactions distribuées en attente de restauration

Nom de la colonne	Description
LOCAL_TRAN_ID	String of form: n.n.n; n is a number
GLOBAL_TRAN_ID	Globally unique transaction ID
STATE	Collecting, prepared, committed, forced commit, or forced rollback
MIXED	YES => part of the transaction committed and part rolled back
ADVICE	C for commit, R for rollback, else null
TRAN_COMMENT	Text for "commit work comment text"
FAIL_TIME	Value of SYSDATE when the row was inserted (tx or system recovery)
FORCE_TIME	Time of manual force decision (null if not forced locally)
RETRY_TIME	Time automatic recovery (RECO) last tried to recover the transaction
OS_USER	Operating system-specific name for the end-user
OS_TERMINAL	Operating system-specific name for the end-user terminal
HOST	Name of the host machine for the end-user
DB_USER	Oracle user name of the end-user at the topmost database
COMMIT#	Global commit number for committed transactions