DBA_TAB_STATS_HISTORY

DBA_TAB_STATS_HISTORY provides a history of table statistics modifications for all tables in the database. Its columns are the same as those in "ALL_TAB_STATS_HISTORY".

Related Views

· ALL_TAB_STATS_HISTORY provides a history of table statistics modifications for all tables accessible to the current user.

· USER_TAB_STATS_HISTORY provides a history of table statistics modifications for all tables owned by the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the object
TABLE_NAME	VARCHAR2(30)		Name of the table
PARTITION_NAME	VARCHAR2(30)		Name of the partition
SUBPARTITION_NAME	VARCHAR2(30)		Name of the subpartition
STATS_UPDATE_TIME	TIMESTAMP(6) WITH TIME ZONE		Time at which the statistics were updated

Note:

1.

select * from DBA_TAB_STATS_HISTORY;

OWNER	TABLE_NAME	PARTITION_NAME	SUBPARTITION_ NAME	STATS_UPDATE_TIME
SYS	WRH$_WAITSTAT	WRH$_WAITST_2334540272_19812		2008-09-19 2:19:23.571565 AM -07:00
SYS	WRH$_ACTIVE_ SESSION_HISTORY	WRH$_ACTIVE_2334540272_19812		2008-09-19 2:19:22.057698 AM -07:00
SDE	SDE_LOGPOOL_747			2008-09-19 2:19:19.718277 AM -07:00
SDE	SDE_LOGPOOL_754			2008-09-19 2:19:19.691166 AM -07:00
SDE	SDE_LOGPOOL_752			2008-09-19 2:19:19.668491 AM -07:00
CTXSYS	DR$DELETE			2008-09-19 2:19:19.568060 AM -07:00
CTXSYS	DR$PENDING			2008-09-19 2:19:18.876137 AM -07:00

Oracle data dictionary views

Oracle dynamic performance views

DBA_OPTSTAT_OPERATIONS

DBA_OPTSTAT_OPERATIONS contains a history of statistics operations performed at the schema and database level using the DBMS_STATS package.

Column	Datatype	NULL	Description
OPERATION	VARCHAR2(64)		Operation name
TARGET	VARCHAR2(64)		Target on which the operation was performed
START_TIME	TIMESTAMP(6) WITH TIME ZONE		Time at which the operation started
END_TIME	TIMESTAMP(6) WITH TIME ZONE		Time at which the operation ended

Note:

1.

select * from DBA_OPTSTAT_OPERATIONS;

OPERATION	TARGET	START_TIME	END_TIME
gather_database_stats(auto)		2008-09-18 10:00:04.094807 PM -07:00	2008-09-19 2:19:30.097811 AM -07:00
gather_database_stats(auto)		2008-09-17 10:00:03.507576 PM -07:00	2008-09-18 1:47:10.373073 AM -07:00
gather_database_stats(auto)		2008-09-16 10:00:02.837555 PM -07:00	2008-09-16 11:54:34.649091 PM -07:00
gather_database_stats(auto)		2008-09-15 10:00:02.673267 PM -07:00	2008-09-15 11:45:36.426822 PM -07:00
gather_database_stats(auto)		2008-09-13 6:00:05.952363 AM -07:00	2008-09-13 6:44:52.736266 AM -07:00
gather_database_stats(auto)		2008-09-12 10:00:02.384919 PM -07:00	2008-09-13 12:52:39.275995 AM -07:00

Oracle data dictionary views

Oracle dynamic performance views

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_MANAGER_SYSTEM_PRIVS displays information about all the users and roles that have been granted the ADMINISTER_RESOURCE_MANAGER system privilege, which is granted using the DBMS_RESOURCE_MANAGER_PRIVS package. This privilege is not granted through the GRANT SQL statement.

Related View

USER_RSRC_MANAGER_SYSTEM_PRIVS displays information about the users who are granted system privileges for the DBMS_RESOURCE_MANAGER package. This view does not display the GRANTEE column.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	User or role receiving the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Name of the system privilege
ADMIN_OPTION	VARCHAR2(3)		Indicates whether the grant was with the ADMIN option (YES) or not (NO)

Note:

1.

select * from DBA_RSRC_MANAGER_SYSTEM_PRIVS;

GRANTEE	PRIVILEGE	ADMIN_OPTION
DBA	ADMINISTER RESOURCE MANAGER	YES
SYS	ADMINISTER RESOURCE MANAGER	NO
MDSYS	ADMINISTER RESOURCE MANAGER	YES
WKSYS	ADMINISTER RESOURCE MANAGER	NO
EXP_FULL_DATABASE	ADMINISTER RESOURCE MANAGER	NO
IMP_FULL_DATABASE	ADMINISTER RESOURCE MANAGER	NO

Oracle data dictionary views

Oracle dynamic performance views

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUP_PRIVS displays information about all resource consumer groups and the users and roles assigned to them. The grant referred to in this view and the related view is the grant of the SWITCH_CONSUMER_GROUP object privilege, which is granted using the DBMS_RESOURCE_MANAGER_PRIVS package. This privilege is not granted through the GRANT SQL statement.

Related View

USER_RSRC_CONSUMER_GROUP_PRIVS displays information about the resource consumer groups to which the current user is assigned. This view does not display the GRANTEE column.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	User or role receiving the grant
GRANTED_GROUP	VARCHAR2(30)		Granted consumer group name
GRANT_OPTION	VARCHAR2(3)		Indicates whether the grant was with the GRANT option (YES) or not (NO)
INITIAL_GROUP	VARCHAR2(3)		Indicates whether the consumer group is designated as the default for this user or role (YES) or not (NO)

Note:

1.

select * from DBA_RSRC_CONSUMER_GROUP_PRIVS;

GRANTEE	GRANTED_GROUP	GRANT_OPTION	INITIAL_GROUP
PUBLIC	LOW_GROUP	NO	NO
PUBLIC	DEFAULT_CONSUMER_GROUP	YES	YES
SYSTEM	SYS_GROUP	NO	YES

Oracle data dictionary views

Oracle dynamic performance views

DBA_AQ_AGENT_PRIVS

DBA_AQ_AGENT_PRIVS displays information about the registered AQ agents that are mapped to all users in the database.

Related View

USER_AQ_AGENT_PRIVS displays information about the registered AQ agents that are mapped to the current user. This view does not display the DB_USERNAME column.

Column	Datatype	NULL	Description
AGENT_NAME	VARCHAR2(30)	NOT NULL	Name of the AQ agent
DB_USERNAME	VARCHAR2(30)		Name of the database user that the agent maps to
HTTP_ENABLED	VARCHAR2(4)		Indicates whether the agent is allowed to access AQ through HTTP (YES) or not (NO)
SMTP_ENABLED	VARCHAR2(4)		Indicates whether the agent is allowed to access AQ through SMTP (YES) or not (NO)

Note:

1.

select * from DBA_AQ_AGENT_PRIVS;

AGENT_NAME	DB_USERNAME	HTTP_ENABLED	SMTP_ENABLED
HAE_SUB		NO	NO
SCHEDULER$_EVENT_AGENT	SYS	NO	NO
SERVER_ALERT	SYS	NO	NO

Oracle data dictionary views

Oracle dynamic performance views

DBA_COL_PRIVS

DBA_COL_PRIVS describes all column object grants in the database.

Related View

USER_COL_PRIVS describes the column object grants for which the current user is the object owner, grantor, or grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

Oracle data dictionary views

Oracle dynamic performance views