|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_REPRESOL_STATS_CONTROL: Information about statistics collection for
conflict resolutions for all replicated tables in the database
iSelfSchooling-SQL> desc DBA_REPRESOL_STATS_CONTROL;
Name
Null? Type
-----------------------------
-------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
STATUS
VARCHAR2(9)
STATUS_UPDATE_DATE
NOT NULL DATE
PURGED_DATE
DATE
LAST_PURGE_START_DATE
DATE
LAST_PURGE_END_DATE
DATE
DBA_REPSCHEMA: N-way replication information
iSelfSchooling-SQL> desc DBA_REPSCHEMA;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
MASTER
VARCHAR2(1)
PROP_UPDATES
NUMBER
MY_DBLINK
VARCHAR2(1)
GNAME
NOT NULL VARCHAR2(30)
GROUP_OWNER
NOT NULL VARCHAR2(30)
DBA_REPSITES: N-way replication information
iSelfSchooling-SQL> desc DBA_REPSITES;
Name
Null? Type
-----------------------------
-------- --------------------
GNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
MASTER
VARCHAR2(1)
PROP_UPDATES
NUMBER
MY_DBLINK
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
DBA_REPSITES_NEW: Information about new masters for replication
extension
iSelfSchooling-SQL> desc DBA_REPSITES_NEW;
Name
Null? Type
----------------------------- -------- --------------------
EXTENSION_ID
NOT NULL RAW(16)
GOWNER
NOT NULL VARCHAR2(30)
GNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
FULL_INSTANTIATION
VARCHAR2(1)
MASTER_STATUS
VARCHAR2(13)
DBA_RESOURCE_INCARNATIONS: Resource incarnations that are running or
eligible for HA status notification
iSelfSchooling-SQL> desc DBA_RESOURCE_INCARNATIONS;
Name
Null? Type
-----------------------------
-------- --------------------
RESOURCE_TYPE
NOT NULL VARCHAR2(30)
RESOURCE_NAME
VARCHAR2(256)
DB_UNIQUE_NAME
NOT NULL VARCHAR2(30)
DB_DOMAIN
NOT NULL VARCHAR2(128)
INSTANCE_NAME
NOT NULL VARCHAR2(30)
HOST_NAME
VARCHAR2(512)
STARTUP_TIME
TIMESTAMP(9)
DBA_RESUMABLE: Resumable session information in the system
iSelfSchooling-SQL> desc DBA_RESUMABLE;
Name
Null? Type
----------------------------- -------- --------------------
USER_ID
NUMBER
SESSION_ID
NUMBER
INSTANCE_ID
NUMBER
COORD_INSTANCE_ID
NUMBER
COORD_SESSION_ID
NUMBER
STATUS
VARCHAR2(9)
TIMEOUT
NUMBER
START_TIME
VARCHAR2(20)
SUSPEND_TIME
VARCHAR2(20)
RESUME_TIME
VARCHAR2(20)
NAME
VARCHAR2(4000)
SQL_TEXT
VARCHAR2(1000)
ERROR_NUMBER
NUMBER
ERROR_PARAMETER1
VARCHAR2(80)
ERROR_PARAMETER2
VARCHAR2(80)
ERROR_PARAMETER3
VARCHAR2(80)
ERROR_PARAMETER4
VARCHAR2(80)
ERROR_PARAMETER5
VARCHAR2(80)
ERROR_MSG
VARCHAR2(4000)
DBA_REWRITE_EQUIVALENCES: Description of rewrite equivalence accessible to
DBA
iSelfSchooling-SQL> desc DBA_REWRITE_EQUIVALENCES;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
SOURCE_STMT
CLOB
DESTINATION_STMT
CLOB
REWRITE_MODE
VARCHAR2(10)
DBA_RGROUP: All refresh groups. This view is not a join.
iSelfSchooling-SQL> desc DBA_RGROUP;
Name
Null? Type
----------------------------- -------- --------------------
REFGROUP
NUMBER
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
IMPLICIT_DESTROY
VARCHAR2(1)
PUSH_DEFERRED_RPC
VARCHAR2(1)
REFRESH_AFTER_ERRORS
VARCHAR2(1)
ROLLBACK_SEG
VARCHAR2(30)
JOB
NOT NULL NUMBER
PURGE_OPTION
NUMBER(38)
PARALLELISM
NUMBER(38)
HEAP_SIZE
NUMBER(38)
DBA_ROLES: All Roles which exist in the database
iSelfSchooling-SQL> desc DBA_ROLES;
Name
Null? Type
----------------------------- -------- --------------------
ROLE
NOT NULL VARCHAR2(30)
PASSWORD_REQUIRED
VARCHAR2(8)
DBA_ROLE_PRIVS: Roles granted to users and roles
iSelfSchooling-SQL> desc DBA_ROLE_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
VARCHAR2(30)
GRANTED_ROLE
NOT NULL VARCHAR2(30)
ADMIN_OPTION
VARCHAR2(3)
DEFAULT_ROLE
VARCHAR2(3)
DBA_ROLLBACK_SEGS: Description of rollback segments
iSelfSchooling-SQL> desc DBA_ROLLBACK_SEGS;
Name
Null? Type
----------------------------- -------- --------------------
SEGMENT_NAME
NOT NULL VARCHAR2(30)
OWNER
VARCHAR2(6)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
SEGMENT_ID
NOT NULL NUMBER
FILE_ID
NOT NULL NUMBER
BLOCK_ID
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT NULL NUMBER
PCT_INCREASE
NUMBER
STATUS
VARCHAR2(16)
INSTANCE_NUM
VARCHAR2(40)
RELATIVE_FNO
NOT NULL NUMBER
DBA_RSRC_CONSUMER_GROUPS: all the resource consumer groups
iSelfSchooling-SQL> desc DBA_RSRC_CONSUMER_GROUPS;
Name
Null? Type
-----------------------------
-------- --------------------
CONSUMER_GROUP
VARCHAR2(30)
CPU_METHOD
VARCHAR2(30)
COMMENTS
VARCHAR2(2000)
STATUS
VARCHAR2(30)
MANDATORY
VARCHAR2(3)
DBA_RSRC_CONSUMER_GROUP_PRIVS:
Switch
privileges for consumer groups
iSelfSchooling-SQL> desc DBA_RSRC_CONSUMER_GROUP_PRIVS;
Name
Null? Type
-----------------------------
-------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
GRANTED_GROUP
VARCHAR2(30)
GRANT_OPTION
VARCHAR2(3)
INITIAL_GROUP
VARCHAR2(3)
DBA_RSRC_GROUP_MAPPINGS: all the consumer group mappings
iSelfSchooling-SQL> desc DBA_RSRC_GROUP_MAPPINGS;
Name
Null? Type
----------------------------- -------- --------------------
ATTRIBUTE
VARCHAR2(30)
VALUE
VARCHAR2(128)
CONSUMER_GROUP
VARCHAR2(30)
STATUS
VARCHAR2(30)
DBA_RSRC_MANAGER_SYSTEM_PRIVS:
system
privileges for the resource manager
iSelfSchooling-SQL> desc DBA_RSRC_MANAGER_SYSTEM_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(3)
DBA_RSRC_MAPPING_PRIORITY: the consumer group mapping attribute priorities
iSelfSchooling-SQL> desc DBA_RSRC_MAPPING_PRIORITY;
Name
Null? Type
----------------------------- -------- --------------------
ATTRIBUTE
VARCHAR2(30)
PRIORITY
NUMBER
STATUS
VARCHAR2(30)
DBA_RSRC_PLANS: All the resource plans
iSelfSchooling-SQL> desc DBA_RSRC_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
PLAN
VARCHAR2(30)
NUM_PLAN_DIRECTIVES
NUMBER
CPU_METHOD
VARCHAR2(30)
ACTIVE_SESS_POOL_MTH
VARCHAR2(30)
PARALLEL_DEGREE_LIMIT_MTH
VARCHAR2(30)
&nbs |